ASP.NET 连接 ACCESS 数据库的代码

C# code

//连接的access
string connection="Provider=Microsoft.Jet.OLEDB.4.0;Server=MyMDB.mdb"; 
//查询的access里面的表
string sqlConnection="SECLET * FROM ***DB"; 
//连接
System.Data.OleDb.OleDbConnection oleDbConnection=new System.Data.OleDb.OleDbConnection(connection); 

DataSet dataset=DataSet(); 

System.Data.OleDb.OleDataAdapter oleDataAdapter=new System.Data.OleDb.OleDataAdapter(sqlConnection,oleDbConnection); 
//打开连接
oleDbConnection.Open(); 
//填充数据到DataSet
oleDataAdapter.Fill(dataSet,"***DB"); 
//在dataGridView显示出查询出来的数据
dataGridView.DataSource=dataSet.Tables["***DB"];