Answer Posted / manumole

SqlConnection conn = new SqlConnection("Data
Source=MYSERVER;Initial Catalog=Northwind;User
Id=sa;Password=sa;");
conn.Open();
DataTable dt=new DataTable();
SqlDataAdapter da = new SqlDataAdapter("select
* from Employees", conn);
da.Fill(dt);
testGV.DataSource = dt;

how Sequence to connect and retrieve data from database using dataset?

1355

---

What providers does Ado.net uses?

1064

---

How do I delete a row from a DataTable?

1236

---

What is ado.net code?

974

---

What is the difference between executenonquery () and executescalar ()?

1002

---

Explain the advantages and disadvantages of using datalist?

1114

---

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

1062

---

What is commandbuilder in ado.net?

1100

---

How can we add relation between tables in a dataset?

1047

---

describe the dataset object in ado.net.

996

---

Which control of the BindingNavigator returns the current position within the data source?

1210

---

What are the steps you will take to improve performance? Will you use dataset or datareader?

1050

---

Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?

918

---

What is difference between datatable and dataset?

1130

---

What is ado.net full form?

1037

---