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