Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9 Answers
- 17971 Views
- Wipro, I also Faced
- E-Mail Answers
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
How can you identify whether or not any changes are made to the DataSet object since it was last loaded?
Command objects uses, purposes and their methods.
What is ado.net and its architecture?
What is difference between datagridview and datagrid control in winforms?
Can we do database operations without using any of the ado.net objects?
What is the difference in an abstract class and an interface?
What is microsoft ole db provider for sql server?
Why do we serialize data?
Explain what are acid properties?
What do you know about ado.net's objects?
How to identify the controls which can be used for binding data?
How does ado.net work?
Explain all the classes those are used for database connections between sql server and asp.net?
Explain ado.net features?
What is the difference between sqlcommand and sqldataadapter?
