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
- 17647 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
What are the disadvantages of using datalist?
What are the data providers used in ado.net
What is ole access?
How can we check that some changes have been made to dataset since it was loaded?
What are the various methods provided by the DataSet object to generate XML?
What are the namespaces used in ado.net for data access?
What is a string variable?
How will you fill the gridview by using datatable object at runtime?
What are all the different authentication techniques used to connect to MS SQL Server?
Why is ADO.NET serialization slower than ADO ?
What are advantages of microsoft-provided data provider classes in ado.net?
Can we do database operations without using any of the ado.net objects?
Which object holds only data and does not interact with data source?
What is the difference between data reader and data adapter?
Which is faster entity framework or ado.net?
