Answer Posted / dinesh gupta

string
ConnectionString= "server="+DatabaseSrvr+";database="+Datab
aseNam+";user id="+DatabaseUsr+";password="+DatabasePass
;

Sqlconnection Cn = new SqlConnection(ConnectionString);
Cn.Open();

SqlCommand cmd = new SqlCommand("PROCNAME", Cn);

cmd.CommandType = CommandType.StoredProcedure;

SqlParameter p = new SqlParameter();

p = new SqlParameter();
p.ParameterName = "@parameter1";
p.SqlDbType = SqlDbType.VarChar;
p.Size = 10;
p.Value = "abc";
p.Direction = ParameterDirection.Input;
cmd.Parameters.Add(p);

p = new SqlParameter();
p.ParameterName = "@parameter2";
p.SqlDbType = SqlDbType.Int;
p.Value = Convert.ToInt16(textbox.text);
p.Direction = ParameterDirection.Input;
cmd.Parameters.Add(p);


cmd.ExecuteNonQuery();

Explain all the classes those are used for database connections between sql server and asp.net?

753

---

Which is the feature of ado.net?

741

---

What are the main differences between classic ado and ado.net?

745

---

What is ado.net and its architecture?

717

---

Describe ado.net object model in detail.

753

---

What is microsoft ole db provider for sql server?

661

---

What is the difference between Dataset. clone and Dataset.copy?

779

---

What is fill method in ado.net?

721

---

Explain the difference between data reader and data adapter?

711

---

What is the difference between oledb sql server and oledbdotnet provider?

740

---

How do I delete a row from a DataTable?

784

---

What does executenonquery () method return?

687

---

What is the executescalar method?

789

---

How can you identify whether or not any changes are made to the DataSet object since it was last loaded?

790

---

What are the types of databinding?

732

---