string StrConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + FilePath + ";" + "Extended Properties=Excel 8.0;";
OleDbConnection MyConn = new OleDbConnection(StrConn);
// MyConn.Open();
string StrExcel = "";
OleDbDataAdapter MyCommand = null;
DataSet ds = null;
StrExcel = "select * from [sheet1$]";
MyCommand = new OleDbDataAdapter(StrExcel, StrConn);
ds = new DataSet();
MyCommand.Fill(ds, "table1");
//MyConn.Close();
return ds;运行的时候,上面的"MyCommand.Fill(ds, "table1");"语句
出错提示:Cannot update. Database or object is read-only.
我这没有执行写操作吧,知识从Excel里面读出来,放到DataSet的table里面,这段程序是在winform上的;
谢谢大家刚才在另外的帖子的热心^_^希望多帮我新人^_^
OleDbConnection MyConn = new OleDbConnection(StrConn);
// MyConn.Open();
string StrExcel = "";
OleDbDataAdapter MyCommand = null;
DataSet ds = null;
StrExcel = "select * from [sheet1$]";
MyCommand = new OleDbDataAdapter(StrExcel, StrConn);
ds = new DataSet();
MyCommand.Fill(ds, "table1");
//MyConn.Close();
return ds;运行的时候,上面的"MyCommand.Fill(ds, "table1");"语句
出错提示:Cannot update. Database or object is read-only.
我这没有执行写操作吧,知识从Excel里面读出来,放到DataSet的table里面,这段程序是在winform上的;
谢谢大家刚才在另外的帖子的热心^_^希望多帮我新人^_^
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货