今天做个小功能,把excel表导入到gridview中,
代码如下:
string strConn;
strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\kjjj371\Desktop\AmexAzFlights.xls;Extended Properties=Excel 8.0;";
OleDbConnection DBConnection = new OleDbConnection(strConn);
string sql = @"SELECT * FROM [Flights$]";
DataSet myDataSet = new DataSet();
OleDbDataAdapter objAdapter1 = new OleDbDataAdapter(sql,DBConnection);
DBConnection.Open();
objAdapter1.Fill(myDataSet);
DBConnection.Close();
GridView1.DataSource = myDataSet;
GridView1.DataBind();
在.net中进行调试时是可以显示的,但是当把网页放在IIS的虚拟目录中时,每次都会报
No error message available, result code: E_FAIL(0x80004005).
今天郁闷死了,哪位大大能帮我解答一下,不胜感激
代码如下:
string strConn;
strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\kjjj371\Desktop\AmexAzFlights.xls;Extended Properties=Excel 8.0;";
OleDbConnection DBConnection = new OleDbConnection(strConn);
string sql = @"SELECT * FROM [Flights$]";
DataSet myDataSet = new DataSet();
OleDbDataAdapter objAdapter1 = new OleDbDataAdapter(sql,DBConnection);
DBConnection.Open();
objAdapter1.Fill(myDataSet);
DBConnection.Close();
GridView1.DataSource = myDataSet;
GridView1.DataBind();
在.net中进行调试时是可以显示的,但是当把网页放在IIS的虚拟目录中时,每次都会报
No error message available, result code: E_FAIL(0x80004005).
今天郁闷死了,哪位大大能帮我解答一下,不胜感激
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货