Exce导入到gridview中得问题
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=E:\民政厅救灾系统\080522\minzhengjiuzai\ExcelTemp\FileName.xls;" + "Extended Properties=Excel 8.0;";
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [FileName$]", strConn);
DataSet myDataSet = new DataSet();
myCommand.Fill(myDataSet, "ExcelInfo");
GridView1.DataSource = myDataSet.Tables["ExcelInfo"].DefaultView;
GridView1.DataBind();
代码我是这样写的,为什么不报错,但是gridview里没有数据呢?Excel种是有数据的
|