>Say I am creating a data set as following:
>
>
>DataSet MyDataSet = new DataSet();
>Adapter.Fill( MyDataSet );
>
>
>I don't know what is the default name of the table inside the data set. But I want to set the name of this table to be specific to what I need (e.g. "MyTable"). How can I do it?
>
>Note that since the variable Adapter is of type IDbDataAdapter, I cannot pass the second parameter to the .Fill() method.
Here it is:
oDataSet.Tables("Table").TableName = "Temp"
Then, you can refer as Temp or whatever the name you wish to have:
nCount = oDataSet.Tables("Temp").Rows.Count