Hi Victor,

This method is just a way to map how the tables are named on the client side. You can do it the other way if you prefer to. The method I explained happens before you populate the tables. Your suggestion happens afterwards. It is a matter of preference.

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