Several Tables in a DataSet

Question

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.

Carlos Sanchez · Answer

Thank you bunny I had to use one DataAdapter for each Table in my code. I will replace it like your example. Thank you.

Giovanni Bejarasco · Answer

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.

Carlos Sanchez · Answer

Can you paste some more code please?

Mahesh Chand · Answer

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];