(1)引入命名空间
using System.Data.OleDb;
(2)连接语句
string ConStr=“Provider =microsoft.jet.oledb.4.0 ; Data Source=|DataDirectory|db_ADO.mdb;”;//不加密
string ConStr1="Provider=microsoft.jet.oledb.4.0 ; Jet OLEDB : DataBase Password=@Password ; UserId=admin ; Data Source=|DataDirectory|db_ADO.mdb;";//加密
|DataDirectory|db_ADO.mdb表示为db_ADO的路径 ,@Password表示为数据库的密码,@UserID表示为登录用户
(3)运用
public void BindData(){
string ConStr="Provider=microsoft.jet.oledb.4.0;Jet OLEDB:DataBase Password=@Password;UserId=admin;Data Source=|DataDirectory|db_ADO.mdb;";
OleDbConnection Con=new OleDbConnect(ConStr);
Con.Open();
OleDbDataAdapter da=new OleDbDataAdapter("select * from table_a",Con);
DataSet ds=new DataSet();
da.fill(ds);
GridView1.DataSource=ds;
GridView1.DataBind();
Con.Close();
}