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 datareader faster than datatable?

1020

---

Why is it important to close an ado.net application?

1078

---

What is execute scalar in ado.net?

1021

---

Define executenonquery?

964

---

Explain what are the steps to connect to a database?

1019

---

How to retrieve the user id which is provided while windows authentication?

1152

---

In how many ways we can retrieve table records count? How to find the count of records in a dataset?

1050

---

What is difference between datatable and dataset?

1133

---

What are the major difference between classic ADO and ADO.NET?

1057

---

What is openquery?

1038

---

Can datareader hold data from multiple tables?

1229

---

Explain sqlconnection object?

1067

---

How do you update a dataset in ado.net?

1064

---

List all the steps in order, to access a database through ado.net?

1128

---

What is the difference between SqlCommand and SqlCommandBuilder?

1141

---