C#对Access数据库做的添加、删除、查找、修改的例子

    using System;
using System.Data;
using System.Data.OleDb;
using System.Collections;
using System.Windows.Forms;

namespace Race
{
/// <summary>
/// 数据库操作
/// </summary>
public class MyData
{
  private OleDbConnection conn;
  private OleDbCommand comm;

  public MyData()//用函数实现一个数据库联接
  {
   conn = newOleDbConnection(@"Provider='Microsoft.Jet.OLEDB.4.0';Data Source='"+ Application.StartupPath + @"\data.mdb'");
  }

  ///<summary>
  /// 获取二级项目信息
  ///</summary>
  /// <paramname="peid">一级项目ID</param>
  ///<returns>二级项目信息</returns>
  public DataTable Project_GetInfo()//从数据库中读取数据到da再在内存中建立ds  用fill 来把da的数据填充到ds再返回ds 中的首行
  {
   try
   {
   OleDbDataAdapter da = new OleDbDataAdapter("select * fromProject",conn);
    DataSet ds =new DataSet();
   da.Fill(ds);
  
    returnds.Tables[0];
   
   }
   catch
   {
    returnnull;
  
   }
  }

  ///<summary>
  /// 添加数据库记录
  ///</summary>
  /// <paramname="info">信息数组</param>
  public void Project_InsertInfo(string[]info)
  {
   try
   {
    comm = newOleDbCommand("insert into [project]([name],[multiple],[time],[delay],[loop],[music],[startmusic])values('"+info[0]+"','"+info[1]+"','"+info[2]+"','"+info[3]+"','"+info[4]+"','"+info[5]+"','"+info[6]+"')",conn);
   conn.Open();
   comm.ExecuteNonQuery();
   }
   catch
   {
   //MessageBox.Show("添加失败");
   }
   finally
   {
   conn.Close();
   }
  }

  ///<summary>
  /// 修改数据库记录
  ///</summary>
  /// <paramname="info">信息数组</param>
  /// <paramname="id">ID</param>
  public void Project_UpdateInfo(string[]info,string id)
  {
   try
   {
    comm = newOleDbCommand("update [project] set[name]='"+info[0]+"',[multiple]='"+info[1]+"',[time]='"+info[2]+"',[delay]='"+info[3]+"',[loop]='"+info[4]+"',[music]='"+info[5]+"',[startmusic]='"+info[6]+"'where id="+id,conn);
   conn.Open();
   comm.ExecuteNonQuery();
   }
   catch{}
   finally
   {
   conn.Close();
   }
  }

  ///<summary>
  /// 删除数据库记录
  ///</summary>
  /// <paramname="info">信息数组</param>123
  public void Project_DeleteInfoByID(stringid)
  {
   try
   { 
    comm = newOleDbCommand("delete from project where [id]="+id,conn);
   conn.Open();
   comm.ExecuteNonQuery();
   
   }
   catch{}
   finally
   {
   conn.Close();
   }
  }

}
}
转自百度知道：http://zhidao.baidu.com/question/45422612.html