What are the differences between Dataset and DataReader?
Answer Posted / kautilya
Dataset is in memory representation of the Database. where
you can create tables, relations between tables, add
primary key to tables and also manipulate the data
retrieved form the database. It allows us to work in
connection less environment.
Datareader is like forward only readonly cursor, which is
used to retrieve data. data manipulation is not possible
while using datareader. datareader continously keeps the
connection open.
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
What is difference between web config and global asax?
What is recordset asp?
Define globalization and localization.
What are directives in asp.net?
Why do I get error message "could not load type" whenever I browse to my asp.net web site?
Differentiate between authentication and authorization.
Explain the difference between debug.write and trace.write?
Can you dynamically assign a Master Page?
What is difference between or and orelse?
Give an example of cookie abuse.
What are the three parts of an http response?
What are the different ways you would consider sending data across pages in ASP (i.e between asp to asp)?
Explain the benefits of viewstate?
Define view state.
Difference between Response.redirect vs server.transfer?