Notice: These data have been collected from a variety of public sources.
Data Reader Data Reader is used to read the data from database and it is a read and forward only connection oriented architecture during fetch the data from database.
Data Reader will fetch the data very fast when compared with dataset.
This dataadapter object is used to read the data from database and bind that data to dataset.
Dataadapter is a disconnected oriented architecture.
I was able to get the Combo Box populated with the table names available in the Data Set by iterating through But I only got the column headers.
Then I read that I need a Table Adapter to populate the Data Set with that table. These are the mechanics of working with disconnected data.Because the applications holds on to connections only when necessary, the application becomes more scalable.In Lesson 3, we discussed a fully connected mode of operation for interacting with a data source by using the Sql Command object.In Lesson 4, we learned about how to read data quickly an let go of the connection with the Sql Data Reader.Also Data Set provides you with rich features like saving data as XML and loading XML data.