Differentiate between Dataset and Recordset.

Answer Posted / 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.

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the Features of a dataset

663


What are the connected and disconnected modes in ado.net?

481


What provider ado.net use by default? Explain the role of data provider in ado.net?

523


What is a column variable?

499


What is data access pattern?

491






What is an example of ordinal data?

485


How do you update a dataset in ado.net and how do you update database through dataset?

480


How can we check that some changes have been made to dataset since it was loaded?

513


If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?

611


What are the different ado.net namespaces?

620


What is difference between dataset and datatable?

511


What does executenonquery () method return?

498


What is a sqldataadapter?

522


Which is faster datareader or dataadapter?

524


Explain what are the steps to connect to a database?

491