UC知道在C#中连接access数据库的语言怎么写
来源：百度知道 编辑：UC知道 时间：2024/06/14 00:11:20
我的代码是这样的，可是不行，运行时会报错，显示“不支持关键字provider”，哪位高手帮我解决下，好吗，太感谢。
private void button1_Click(object sender, EventArgs e)
{
string connstr;
string sqlstr;
connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Data\\studen1.mdb;";
sqlstr = "select * form stuInfo";
SqlConnection conn = new SqlConnection(connstr);
SqlDataAdapter da = new SqlDataAdapter(sqlstr, conn);
DataSet ds = new DataSet();
conn.Open();
da.Fill(ds, "stuInfo");
dataGrid1.SetDataBinding(ds, "stuInfo");
}
private void button1_Click(object sender, EventArgs e)
{
string connstr;
string sqlstr;
connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Data\\studen1.mdb;";
sqlstr = "select * form stuInfo";
SqlConnection conn = new SqlConnection(connstr);
SqlDataAdapter da = new SqlDataAdapter(sqlstr, conn);
DataSet ds = new DataSet();
conn.Open();
da.Fill(ds, "stuInfo");
dataGrid1.SetDataBinding(ds, "stuInfo");
}
需要用OleDbConnection
而不是SqlConnection
string strConnection="Provider=Microsoft.Jet.OleDb.4.0;";
strConnection +=@"Data Source=\\192.168.1.10\\access\\CSharptest.mdb";
OleDbConnection objConnection = new OleDbConnection(strConnection); //建立连接
objConnection.Open(); //打开连接
OleDbCommand sqlcmd = new OleDbCommand(@"select * from person where personname='John'",objConnection); //sql语句
OleDbDataReader reader = sqlcmd.ExecuteReader(); //执行查询
Connectionstring="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Server.MapPath("Data\\studen1.mdb;");
cnn=new OleDbConnection(Connectionstring);
……
1楼说得对