Login with Stored Procedure
protected void Button_Click(object sender, EventArgs e)
{
try
{
con.Open();
CommandType = CommandType.StoredProcedure;
cmd.CommandText = "getAuth";
cmd.Parameters.Add("@e", SqlDbType.Char).Value = txtemail.Text.Trim().Replace("'", "");
cmd.Parameters.Add("@p", SqlDbType.Char).Value = txtpwd.Text.Trim().Replace("'", "");
cmd.Parameters.Add("@s", SqlDbType.Char).Value = "true";
adp.Fill(ds, "vt");
if (ds.Tables["vt"].Rows.Count == 0)
{
lb.text="Invalid Username !";
}
else
{
Session["email"] = txtemail.Text;
Response.Redirect("~/user/welcome.aspx");
}
}
catch
{
}
}
Create Stored Procedure
create procedure getAuth @e varchar(50), @p varchar(20),@s varchar(20)
as
select * from register
where email=@e and pwd=@p and status=@s
