//string constr = "Max Pool Size=5;Min Pool Size=1;Pooling=true;persist security info=false;User Id=ips2;Password=ips2;Data Source=oa"; string constr1 = "Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source=d:/file.xls;Extended Properties=Excel 8.0";
OleDbConnection conn1 = new OleDbConnection(constr1); //OracleConnection conn = new OracleConnection(constr); // OracleDataAdapter oda = new OracleDataAdapter("select * from TIPS_ACC_ACCOUNT", conn); OleDbDataAdapter da = new OleDbDataAdapter("select * from [sheet1$]",conn1); DataSet ds = new DataSet();
// OracleCommandBuilder objcmdBuilder = new OracleCommandBuilder(oda); OleDbCommandBuilder objcmdBuilder = new OleDbCommandBuilder(da);
da.UpdateCommand = objcmdBuilder.GetUpdateCommand();
da.InsertCommand = objcmdBuilder.GetInsertCommand();
da.DeleteCommand = objcmdBuilder.GetDeleteCommand();
da.Fill(ds, "[sheet1$]");
ds.Tables[0].Rows[0][2] = "001"; da.Update(ds, "[sheet1$]");为什么Oracle可以,Oledb就不行??
OleDbConnection conn1 = new OleDbConnection(constr1); //OracleConnection conn = new OracleConnection(constr); // OracleDataAdapter oda = new OracleDataAdapter("select * from TIPS_ACC_ACCOUNT", conn); OleDbDataAdapter da = new OleDbDataAdapter("select * from [sheet1$]",conn1); DataSet ds = new DataSet();
// OracleCommandBuilder objcmdBuilder = new OracleCommandBuilder(oda); OleDbCommandBuilder objcmdBuilder = new OleDbCommandBuilder(da);
da.UpdateCommand = objcmdBuilder.GetUpdateCommand();
da.InsertCommand = objcmdBuilder.GetInsertCommand();
da.DeleteCommand = objcmdBuilder.GetDeleteCommand();
da.Fill(ds, "[sheet1$]");
ds.Tables[0].Rows[0][2] = "001"; da.Update(ds, "[sheet1$]");为什么Oracle可以,Oledb就不行??
string constr1 = "Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source=d:/file.xls;Extended Properties=Excel 8.0";
OleDbDataAdapter da = new OleDbDataAdapter("select * from [sheet1$]",constr1);
DataSet ds = new DataSet(); OleDbCommandBuilder objcmdBuilder = new OleDbCommandBuilder(da); da.Fill(ds, "[sheet1$]");
ds.Tables[0].Rows[0][2] = "001"; da.Update(ds, "[sheet1$]");