string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = " + fileFullDir + " ;Extended Properties=Excel 8.0";
System.Data.OleDb.OleDbConnection myConn = new System.Data.OleDb.OleDbConnection(strCon);
// string strCom = " SELECT * FROM [Sheet1$]";
string strUpdata = "UPDATE [Sheet1$] SET hasnumber = '718' WHERE hasnumber = '1130'";
System.Data.OleDb.OleDbDataAdapter myCommand = new System.Data.OleDb.OleDbDataAdapter(strUpdata, myConn);我按照上面的写法写的,没有报错。但是也没有更新数据。谢谢,咋咋写呢?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货