Answer / hhh

ADO- Connection-Oriented Architecture
Use Record Set
Communicate in Binary mode

Ado.net Dis-connected architecture
Use DataSet,Adapter
Parse Data in XML mode

Answer / jyoti

ADO was a connected data access model, which means that when
a connection to the database is made, the connection remains
open until the application is closed.

ADO.NET is disconnected database access model, which means
when an application interacts with the database, the
connection is opened to serve the request of the
application, and is closed as soon as the request is completed.

All data is presented in XML, as compared to ADO.

Answer / babina

The old ADO (ActiveX Data Object) has evolved to ADO.NET in
the .NET Framework. The ADO.NET object is a lightweight
object. The ADO Recordset was a huge object in ADO. It
provided the ability to support multiple types of cursors.
It provided fast lightweight "firehose" cursor and also
supported a disconnected client-side cursor that supported
tracking, optimistic locking, and automatic batch updates of
a central database. However, all of this functionality was
difficult to customize.
ADO.NET breaks the functionality of the ADO object to
multiple classes, thereby allowing a focused approach to
developing code. The ADO.NET DataReader is equivalent to the
"firehose" cursor. The DataSet is a disconnected cache with
tracking and control binding functionality. The DataAdapter
provides the ability to completely customize how the central
data store is updated with the changes to a DataSet.

Answer / ramakrishna reddy

ADO- Connection-Oriented Architecture
Use Record Set
Communicate in Binary mode

Ado.net Dis-connected architecture
Use DataSet,Adapter
Parse Data in XML mode

What is difference between datagridview and datagrid control in winforms?

0 Answers  

---

What is aggregating data ?

0 Answers  

---

How can we add relation between tables in a dataset?

0 Answers  

---

how would i implement dropdownlist in gridview using c#

2 Answers  

---

List the 4 common ado.net namespaces?

0 Answers  

---

what is different between SqlCommand object and Command Behaviour Object

3 Answers  

---

What is ado.net full form?

0 Answers  

---

What is connection string?

0 Answers  

---

What are advantages and disadvantages of Microsoft-provided data provider classes in ADO.NET?

2 Answers  

---

i want 2 pass values(enterd in textbox)to table in sql server without using stored procedure in c#.plz tell me code with an example.

5 Answers   Softcon, Tecra,

---

How To Update A Column In A DataGrid Using C#.NET? I am getting InvalidCastException as (Specified cast is not valid) while updating 2nd column in a datagrid? Id,firstname,lastname are the three columns of my datagrid respectively. I wanted to edit the second column(lastname) and update it. I did the following code in DataGrid's updatecommand(),but failed to update ! Int varid=(int)DataGrid1.DataKeys[e.Item.ItemIndex]; TextBox lnm=(TextBox)e.Item.Cells[2].Controls[0]; string str=lnm.Text ; SqlCommand cmd=new SqlCommand("update customer set lastname='" + str + "' where id=" + varid + "",con); cmd.ExecuteNonQuery(); DataGrid1.EditItemIndex=- 1; DataGrid1.DataBind();

2 Answers   Mind Tree, TCS,

---

Define atomicity?

0 Answers  

---