dataset c# datatable -

A stored procedure returns several tables, the result set is applied to a dataset. Can I access tables in the dataset with the names of each table?

For example: -

Dataset DS = Selection (despatch_Packing_ID);

4 tables in the dataset.

Let me know dtSales = ds.Tables [0]; As is done to reach the table

How can I use DataTable as DataTable dtSales = ds.Tables ["Sale"]; // is the sales table from which I get the data

Thanks in advance. By default, the table name generated by the dBDataAdaptor in the table, "Table 1", "Table 1," and " Table 2 ", ...

You can override names.

For example: DBDataAdapter adapter = ... ... adapter. Table mapping Add ("table", "sale"); Adapter.TableMappings.Add ("Table 1", "Customer"); ... adapter. Filled (myDataSet); ...