excle导入简单问题
在c#中, string Path="C:\\Inetpub\\wwwroot\\upload\\file.xls";
string strconn="Provider=Microsoft.Jet.OLEDB.4.0;" +"Data Source="+ Path +";"+"Extended Properties=Excel 8.0;";
OleDbConnection myOleDbConnection=new OleDbConnection(strconn);
myOleDbConnection=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;" +"Data Source=+Path+";"+"Extended Properties=Excel 8.0;"");
string sqlstr="select * from [sheet1$] ";
OleDbCommand myOleDbCommand=new OleDbCommand(sqlstr,myOleDbConnection);
OleDbDataAdapter myData=new OleDbDataAdapter(myOleDbCommand);
myData.Fill(MyDataset);
DataGrid1.DataSource=MyDataset.Tables[0].DefaultView;
DataGrid1.DataBind();
为什么总提示"值不能为空。参数名: dataSet "