login page

Question

how to create alogin page in asp.form codes

Satyapriya Nayak · Answer

Stored Procedure CREATE procedure login_pro ( @UserName varchar(50), @Password varchar(50) ) as declare @status int if exists(select * from Login where UserName=@UserName and Password=@Password) set @status=1 else set @status=0 select @status Default.aspx Untitled Page Width="100px" BackColor="#FFFF66" ForeColor="#FF3300"> ControlToValidate="TextBox_user_name" ErrorMessage="Please enter username"> Width="100px" BackColor="#FFFF66" ForeColor="#FF3300"> TextMode="Password" Width="100px"> ControlToValidate="TextBox_password" ErrorMessage="Please enter password"> BackColor="#CCFF99" onclick="btn_login_Click" /> Default.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_Page_Using_Stored_Procedure { public partial class _Default : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlCommand com; SqlParameter UserName, Password; protected void btn_login_Click(object sender, EventArgs e) { UserName = new SqlParameter(); Password = new SqlParameter(); SqlConnection con = new SqlConnection(strConnString); com=new SqlCommand(); com.Connection = con; con.Open(); Session["UserName"] = TextBox_user_name.Text; com.CommandType = CommandType.StoredProcedure; com.CommandText = "login_pro"; UserName.SqlDbType = SqlDbType.VarChar; UserName.Size = 50; UserName.ParameterName = "@UserName"; UserName.Value = TextBox_user_name.Text.ToString(); UserName.Direction = ParameterDirection.Input; Password.SqlDbType = SqlDbType.VarChar; Password.Size = 50; Password.ParameterName = "@Password"; Password.Value = TextBox_password.Text.ToString(); Password.Direction = ParameterDirection.Input; com.Parameters.Add(UserName); com.Parameters.Add(Password); int status; status = Convert.ToInt16(com.ExecuteScalar()); if (status == 1) { Response.Redirect("Welcome.aspx"); } else { lblmessage.Text = "Invalid UserName and Password..."; } con.Close(); } } } Welcome.aspx Untitled Page Welcome.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; namespace Login_Page_Using_Stored_Procedure { public partial class Welcome : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { lb1.Text = "WELLCOME :: " + Session["UserName"]; } } }

Iftikar Hussain · Answer

Hi, Please refer the below link http://www.aspdotnet-suresh.com/2011/12/how-to-create-simple-login-form-using.html http://www.dotnetfunda.com/articles/article808-how-to-write-a-simple-login-page-in-aspnet.aspx Regards, Iftikar

login page

Answers (2)