Validation while login

Question

How to put validation while doing login?

Satyapriya Nayak · Answer

Hi Sandeep If this is a web application Try this... 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]; } } } Thanks If this post helps you mark it as answer

Harsh Kapoor · Answer

Hi Sandeep You can put Required field validation as: Name: Age: ControlToValidate=name Text=The name field is required! runat=server /> and Custom validator as if authentication failed: Custom text: br /> asp:TextBox runat =server id =txtCustom /> asp:CustomValidator runat =server id =cusCustom controltovalidate =txtCustom onservervalidate =cusCustom_ServerValidate ValidationGroup=btn errormessage =Login failed! /> br /> br /> In .cs file private void IsUserAuthenticate(string userName string pwd) { if (IsAuthorised ) e.IsValid = true ; else e.IsValid = false ; } Thanks and Regards Harsh

Nattudurai Eswaramurthy · Answer

You could use the inbuild login control or validate it in SQL and send the bool flag from there based on that decide

Kunal Vaishya · Answer

first check user exist or not then after check password is valid or not