Answer Posted / suman zalodiya

SqlConnection con = new SqlConnection("Your Databse
Connection String");

SqlCommand cmd = new SqlCommand("Stored Procedure Name",
con);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.Add("@source", SqlDbType.VarChar, 50).Value
= TextBox1.Text;

cmd.Parameters.Add("@destination", SqlDbType.VarChar,
50).Value = TextBox2.Text;

con.Open();

cmd.ExecuteNonQuery();
con.Close();

What are the differences between OLEDB and SQLClient Providers?

1243

---

What are the Data providers in ADO.Net?

1069

---

What is the difference between data reader and data adapter?

1074

---

Compare Data Reader & Dataset in ado.net?

1048

---

What are the advantages and disadvantages of using datalist?

1146

---

How can we save all data from dataset?

1049

---

What is difference between datatable and dataset?

1131

---

What is a dynaset in access?

1109

---

Explain the differences between oledb sql server, oledbdotnet provider?

1055

---

If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?

1101

---

What is dataset and datatable in ado.net?

1043

---

What is a control toolbox?

1022

---

What is data control techniques?

1002

---

What is sqldatasource?

979

---

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

1048

---