62,052
社区成员
发帖
与我相关
我的任务
分享
DataSet dsAllArea=new DataSet();
string sql = "SELECT * FROM tblProvince;SELECT * FROM tblCity;SELECT * FROM tblDistrict";
SqlHelper.FillDataset(SqlHelper.ConnectionString, CommandType.Text, sql, dsAllArea, new string[] { "dtblProvince", "dtblCity", "dtblDistrict" });
这时dsAllArea.Tables[2].TableName ="Table2"
最后一个不起作用.
自己又加了下面这句.
dsAllArea.Tables[2].TableName = "dtblDistrict";
string tableName = "Table";
for (int index = 0; index < tableNames.Length; index++)
{
if (tableNames[index] == null || tableNames[index].Length == 0) throw new ArgumentException("The tableNames parameter must contain a list of tables, a value was provided as null or empty string.", "tableNames");
dataAdapter.TableMappings.Add(tableName, tableNames[index]);
tableName += (index + 1).ToString();//注意这一行
}
using( SqlDataAdapter dataAdapter = new SqlDataAdapter( cmd ) )
{
// Add the table mappings specified by the user
if( tableNames != null && tableNames.Length > 0 )
{
string tableName = "Table";
dataAdapter.TableMappings.Add( tableName, tableNames[ 0 ] );
for( int index = 1; index < tableNames.Length; index++ )
{
if( tableNames[index] == null || tableNames[index].Length == 0 ) throw new ArgumentException( "The tableNames parameter must contain a list of tables, a value was provided as null or empty string.", "tableNames" );
dataAdapter.TableMappings.Add( tableName + index, tableNames[ index ] );
//tableName += ( index + 1 ).ToString();
}
}
// Fill the DataSet using default values for DataTable names, etc
dataAdapter.Fill( dataSet );
}
// 执行命令
using (SqlDataAdapter dataAdapter = new SqlDataAdapter(command))
{
// 追加表映射
if (tableNames != null && tableNames.Length > 0)
{
string tableName = "Table";
for (int index = 0; index < tableNames.Length; index++)
{
if (tableNames[index] == null || tableNames[index].Length == 0) throw new ArgumentException("The tableNames parameter must contain a list of tables, a value was provided as null or empty string.", "tableNames");
dataAdapter.TableMappings.Add(tableName, tableNames[index]);
tableName += (index + 1).ToString();
}
}
// 填充数据集使用默认表名称
dataAdapter.Fill(dataSet);
// 清除参数,以便再次使用.
command.Parameters.Clear();
}
SqlHelper.FillDataset(SqlHelper.ConnectionString, CommandType.Text, sql, dsAllArea, new string[] { "dtblProvince", "dtblCity", "dtblDistrict" });
执行好之后.
dsAllArea.Tables[0].TableName ="dtblProvince"
dsAllArea.Tables[1].TableName ="dtblCity"
dsAllArea.Tables[2].TableName ="Table2"