SqlConnection的错误，帮我看一下，谢谢

[wdhs]

private string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=DB\\词频.mdb;";
///注：在同一程序的OleDbConnection也用它连接，没问题。
…………

SqlConnection objSqlConn = new SqlConnection();
objSqlConn.ConnectionString = strConnection;
objSqlConn.Open();

E.Message提示：连结字符串provider中未知的连接选项

[zwztu]

OLE DB Provider for Microsoft Jet
For standard security

oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\somepath\myDb.mdb;" & _
"User Id=admin;" & _
"Password="

[saucer]

classes in System.Data.SqlClient are for SQL Server, you cannot use them with Access

[nightsunman]

///注：在同一程序的OleDbConnection也用它连接，没问题。

如果是好的编程习惯，应该怎同一个应用中记住连接，而不是每次都去连接数据库，在类里面定义变量 con ，在别的地方就可以引用了，并且继承性能好

[wdhs]

saucer(思归, MS .NET MVP):
那怎么把Access的数据显示在Datagrad里？

[jonsonzxw]

using System;
using System.Data;
using System.Data.OleDb;

private string connstr;

// 初始化连接字符串
public DBCon()
{
string file = Server.MapPath("\\Knowledge") + "\\database\\KNOWLEDGE.mdb";
string str = "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=" + file;

this.connstr = str;
}

private void Page_Load(object sender, System.EventArgs e)
{
if(!Page.IsPostBack)
{
DBCon db = new DBCon();
string artid = Request.QueryString["artid"];

DataSet ds = new DataSet() ;
ds = db.GetSubArticleList(artid);

list.DataSource = ds.Tables[0].DefaultView;
list.DataBind();
}
}

[saucer]

use classes in System.Data.OleDb namespace

[afengsunwin]

SqlConnection对象只支持数据库为sql server的情况