C#操作Access数据库的例子

using   System;   

  using   System.Data;         

  using   System.Data.OleDb;         

  namespace   ADONETWriteQuery       

  {     

              /**////   <summary>     

              ///   Summary   description   for   Class1.     

              ///   </summary>     

              class   Class1     

              {       

                          static   void   Main(string[]   args)       

                          {       

                                      string   strDSN   =   "Provider=Microsoft.Jet.OLEDB.4.0;Data   

  Source=c:\\mcTest.MDB";       

                                      string   strSQL   =   "INSERT   INTO   Developer(Name,   Address   )   VALUES(   

  'NewName',   'NewAddress')"   ;       

                                          

                                      //   create   Objects   of   ADOConnection   and   ADOCommand         

                                      OleDbConnection   myConn   =   new   OleDbConnection(strDSN);       

                                      OleDbCommand   myCmd   =   new   OleDbCommand(   strSQL,   myConn   );       

                                      try       

                                      {       

                                                  myConn.Open();       

                                                  myCmd.ExecuteNonQuery();       

                                      }       

                                      catch   (Exception   e)       

                                      {       

                                                  Console.WriteLine("Oooops.   I   did   it   again:\n{0}",   e.Message);       

                                      }       

                                      finally       

                                      {       

                                                  myConn.Close();       

                                      }       

          

          

          

                          }     

              }       

  }