Hi. For getting single column sql query like this
select column_name from table_name. also before going to develop login page or any authentication page.please read the document given link below.it may give some knowledge to you. http://www.unixwiz.net/techtips/sql-injection.html Thanks Nakkeeran.k On Tue, Sep 6, 2011 at 11:50 AM, Aruna Aruna <[email protected]> wrote: > Hey, > > Please try to change the query for getting single column > as > select count(*) from tbl_login.. > instead of > select * from tbl_login where ... > Thanks, > Aruna. > On Mon, Sep 5, 2011 at 8:35 PM, praveen singh <[email protected]>wrote: > >> My code is in root Web Config directory is:- >> *<authentication mode="Forms"> >> <forms loginUrl="MSAcess.aspx" defaultUrl="~/admin/home.aspx" /> >> </authentication>* >> and sub folder is:- >> *<authorization> >> <deny users="?"/> >> </authorization> >> >> *now my code in code behind file is:- >> >> * ocn1.Open(); >> cmd = new OleDbCommand("select * from tbl_login where UseName='" >> +txt_Username.Text + "' and Password='" +txt_Password.Text + "'", ocn1); >> int count = Convert.ToInt16(cmd.ExecuteScalar()); >> if (count > 0) >> { >> Response.Redirect("~/admin/home.aspx"); >> } >> else >> { >> lbl_error.Text = "Login Failed!"; >> } >> *where I go wrong please tell >> >> -- >> You received this message because you are subscribed to the Google >> Groups "DotNetDevelopment, VB.NET <http://vb.net/>, C# .NET, >> ADO.NET<http://ado.net/>, >> ASP.NET <http://asp.net/>, XML, XML >> Web Services,.NET Remoting" group. >> To post to this group, send email to [email protected] >> To unsubscribe from this group, send email to >> [email protected] >> For more options, visit this group at >> http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en >> or visit the group website at http://megasolutions.net >> > > -- > You received this message because you are subscribed to the Google > Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML > Web Services,.NET Remoting" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en > or visit the group website at http://megasolutions.net > -- You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/dotnetdevelopment?hl=en?hl=en or visit the group website at http://megasolutions.net
