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

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

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)