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
What is command class in ado.net?
Explain sqlconnection object?
Is it possible to load multiple tables in a Dataset?
What is the use of ADO.NET and XML web services?
What are ado.net objects?
What are the data providers used in ado.net
What is the difference between Data adaptor and Data set?
What is the use of SqlCommand object?
Name which operations can you not perform on an ado.net dataset?
What is ado connection?
How to generate a single aggregate?
How to pass values into a datatable?
What is sqlconnection and sqlcommand?
how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?
What is the executescalar method?