using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;public partial class GridviewReadExcel : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
} protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
foreach (TableCell tc in e.Row.Cells)
{
tc.Attributes["style"] = "border-color:Black";
}
if (e.Row.RowIndex != -1)
{
int id = GridView1.PageIndex * GridView1.PageSize + e.Row.RowIndex + 1;
e.Row.Cells[0].Text = id.ToString();
}
} protected void Button1_Click(object sender, EventArgs e)
{
GridView1.DataSource = createDataSource();
GridView1.DataBind();
} private DataSet createDataSource()
{
string strCon;
strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("~App_Data/Employee.xls") + ";Extended Properties=Excel 11.0;";
OleDbConnection con = new OleDbConnection(strCon);
OleDbDataAdapter da = new OleDbDataAdapter("select * from [Employee$]", con);
DataSet ds = new DataSet();
da.Fill(ds);
return ds;
}
}
结果一点击按钮就变成如下错误
异常详细信息: System.Data.OleDb.OleDbException: 找不到可安装的 ISAM。源错误:
行 57: OleDbDataAdapter da = new OleDbDataAdapter("select * from [Employee$]", con);
行 58: DataSet ds = new DataSet();
行 59: da.Fill(ds);行 60: return ds;
行 61: }
请问是怎么回事,如何修改?
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;public partial class GridviewReadExcel : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
} protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
foreach (TableCell tc in e.Row.Cells)
{
tc.Attributes["style"] = "border-color:Black";
}
if (e.Row.RowIndex != -1)
{
int id = GridView1.PageIndex * GridView1.PageSize + e.Row.RowIndex + 1;
e.Row.Cells[0].Text = id.ToString();
}
} protected void Button1_Click(object sender, EventArgs e)
{
GridView1.DataSource = createDataSource();
GridView1.DataBind();
} private DataSet createDataSource()
{
string strCon;
strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("~App_Data/Employee.xls") + ";Extended Properties=Excel 11.0;";
OleDbConnection con = new OleDbConnection(strCon);
OleDbDataAdapter da = new OleDbDataAdapter("select * from [Employee$]", con);
DataSet ds = new DataSet();
da.Fill(ds);
return ds;
}
}
结果一点击按钮就变成如下错误
异常详细信息: System.Data.OleDb.OleDbException: 找不到可安装的 ISAM。源错误:
行 57: OleDbDataAdapter da = new OleDbDataAdapter("select * from [Employee$]", con);
行 58: DataSet ds = new DataSet();
行 59: da.Fill(ds);行 60: return ds;
行 61: }
请问是怎么回事,如何修改?
解决方案 »
- vs2008中javascript中 ActiveXObject("Mircosoft.XMLHttp") 对象创建失败
- VS2008不能运行调试?
- 水晶报表导成word时候说:文件 c:\WINDOWS\TEMP\temp_8b05627a-af07-4d0b-bf12-5d45d2a53a0f.rpt 内出错:拒绝访问报表文件。其他程序可能
- 程序执行是报错:oci.dll无法加载,怎么解决啊?谢了先!
- 这样为什么链接的文字不能为红色?
- 光标移动问题
- 刚刚接触ASP.NET,有个小问题请教!
- MVC后台和前台交互的问题
- 解析二进制流格式字段(SQL Server image)
- 什么函数判断数据是否是DateTime类型
- ASPxGridView控件 获取行? 【注意,注意!】
- Request.Files
这里的Excel 11.0 用引号引起来试试
路径正确吗?
试试
strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="App_Data/Employee.xls";Extended Properties=Excel 11.0;";strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="../App_Data/Employee.xls";Extended Properties=Excel 11.0;";strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="~App_Data/Employee.xls";Extended Properties=Excel 11.0;";