我用的是vs2005 ,代码如下
出现错误提示是:未在本地计算机上注册Microsoft.Jet.OLE DB.4.0提供程序
using System;
using System.Data;
using System.Configuration;
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 _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
OleDbConnection Conn = new OleDbConnection();
Conn.ConnectionString = "Provider=Microsoft.Jet.OLE DB.4.0;Data Source= " + Server.MapPath( "access.mdb ");
Conn.Open();
string sql = "select * from grade where name like '% " + TextBox1.Text + "% ' ";
OleDbCommand Comm = new OleDbCommand(sql, Conn);
OleDbDataReader dr = Comm.ExecuteReader();
dg.DataSource = dr;
dg.DataBind();
Conn.Close();
}
}
那要去iis 中注册 数据源??
------解决方法--------------------------------------------------------
应该是
Provider=Microsoft.Jet.OLEDB.4.0
不是
Provider=Microsoft.Jet.OLE DB.4.0
吧
注意写法