Difference between datareader and dataset?
Answer Posted / jayeshwaree
datareader:
*connected enviornment
*reads one row at a time. By using Read() we can read the
read records of one row
*used to retrieve data as it returns a result set in a read
only and forward only mode
dataset:
*disconnected enviornment
*it is used as a container to hold one or more tables with
constraints and relations
*to update the changes made in dataset we need a data
adapter and we need to call the Update() method
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How do I delete a row from a DataTable?
can we create synonymn in ms access,sql server,my sql if so explain me with example
What is the difference between sqldatareader and sqldataadapter?
Explain all the classes those are used for database connections between sql server and asp.net?
What is the meaning of object pooling?
What is command class in ado.net?
What are the ado.net connection pooling parameters?
What does ado stand for?
how we can fire event in databound coulm in datagfrid withot using button?
How to bind the controls(best practice) comboboxes to the data in the dataset?
What is aggregating data ?
Command objects uses, purposes and their methods.
What are the different ado.net namespaces are available in .net?
Describe the command object and its method.
What is the role of the dataset object in ado.net?