i have two textboxes one for user name and another for
password . i have a table name compare(which contains
name,passwod etc.,)my doubt is how compare username
textbox with name column and how compare password textbox
with passwod column. i want the code
Answer Posted / rahul dabur
//Make a store procedue with name dbologin
Create PROCEDURE dbologin
(
@uid varchar(50),
@Pass varchar(50)
)
AS
declare @pwd varchar(50)
select @pwd=Password from tbllogin where UName=@uid and
Password=@Pass
if @pwd is null
return 1
else if @pwd=@Pass
return 2
//At a button click event with connected approach
protected void btnlogin_Click(object sender, EventArgs e)
{
// string textStr ;
SqlCommand cmd = new SqlCommand("dbologin", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@uid", SqlDbType.VarChar,
50).Value = Convert.ToString(txtusername.Text);
cmd.Parameters.Add("@Pass", SqlDbType.VarChar,
50).Value = Convert.ToString(txtpassword.Text);
// textStr = Convert.ToString(txtpassword.Text);
//textStr = cmd.Parameters.Add("@Pass",
SqlDbType.VarChar, 50).Value.ToString();
// textStr = cmd.Parameters.Add("@Pass",
SqlDbType.VarChar, 50).Value;
SqlParameter p1 = new SqlParameter("@s", SqlDbType.Int);
p1.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(p1);
cmd.ExecuteNonQuery();
Int32 k = Convert.ToInt32(cmd.Parameters["@s"].Value);
if (k == 1)
{
Label1.Text = "Wrong UserName and password";
}
else
{
Label1.Text = "Right UserName and Password";
Response.Redirect("calculator.aspx");
}
cmd.Dispose();
con.Close();
txtusername.Text = string.Empty;
txtpassword.Text = string.Empty;
// Response.Redirect("calculator.aspx");
}
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the different methods available under the sqlcommand class to access the data?
What is openquery?
What are the pre-requisites for connection pooling?
Explain the difference in an abstract class and an interface?
What do you mean by performing asynchronous operation using command object?
Does executenonquery return a value?
What is untyped dataset?
Why do we need ado.net?
Explain which name space is used to get assembly details?
How to bind the controls(best practice) comboboxes to the data in the dataset?
How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?
How to create data relations?
Which object is used to add relationship between two Datatables?
What is XML serialization
Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?