Answer / skmdali786

Similar to the DataSet, a Recordset could be disconnected from
its data store and therefore act as an in-memory cache of
data. Of course, it could also be used in a connected model
depending on the cursor options that were set. Although the
Recordset object stored multiple versions of each column for
each of its rows, it was not by nature able to represent
multiple tables without the use of the Data Shape Provider.
The Recordset was not XML-based and could not be serialized to
XML easily or flexibly. Finally, a Recordset was not
independent of a data store because it tracked a Connection
object and through its methods could send queries to the data
source to populate, update, and refresh its data. To that end,
the Recordset contained functionality found in the ADO.NET
DataSet, data reader, and data adapter objects.

Answer / guest

1) With Data set you can retrive data from database like
oracle and SQL Server and manage them in one dataset, with
recordset this is not possible.

2) All representation of Dataset is using XML while
recordset uses COM.

What is datatable in ado.net?

0 Answers  

---

Explain what is datagrid with an example?

0 Answers   C DAC, CDAC,

---

What are the two fundamental objects in ADO.NET?

6 Answers  

---

IF we have lot of records in Database. How we can handle them?

5 Answers   Honeywell,

---

What is commandbuilder in ado.net?

0 Answers  

---

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,

---

Which is faster sqldataadapter and sqldatareader?

0 Answers  

---

Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.

0 Answers  

---

What is the difference between ado.net and oledb?

0 Answers  

---

Where is adodb dll located?

0 Answers  

---

What are the different ado.net namespaces?

0 Answers  

---

What is acid in ado.net?

0 Answers  

---