How can we load multiple tables into Dataset

Question

How can we load multiple tables in to Dataset ?

Ragu nandhan · Answer

Hai you can add multiple tables into an dataset. Dataset is a collection of tables. for each table you should create and data adapter for filling the data into the data set. data adapter carrie's the function like selecting dataupdating the edited records deleting records etc... Refer the below link for Top to bottom details of it. http://msdn.microsoft.com/en-us/library/bh8kx08z.aspx

Suthish Nair · Answer

Another way Dim ds as New DataSet Dim dt as New DataTable ds.Tables.Add( dt )

Karthikeyan Anbarasan · Answer

using the adapter load tables one by one to the dataset

Mayur Dighe · Answer

hello friend You can use DataAdapter to load Multiple Tables into Single DataSet Refer Following Article: http://www.vbdotnetheaven.com/UploadFile/ea36c5/5812/