Several Tables in a 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.

4 Replies

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

Carlos Sanchez22y ago
Thank you bunny, I had to use one DataAdapter for each Table in my code. I will replace it, like your example. Thank you.
0
Giovanni Bejarasco22y ago
Something like this. Say, you have a CommandText like this "SELECT colA, colB FROM TableA; SELECT colA, colB FROM TableB" then you call DataAdapter.Fill(DataSet). What will happen is that DataSet automatically fill two tables "Table1" and "Table2" with contents from TableA and TableB respectively. If you want give meaningful names to the tables in the DataSet, you can use the TableMappings collection of the DataSet. Happy programming.
0
Carlos Sanchez22y ago
Can you paste some more code, please?
0
Mahesh Chand22y ago
You can have the CommandText having multiple tables seperated by semicolon which will fill a DataSet from multiple tables and your code will work. ComboBox1.DataSource = myDataSet.Tables["Table1"]; ComboBox2.DataSource = myDataSet.Tables["Table2"]; ComboBox3.DataSource = myDataSet.Tables["Table3"]; ComboBox4.DataSource = myDataSet.Tables["Table4"];
0