Login

Question

simple login screen check with database if username and password are correct in the database.

if username typed and password does not type show message please type your username.

if password typed and username does not type show message please type your password.

check username and password must match with the data base.what i typed username and password in database.

Satyapriya Nayak · Answer

Hi narasiman, Try this... 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

Pramod Kumar Nandagiri · Answer

Hi narasiman, try with the below code in source code page : UserName: ID="RequiredFieldValidator1" runat="server" Text="Please enter username" ControlToValidate="txtusername"> Password: ID="RequiredFieldValidator2" runat="server" Text="Please enter password" ControlToValidate="txtpassword"> onclick="btnsubmit_Click" /> onclick="btnreset_Click" CausesValidation="False" /> In Codebehind page protected void btnsubmit_Click(object sender, EventArgs e) { if (ValidateUser(txtusername.Text, txtpassword.Text)) { Response.Redirect("Home.aspx"); } else { Response.Write(@"Invalid User/Password"); } } private bool ValidateUser(string username, string pwd) { string strsql = "select AdminName from Admin where AdminName='" + txtusername.Text + "' and AdminPwd='" + txtpassword.Text + "'"; SqlConnection con = new SqlConnection(strcon); SqlCommand cmd = new SqlCommand(strsql, con); cmd.Connection.Open(); SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); return (dr.Read()); /// go to database with username and password get true false } Please don't forget to mark the thread as "Accepted Answer" if it helps you

Login

Answers (2)