ADO.NET中的多数据表操作之读取

throw new ArgumentException( "The tableNames parameter must contain a list of tables, a value was provided as null or empty string.", "tableNames" );

tableName += (index + 1).ToString();//这里出现错误

}

}

dataAdapter.Fill(dataSet);

command.Parameters.Clear();

}

if( mustCloseConnection )

connection.Close();

}

这里把tableName += (index + 1).ToString();修改成

dataAdapter.TableMappings.Add((index>0) (tableName+index.ToString()):tableName, tableNames[index]);就能解决问题。

接下来看看窗体程序的代码：

public class Form1 : System.Windows.Forms.Form

{

private DataAccess _dataAccess;

private DatasetOrders _ds;

//……

//构造函数

public Form1()

{

InitializeComponent();

_dataAccess = new DataAccess();

_ds = new DatasetOrders();

_ds.EnforceConstraints = false; //关闭约束检查，提高数据填充效率