G
Guest
Any idea why the database table is not being updated with the contents of the excel file loaded into the dataset? Any help is appreciated!
// load database table, shell only
string cnString = "DSN=XXX D5200";
OdbcConnection myConnection = new OdbcConnection(cnString);
OdbcDataAdapter da = new OdbcDataAdapter("select * from DB where 1=2;", myConnection);
DataSet ds = new DataSet();
da.Fill(ds, "ccginput");
// load excel file into dataset
string strCnExcel = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + fPath + ";" +
"Extended Properties=Excel 8.0;";
OleDbConnection objConn = new OleDbConnection(strCnExcel);
objConn.Open();
OleDbCommand objCmdSelect =new OleDbCommand("SELECT * FROM [sheet1$]", objConn);
OleDbDataAdapter objAdapter1 = new OleDbDataAdapter();
objAdapter1.SelectCommand = objCmdSelect;
objAdapter1.Fill(ds, "ccginput");
// update database with contents of dataset
da.AcceptChangesDuringFill=true;
da.Update(ds,"ccginput");
// load database table, shell only
string cnString = "DSN=XXX D5200";
OdbcConnection myConnection = new OdbcConnection(cnString);
OdbcDataAdapter da = new OdbcDataAdapter("select * from DB where 1=2;", myConnection);
DataSet ds = new DataSet();
da.Fill(ds, "ccginput");
// load excel file into dataset
string strCnExcel = "Provider=Microsoft.Jet.OLEDB.4.0;" +
"Data Source=" + fPath + ";" +
"Extended Properties=Excel 8.0;";
OleDbConnection objConn = new OleDbConnection(strCnExcel);
objConn.Open();
OleDbCommand objCmdSelect =new OleDbCommand("SELECT * FROM [sheet1$]", objConn);
OleDbDataAdapter objAdapter1 = new OleDbDataAdapter();
objAdapter1.SelectCommand = objCmdSelect;
objAdapter1.Fill(ds, "ccginput");
// update database with contents of dataset
da.AcceptChangesDuringFill=true;
da.Update(ds,"ccginput");