Dataset Vs Datareader Which One to Use Where
An example might be using a reader to populate a dropdownbox and a dataset for a grid of data. Since a DataSet is serializable it can serve. Connected And Disconnected Architecture Connection Learning Database DataAdapter is an intermediate layer middleware which acts a bridge between the DataSet and a Database whereas DataReader provides forward-only read-only access to data using a server-side cursor simply put it is ued to read the data. . Using the DataReader can increase application performance both by retrieving data as soon as it is available and by default storing only one row at a time in memory reducing system overhead. The choice between SqlDataReader and DataSetDataTable is essentially one of the performance vs functionality issue. DataSet or DataTable - use SqlDataAdapter to generate it 2. 10 seconds to catch 1000 records. I can easily see that blue is way faster than pink though. A DataSet can be modified and...