comparsion textvalue with database value and loginsuccessful

Question

how to compare the text value with database value and login successfull

Satyapriya Nayak · Answer

Login.aspx Untitled Page function Validate() { var UName=document.getElementById('TextBox_user_name'); var Password=document.getElementById('TextBox_password'); if((UName.value=='') || (Password.value=='')) { alert('UserName or Password should not be blank'); return false; } else { return true; } } BackColor="#CCFF99" OnClientClick="Validate()" onclick="btn_login_Click" /> Login.aspx.cs 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_related_details { public partial class Login : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlCommand com; SqlDataAdapter sqlda; string str; DataTable dt; int RowCount; protected void btn_login_Click(object sender, EventArgs e) { string UserName = TextBox_user_name.Text.Trim(); string Password = TextBox_password.Text.Trim(); SqlConnection con = new SqlConnection(strConnString); con.Open(); str = "Select * from Login"; com = new SqlCommand(str); sqlda = new SqlDataAdapter(com.CommandText, con); dt = new DataTable(); sqlda.Fill(dt); RowCount = dt.Rows.Count; for (int i = 0; i { UserName = dt.Rows[i]["UserName"].ToString(); Password = dt.Rows[i]["Password"].ToString(); if (UserName == TextBox_user_name.Text && Password == TextBox_password.Text) { Session["UserName"] = UserName; Response.Redirect("Details.aspx"); } else { lb1.Text = "Invalid User Name or Password! Please try again!"; } } } } }

Hanook · Answer

SqlConnection con = new SqlConnection ( ConfigurationManager .ConnectionStrings[ "DatabaseConnection" ].ConnectionString); con.Open(); SqlCommand cmd = new SqlCommand ( "select * from Users where UserName =@username and Password=@password" ,con); cmd.Parameters.AddWithValue( "@username" , txtUserName.Text); cmd.Parameters.AddWithValue( "@password" , txtPassword.Text); SqlDataAdapter da = new SqlDataAdapter (cmd); DataTable dt = new DataTable (); da.Fill(dt); if (dt.Rows.Count>0) { Response.Redirect( "Profile.aspx" ); }

Jaganathan Bantheswaran · Answer

Hi, Here is an example.

comparsion textvalue with database value and loginsuccessful

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)