Store a data datatable into dataset (DataSet. Merge method)

Today, a storage task was previously executed with multiple select statements in dataset and then stored in dataset. However, in c # moblie development, multiple Select statements cannot be executed simultaneously. Only one select table is saved to dataset once.
If DataSet. table. add (tablename); is used, we can only use the Merge method in Dataset.

String tb0sql = "select RateValue as MonthlyPreRate from WQtbRate_LimitedLv_MonthlyPreRate"; // monthlyprerate
DataTable dt0 = new DataTable ();
Dt0 = base. TableExecuteQuery (tb0sql, CommandType. Text );
Ds. Merge (dt0, false, MissingSchemaAction. Add );
Ds. Tables [0]. TableName = "xxxxxxx ";

The following describes the dataset. merge method DataSet. Merge.

Merges the array of the specified DataSet, able, or DataRow object into the currentDataSetOrDataTable.

Reload list

Name	Description
DataSet. Merge (DataRow [])	SetDataRowThe object array is merged to the currentDataSet. Supported by. NET Compact Framework.
DataSet. Merge (DataSet)	DataSetAnd its architecture are merged to the currentDataSet. Supported by. NET Compact Framework.
DataSet. Merge (DataTable)	DataTableAnd its architecture are merged to the currentDataSet. Supported by. NET Compact Framework.
DataSet. Merge (DataSet, Boolean)	DataSetAnd its architecture are merged to the currentDataSetIn the process,DataSet. Supported by. NET Compact Framework.
DataSet. Merge (DataRow [], Boolean, MissingSchemaAction)	SetDataRowThe object array is merged to the currentDataSetIn the process,DataSetAnd handle incompatible architectures. Supported by. NET Compact Framework.
DataSet. Merge (DataSet, Boolean, MissingSchemaAction)	DataSetIts architecture and currentDataSetMerge. In this process, the currentDataSetAnd handle incompatible architectures. Supported by. NET Compact Framework.
DataSet. Merge (DataTable, Boolean, MissingSchemaAction)	DataTableAnd its architecture are merged to the currentDataSetIn the process,DataSetAnd handle incompatible architectures. Supported by. NET Compact Framework.