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
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?
Which keyword is used to accept variable number of parameters?
Explain how can we load multiple tables in to dataset?
What is ole in vb?
Which architecture does Datasets follow?
What are different layers of ADO.Net?
What is Data Provider?
What is a datagridview?
What are the 3 major types of connection objects in ado.net?
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?
What is executequery?
What is executenonquery ado.net?
Data reader read and forward only, how is it possible to get 2 tables of data at a time?
Explain the difference between data reader and data adapter?
What are the ado.net components?