Answer Posted / tejas mer

ADO.Net provides the base classes to access the or deal with DataBase.

The classes or namespaces depends on the type of provider we are using (like Sytem.Data.SqlClient for SQL Sever or System.Data.Oracleclient) for Oracle...

It also contains few common classes like
DBConnection
DBCommand to establish connection and execute commands respectively..

Below are the list of the classes widly used from ADO.NEt

DataSet
SQLConnection
SQLCommand
SQLDataAdapter
DataTable
DataView
SQLDataReader


Few methods widly used

DataSet.AcceptChanges();
Dataset.RejectChanges();

DataReader.ExecuteNonQuery();
DataReader.ExecuteScalar();
DataReader.ExecuteReader();


DataAdapter.Fill(DataSet);

What is bubbled event can you please explain?

1108

---

Data reader read and forward only, how is it possible to get 2 tables of data at a time?

968

---

What is command class in ado.net?

1099

---

What are the important features of ado.net 2.0?

1116

---

What do you mean by ‘batch updates’?

1090

---

What is an example of ordinal data?

1239

---

What is difference between executequery and executeupdate?

1097

---

Is it possible to load multiple tables in a Dataset?

1147

---

How we can provide data to ado.net?

1128

---

What is data relation in ado.net?

1141

---

Define table relations?

1034

---

Explain the advantage of ADO.Net?

1038

---

What is a serialized object?

1109

---

What is the role of the dataset object in ado.net?

1155

---

How to create dynamic gridview?

1083

---