Interested to Buy Any Domain ? << Click Here >> for more details...
once data is fetched into dataset connection gets closed. but in datareader
connection is always maintained...then why datareader is fast and mainly
recommended ?
- 2 Answers
- 5915 Views
- I also Faced
- E-Mail Answers
Answer Posted / hhh
DataSet carry considerable overhead because of relations,
multiple tables,
While DataReader only readony and fawardonly stream of
data, it fatch only one row at a time. thats y its faster
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is sqldatareader?
What is difference between datagridview and datagrid control in winforms?
What are the Features and disadvantages of dataset
Is it possible to edit data in Repeater control?
how to create a quiz software using 4 options to answer and how to check with answers in the database and award marks....
Define data access layer?
How do I delete a row from a DataTable?
Explain what are acid properties?
What is difference between datatable and dataset?
Which parameter of ConnectionString is used to specify the name of the database?
What is sql connection in ado.net?
Describe the command object and its method.
What are the namespaces used in ADO.Net to connect to a database?
how can implement dropdownlist in particular of dataset when try to update?
What is data access pattern?
