Create object of data adapter and call the fill command method of the adapter.
SqlDataAdapter objAdapter = new SqlDataAdapter(objCommand);
DataSet objDataset = new DataSet();
How can we save all data from dataset?
Dataset has “AcceptChanges” method, which commits all the changes since last time “Acceptchanges” has been executed.
How can we load multiple tables in a Dataset?
objCommand.CommandText = "Table1"
objCommand.CommandText = "Table2"
Above is a sample code, which shows how to load multiple “Data Table” objects in one “Dataset” object. Sample code shows two tables “Table1” and “Table2” in object ObjDataSet.
lstdata.DataSource = objDataSet.Tables("Table1").DefaultViewIn order to refer “Table1” Data Table, use Tables collection of Datasets and the Default view object will give you the necessary output.
How can we add relation between tables in a Dataset?
Dim objRelation As DataRelation
Relations can be added between “Data Table” objects using the “Data Relation” object. Above sample, code is trying to build a relationship between “Customer” and “Addresses” “Data table” using “Customer Addresses” “Data Relation” object.
See following video on Dataset is a disconnect while datareader is connected: -
Click and see here for more basics on ADO.NET.