Use the DataAdapter's TableMappings collection to control the names of the DataTables that the DataAdapter will fill or create. So, if your stored procedure will return customer and order information, you would use code like the following:
MyDataAdapter.TableMappings.Add("Table", "Customers")
MyDataAdapter.TableMappings.Add("Table1", "Orders")
MyDataAdapter.Fill(MyDataSet)How can I guarantee that Customers will always be Table and Orders will be Table1?
If I'm counting on the order in which the SQL Statements are executed what's the difference if I just do this?
MyDataSet.Tables[0].TableName = "Customers";
MyDataSet.Tables[1].TableName = "Orders";