Help Regarding Login page

Question

hi,

i want to create login page with 2 labels for username and password,2text boxes,and 3 buttons for login,signup,cancel.if i press login button means the data's(username,password) are retrived from the sqlserver.and if i click signup means i want to enter some(firstname,lastname,age....) details.i don't know how to i do it.please help me.if i click cancel button means the page is exit from the server.

thanks & regards

gokilavasan

Satyapriya Nayak · Answer

Hi Gokilavasan, For sign up Untitled Page 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 Register_using_param { public partial class WebForm1 : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings["MyConsString"].ConnectionString; string str; SqlCommand cmd; protected void Button1_Click(object sender, EventArgs e) { SqlConnection con = new SqlConnection(strConnString); con.Open(); str="INSERT INTO test VALUES (@amount, @description)"; cmd = new SqlCommand(str,con); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@amount", Convert.ToInt64(txt_amount.Text)); cmd.Parameters.AddWithValue("@description", rtxt_description.Text); cmd.Connection = con; cmd.ExecuteNonQuery(); con.Close(); Response.Write("Records Inserted"); } } } For login 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

gokilavasan m · Answer

very very very thank u

gokilavasan m · Answer

very very very thank you

Senthilkumar · Answer

Hi, Step 1: Create the sql server table. CREATE TABLE Users ( UserID INT IDENTITY(1,1) PRIMARY KEY ,FirstName VARCHAR(100) ,LastName VARCHAR(100) ,UserName VARCHAR(100) ,Password VARCHAR(100) ,Address VARCHAR(100) ,LastUpdatedDate DATETIME DEFAULT GETDATE() ) Step 2: Design the login page: Untitled Page User name: Password: onclick="btnSignin_Click" />  Don't have user id? then onclick="lbtnsignup_Click"> Code File: 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; public partial class Default3 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void btnSignin_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(txtUserName.Text) && !string.IsNullOrEmpty(txtPassword.Text)) { SqlConnection sqlConnection = new SqlConnection(); sqlConnection.ConnectionString = @"Data Source=SS438\SQLEXPRESS;Initial Catalog=Examples;Integrated Security=true;"; sqlConnection.Open(); string sqlQuery = "SELECT * FROM Users WHERE UserName=@UserName AND Password=@Password"; SqlCommand sqlCommand = new SqlCommand(sqlQuery, sqlConnection); sqlCommand.CommandType = CommandType.Text; sqlCommand.Parameters.Add("@UserName", SqlDbType.VarChar).Value = txtUserName.Text.Trim(); sqlCommand.Parameters.Add("@Password", SqlDbType.VarChar).Value = txtPassword.Text.Trim(); SqlDataReader sreader = sqlCommand.ExecuteReader(); string _userName = string.Empty; string _password = string.Empty; while(sreader.Read()) { _userName = sreader[3].ToString(); _password = sreader[4].ToString(); } sqlConnection.Close(); if (txtUserName.Text.Trim() == _userName && txtPassword.Text.Trim() == _password) { Response.Redirect("welcome.aspx"); } else { lblMessage.Text = "User name/password wrong! Try again!!"; } } else { } } protected void lbtnsignup_Click(object sender, EventArgs e) { Response.Redirect("Registration.aspx"); } } Step 3: If they don't have user id then registration page Untitled Page User Registration Form First Name: Last Name: Username: Password: Address: onclick="btnSubmit_Click" />   Text="Reset" onclick="btnReset_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; public partial class Registration : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void btnReset_Click(object sender, EventArgs e) { ClearFields(); } private void ClearFields() { txtFirstName.Text = ""; txtLastName.Text = ""; txtUserName.Text = ""; txtPassword.Text = ""; txtAddress.Text = ""; } protected void btnSubmit_Click(object sender, EventArgs e) { SqlConnection sqlConnection = new SqlConnection(); sqlConnection.ConnectionString = @"Data Source=SS438\SQLEXPRESS;Initial Catalog=Examples;Integrated Security=true;"; sqlConnection.Open(); string sqlQuery = "INSERT INTO Users(FirstName,LastName,UserName,Password,Address) VALUES(@FirstName,@LastName,@UserName,@Password,@Address)"; SqlCommand sqlCommand = new SqlCommand(sqlQuery, sqlConnection); sqlCommand.CommandType = CommandType.Text; sqlCommand.Parameters.Add("@FirstName", SqlDbType.VarChar).Value = txtFirstName.Text.Trim(); sqlCommand.Parameters.Add("@LastName", SqlDbType.VarChar).Value = txtLastName.Text.Trim(); sqlCommand.Parameters.Add("@UserName", SqlDbType.VarChar).Value = txtUserName.Text.Trim(); sqlCommand.Parameters.Add("@Password", SqlDbType.VarChar).Value = txtPassword.Text.Trim(); sqlCommand.Parameters.Add("@Address", SqlDbType.VarChar).Value = txtAddress.Text.Trim(); int irows = sqlCommand.ExecuteNonQuery(); lblMessage.Text = "User inserted successfully..."; ClearFields(); } }

Help Regarding Login page

Answers (4)