Several tables in the same DataSet

Carlos Sanchez

I want to know wether or not is possible having several tables in a DataSet. For example, when I want to create a DataSet I have to do the next: string commandText = "SELECT Column1, Column2 FROM Table1"; SqlDataAdapter myAdapter = new SqlDataAdapter(commandText, myConnection); DataSet myDataSet = new DataSet(); myAdapter.Fill(myDataSet, "Table1"); If I wanted to Bind the DataSet with a component (for example ComboBox) I'd do the next: ComboBox1.DataSource = myDataSet.Tables["Table1"]; ComboBox1.DisplayMember = "Column1"; So, I want to know wether I can have several tables in the same DataSet to Bind them with several components, something like this: ComboBox1.DataSource = myDataSet.Tables["Table1"]; ComboBox2.DataSource = myDataSet.Tables["Table2"]; ComboBox3.DataSource = myDataSet.Tables["Table3"]; ComboBox4.DataSource = myDataSet.Tables["Table4"]; is this possible??? How can I do it??? if you know what can I do, paste some code please. thanks in advance.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Carlos Sanchez22y ago
Thank you bunny. I've used the second option, but I had to create a DataAdapter for each one. is this necessary? My code is the next: DataSet dsTables = new DataSet(); SqlDataAdapter daCategories = new SqlDataAdapter("SELECT CAT_ID, CAT_Name FROM Categories",Connection1); SqlDataAdapter daSupliers = new SqlDataAdapter("SELECT SUP_ID, SUP_Name FROM Supliers",Connection1); SqlDataAdapter daCustomers = new SqlDataAdapter("SELECT CUS_ID, CUS_Name FROM Customers",Connection1); SqlDataAdapter daCompanies = new SqlDataAdapter("SELECT COM_ID, COM_Name FROM Companies",Connection1); daCategories.Fill(dsTables,"Categories"); daSupliers.Fill(dsTables,"Supliers"); daCustomers.Fill(dsTables,"Customers"); daCompanies.Fill(dsTables,"Companies"); cbCategories.DataSource=dsTables.Tables["Categories"]; cbCategories.DisplayMember="CAT_Name"; cbCategories.ValueMember="CAT_ID"; cbSupliers.DataSource=dsTables.Tables["Supliers"]; cbSupliers.DisplayMember="SUP_Name"; cbSupliers.ValueMember="SUP_ID"; cbCustomers.DataSource=dsTables.Tables["Customers"]; cbCustomers.DisplayMember="CUS_Name"; cbCustomers.ValueMember="CUS_ID"; cbCompanies.DataSource=dsTables.Tables["Companies"]; cbCompanies.DisplayMember="COM_Name"; cbCompanies.ValueMember="COM_ID"; thank you in advance.
0
Giovanni Bejarasco22y ago
YES! Use the DataSet.Tables.Add() method. There are 3 overloads for this: 1) Add() ---- creating a table in the TablesCollection with default name "Table##". I dont recommend this. Use the next overload 2) Add(string tblName) ---- creates an empty table with a specified name. You must call the DataAdapter.Fill(DataSet ds, string tblName) method to populate the table. 3) Add(DataTable tbl) --- where tbl is a fully qualified table created prior to the call of the Add method. The table may be empty. You're on the right track with your code. All you have to do is add another table to your existing dataset. No need for me to supply you with code. This one is a walk in the park. Try it and be challenged!
0