string strCon = @" Provider =Microsoft.Jet.OLEDB.4.0 ; Data Source = F:\total.xls;Extended Properties=Excel 8.0";
OleDbConnection myConn = new OleDbConnection(strCon);
myConn.Open();
string strCom = " SELECT * FROM [Sheet1$] ";
OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, myConn);
DataSet dataSet = new DataSet();
myCommand.Fill(dataSet, "[Sheet1$]");
dataGridView1.Name = "[Sheet1$]";
dataGridView1.DataSource = dataSet;出现Fill: selectcommand.connection 属性尚未初始化提示!这是什么回事呀
OleDbConnection myConn = new OleDbConnection(strCon);
myConn.Open();
string strCom = " SELECT * FROM [Sheet1$] ";
OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, myConn);
DataSet dataSet = new DataSet();
myCommand.Fill(dataSet, "[Sheet1$]");
dataGridView1.Name = "[Sheet1$]";
dataGridView1.DataSource = dataSet;出现Fill: selectcommand.connection 属性尚未初始化提示!这是什么回事呀
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货