Question

c＃ 连接access数据库时用什么控件和命令？

RT～

Answer 1

语法如下：
using System.Data.OleDb;
using System.Data;
//连接指定的Access数据库
String ConnString ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=MyMDB.mdb";
//SQL语句
String SQLString ="select * from TestDB";
//创建一个OleDbConnection对象
System.Data.OleDb.OleDbConnection OleDBConn1 = new System.Data.OleDb.OleDbConnection(ConnString);
//创建一个DataSet对象
DataSet DataSet1 = new DataSet();
//创建一个OleDbDataAdapter对象
System.Data.OleDb.OleDbDataAdapter OleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter(SQLString,OleDBConn1);
//打开连接
OleDBConn1.Open();
//通过OleDbDataAdapter对象填充数据集
OleDbDataAdapter1。Fill(DataSet1,"TT");

Answer 2

如果是access2003的话如下两位的代码，如果是access2007的话，Provider=Microsoft.Jet.OLEDB.4.0应改为Provider=Microsoft.ACE.OLEDB.12.0

Answer 3

private System.Data.OleDb.OleDbConnection connect;
connect = new System.Data.OleDb.OleDbConnection();
connect.ConnectionString = @ "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Data.mdb;User ID=Admin;Password=;Jet OLEDB:Database Password=pass";
connect.Open();