Login

 protected void Button1_Click(object sender, EventArgs e)
    {
        con.Open();
        object i;
        cmd = new SqlCommand("SP_Login", con);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.AddWithValue("@Un", TextBox1.Text);
        cmd.Parameters.AddWithValue("@Pwd", TextBox2.Text);
        i = cmd.ExecuteScalar();
        if (Convert.ToInt32(i) == 1)
        {
            Response.Redirect("Registration.aspx");
        }
        else
        {
            Response.Write("Invalid UserName and Password");

        }
        con.Close();
    }

CREATE proc [dbo].[SP_Login]

@Un varchar(20),
@Pwd varchar(20)
as
declare @chk as int
if exists (
select *from tbl_Login where Un =@Un and Pwd =@Pwd)

set @chk =1

else

set @chk=0
select @chk