Answer Posted / ramakrushna

SqlConnection con = new SqlConnection();
con.ConnectionString = "server=munapc;
database=project1; User ID=sa; Password=niit";
con.Open();

string query = "select * from emp";
SqlDataAdapter da = new SqlDataAdapter(query, con);
SqlCommandBuilder cmd = new SqlCommandBuilder(da);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;

con.Close();

Explain how to call the sql commands asynchronously in ado.net version 2.0?

887

---

What is sqldatareader?

880

---

Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.

949

---

What are all the classes that are available in System.Data Namespace?

963

---

What is executenonquery ado.net?

892

---

Explain the different row versions available in table?

982

---

What are the Features of a dataset

1191

---

Is datareader faster than datatable?

918

---

What is ole word?

897

---

What is the DataTableCollection?

1003

---

How can we perform transactions in .net?

1000

---

What are all components of ADO.Net data provider?

1010

---

What is an example of ordinal data?

1052

---

What is the role of data provider in ado.net?

943

---

Explain the namespaces in which .net has the data functionality class.

1012

---