SQL connection in Login page using asp.net c#?

[katelva]

Hi, I create a login page in asp.net c# but I do not know the SQL connection to connect the SQL and check the username and password? Mostly I search online is about VB not asp.net #. Anyone can help me? Thanks. Regards, Katelva

[N a v a n e e t h]

Are you using inbuilt login control ?

katelva wrote:

I do not know the SQL connection to connect the SQL and check the username and password?

System.Data.SQLClient is the namespace where ADO.NET classes used for communicating with SQL server are located. Use SQLConnection to create a connection. Use SQLCommand for supplying a query. Use SQLDataReader for reading the data.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia How to use google | Ask smart questions

[katelva]

Hi, Thanks for your information. But, I am wondering how to I validate the user input with SQL database using asp.net C#? For example, I create a login.aspx and I put the code in login.aspx.cs. I have put the SQL connection inside but I do not know how to I validate user input with SQL database? Do you have any good websites suggested for that? Mostly I search is in VB.net not asp.net in C#. I don't know the asp.net C# syntax of checking the user input with SQL database? Thanks. Regards, Katelva

[katelva]

Hi, Thanks for your information. But I am wondering how to I validate the user input with SQL database? I have created a login.aspx with user input username and password, I put the code in login.aspx.cs,but I am not sure the syntax for asp.net in C#. So far, all the codes I search are for VB.net. I am not sure how do I validate user input with SQL database using asp.net in C#? Do you have any recommended websites for this? Thanks. Regards, Katelva