c# 当传接具有新行的 DataRow 集合时,更新要求有效的 InsertCommand
c# 当传递具有新行的 DataRow 集合时,更新要求有效的 InsertCommand
public void DataBaseInSertFromOperateDataSet(string DataTableName, string ValueOfFieldString)
{
if (this.OleDbCommandString != null && this.ConnectionString != null)
{
this._ConnectionString = ConnectionString;
this._OleDbCommandString = OleDbCommandString;
MyConnection = new OleDbConnection(_ConnectionString);
MyDataAdapter = new OleDbDataAdapter(_OleDbCommandString, MyConnection);
MyDataSet = new DataSet();
MyDataAdapter.Fill(MyDataSet, DataTableName);
MyDataTable = MyDataSet.Tables[DataTableName];
string[] ColumnName = new string[MyDataTable.Columns.Count];
int i = 0;
foreach (DataColumn Dc in MyDataTable.Columns)
{
ColumnName[i] = Dc.ColumnName;
i++;
}
string[] ValueOfField = ValueOfFieldString.Split(new char[] { ',' });
if (ValueOfField.Length != ColumnName.Length)
{
MessageBox.Show("您输入的字段个数与数据库不匹配");
}
else
{
for (int j = 0; j < ValueOfField.Length; j++)