Answer / subramaniam

ADO is a com base library that supports only connected
data. This means that when we access the data (view, edit
and update) it is affected in real-time,since the
connection is being used all the time. ADO uses the objects
as reference data known as Recordset object. Hence it
basically gives a single table view of the data. We can
also join tables to create a new set of records in ADO.ADO
allows to create only client-side cursors. Using ADO we can
persist records in XML format and XML integration is not
possible.

ADO.NET is a CLR based library that supports disconnected
recordsets. This means that When we access data, ADO.NET
makes a copy of the data using XML and holds the connection
to pull down the data or to make any requested updates as
long as we need. The best method to follow is
ADO.NET.ADO.NET uses various objects known as Dataset that
allow to access data in various methods. Hence it allows to
store the relational model of the database and helps us to
access /update the data in each related table individually.
ADO.NET supports both client-side and server-side cursors.
Also the cursors are handled as classes in ADO.NET
providing a way to create efficient applications. Using
ADO.NET we can manupulate records in XML format. Also
ADO.NET 2.0 provides Multiple Active ResultSets (MARS)
which allows to have two datareader on one connection open
at sametime.

Answer / pranshu sharma

In ADO, the in-memory representation of data is the
recordset. In ADO.NET, it is the dataset. There are
important differences between them.

Explain the advantage of ADO.Net?

0 Answers  

---

What are the Data providers in ADO.Net?

0 Answers  

---

Which method is used by command class to execute SQL statements that return single value?

0 Answers  

---

Define bubbled event?

0 Answers  

---

What is the advantage of ado.net?

0 Answers  

---

FetCh Records No 5 to 10 From Dataset

4 Answers  

---

Explain the architecture of ado.net?

0 Answers  

---

What are the drawbacks of using ado.net?

0 Answers  

---

Differnce between Stored procedure and user defined functions?

17 Answers   Microsoft, Symphony,

---

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,

---

What is the difference between Command and CommandBuilder object?

0 Answers  

---

What is a sqldataadapter?

0 Answers  

---