关于导入Excel的问题
1、将Excel数据导入DataSet
DataSet ds = new DataSet();
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;"+
"Data Source=" + filePath + ";" +
"Extended Properties=\"Excel 8.0;\"");
conn.Open();
OleDbCommand myOleDbCommand = new OleDbCommand("SELECT * FROM [Sheet1$]",conn);
OleDbDataAdapter myData = new OleDbDataAdapter(myOleDbCommand);
myData.Fill(ds);
conn.Close();
2、更新数据库
Adapter.update(ds)
但是,从excel中导出来的DataSet中的DataTable的行状态为"unchanged" 的
怎么更新?