Authenticate User ID and Password from DB in ASP.NET with ADO.NET

Question

Hi Guys How I can authenticate an user with login id and password in ASP.NET with C# via ADO.NET . Kindly advise me in this regard. Thanks Itz.Irshad

Satyapriya Nayak · Answer

Hi Itz Perhaves you need a login page Untitled Page Width=100px BackColor=#FFFF66 ForeColor=#FF3300> Width=100px BackColor=#FFFF66 ForeColor=#FF3300> TextMode=Password Width=100px> BackColor=#CCFF99 onclick=btn_login_Click /> using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace login_using_parameter { public partial class _Default : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; string str = null; SqlCommand com; protected void btn_login_Click(object sender EventArgs e) { object obj = null; SqlConnection con = new SqlConnection(strConnString); con.Open(); str = select count(*) from login where UserName=@UserName and Password =@Password; com = new SqlCommand(str con); com.CommandType = CommandType.Text; com.Parameters.AddWithValue(@UserName TextBox_user_name.Text); com.Parameters.AddWithValue(@Password TextBox_password.Text); obj = com.ExecuteScalar(); if ((int)(obj) != 0) { lb1.Text = WELLCOME ::  + TextBox_user_name.Text; } else { lb1.Text = invalid user name and password; } con.Close(); } } } Thanks If this post helps you mark it as answer

Muhammad Irshad · Answer

Dear Satyapriya Thanks for your help. It helps me a lot. Irshad