c# 查询 插入 access db 2007

连接查询

  DataSet readAccessDB()  {      OleDbConnection strConnection = new OleDbConnection("Provider = Microsoft.ACE.OLEDB.12.0;Data Source=" + "test.accdb" + ";Persist Security Info=False");       //建立数据库引擎连接，注意数据表（后缀为.db）应放在DEBUG文件下 Provider = Microsoft.ACE.OLEDB.12.0      OleDbDataAdapter myda = new OleDbDataAdapter("select * from 表1" ,strConnection);     //建立适配器，通过SQL语句去搜索数据库      DataSet myds = new DataSet();       //建立数据集      myda.Fill(myds, "表1");      return myds;  }

写入数据

 int writeAccessDB(string strsql) {      OleDbConnection strConnection = new OleDbConnection("Provider = Microsoft.ACE.OLEDB.12.0;Data Source=" + "test.accdb" + ";Persist Security Info=False");      try      {          strConnection.Open();          OleDbCommand command = new OleDbCommand(strsql, strConnection);          int rows = command.ExecuteNonQuery();          strConnection.Close();          strConnection.Dispose();          return rows;      }      catch (System.Data.SqlClient.SqlException ex)      {          strConnection.Close();          strConnection.Dispose();          return 0;          throw new Exception(ex.Message);      }   }

下载demo