Diff. b/w DataReader and DataSet?

Answer Posted / sandeep singh shekhawat

Data Reader is forword only it read one by one row. when it reach end the table then need to another connection open for it. it object create by command object method execute reader.

Data set is used for disconnect approch.It can have more than one table.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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?

620


Which keyword is used to accept variable number of parameters?

692


Explain how can we load multiple tables in to dataset?

504


What is ole in vb?

518


Which architecture does Datasets follow?

589






What are different layers of ADO.Net?

594


What is Data Provider?

576


What is a datagridview?

522


What are the 3 major types of connection objects in ado.net?

551


I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?

558


What is executequery?

503


What is executenonquery ado.net?

504


Data reader read and forward only, how is it possible to get 2 tables of data at a time?

502


Explain the difference between data reader and data adapter?

516


What are the ado.net components?

530