Validation while login

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

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Login_Page_Using_Stored_Procedure._Default" %>





   


   

   

   
                 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

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Welcome.aspx.cs" Inherits="Login_Page_Using_Stored_Procedure.Welcome" %>





   


   

   

   

   

   

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

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

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