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

Validation while login

Answers (4)