Answer Posted / pankaj

1. Business Model


ADO is Connection-oriented Models used mostly
ADO.NET is Disconnected models are used:Message-like Models.


2. Disconnected Access

ADO Provided by Record set.
ADO.NET Provided by Data Adapter and Data set

3. XML Support

ADO Limited
ADO.NET Robust Support

4. Connection Model

ADO Client application needs to be connected always to
data-server while working on the data, unless using
client-side cursors or a disconnected Record set

ADO.NET Client disconnected as soon as the data is
processed. DataSet is disconnected at all times.

5. Data Passing

ADO objects communicate in binary mode.
ADO.NET uses XML for passing the data.

What is the difference between ADO and ADO.Net?

1020

---

Is bulk insert faster than insert?

856

---

What is the full form of ado?

933

---

What are different layers of ADO.Net?

1036

---

Define Execute Scalar?

949

---

How will you fill the gridview by using datatable object at runtime?

978

---

What is a column variable?

871

---

Explain ODP.net

937

---

Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!

2088

---

What is Dataset Object?

962

---

What is ado.net objects?

903

---

How do you merge 2 datasets into the third dataset in a simple manner?

944

---

What is difference between datagridview and datagrid control in winforms?

954

---

What is ole used for?

887

---

Which namespaces are used for data access?

1117

---