Answer Posted / deepak
DataReader:- is a predefined class that access the data
forward only and read only mode,and it belongs to connected
architechure.
Dataset:- is a buffer location between database and
application.All the manipulation are done here rather than
directly database.it belongs to disconnected architechure.
DataTable:- is the collection of rows and columns in the
dataset.In other sentence,The table in the dataset is called
DataTable.
| Is This Answer Correct ? | 19 Yes | 1 No |
Post New Answer View All Answers
What is an ado?
Explain what are the steps to connect to a database?
Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?
How to bind the controls(best practice) comboboxes to the data in the dataset?
Can you explain how to enable and disable connection pooling?
What are the namespaces used in ado.net for data access?
How do you update a dataset in ado.net and how do you update database through dataset?
Explain ODP.net
How to maintain the relation between two tables in ADO.NET?
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?
How to work with disconnected data - the dataset and sqldataadapter?
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?
What is the difference between sqldatareader and sqldataadapter?
How can we load multiple tables in to dataset?
Which is the feature of ado.net?