C＃OleDBConnection Excel
|
继此问题之后C＃OLEDB与Excel的连接
我在使用OLEdbCommandBuilder时遇到问题。
我有以下代码：
DataTable dt = new DataTable();
OleDbCommand command = new OleDbCommand();
command = new OleDbCommand(\"Select * from [working sheet$]\", oleDBConnection);
OleDbDataAdapter dataAdapter = new OleDbDataAdapter();
dataAdapter.SelectCommand = command;
OleDbCommandBuilder c = new OleDbCommandBuilder(dataAdapter);
dataAdapter.Fill(dt);
//arbitrary changed datatable
dt.Rows[2][3] = \"dfd\";
c.GetUpdateCommand();
dataAdapter.Update(dt);
oleDBConnection.Close();
Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.
没有找到相关结果
已邀请:
1 个回复
死簇
... dataAdapter.Fill(dt); ... System.Data.DataColumn pkCol = dt.Columns[0]; // something like dt.Columns[\"Id\"] pkCol.Unique = true; dt.PrimaryKey = new DataColumn[] {pkCol }; ... OleDbCommandBuilder c = new OleDbCommandBuilder(dataAdapter); ...