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
   
   "
   
   ];