Access数据库的增删改查(C#)

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;

namespace AddressList
{
    public partial class FrmAccessUse : Form
    {
        public FrmAccessUse()
        {
            InitializeComponent();
        }
        #region 调用access标准方法
        //        using System.Data.OleDb;
//        using System.Data;
//        连接字符串：String connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=product.mdb";
//        建立连接：OleDbConnection connection = new OleDbConnection(connectionString);
//        使用OleDbCommand类来执行Sql语句：
//        OleDbCommand cmd = new OleDbCommand(sql, connection);
//        connection.Open();
        //        cmd.ExecuteNonQuery();
        #endregion

        #region 连接字符串
        //string strcon = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\程序书籍软件\c#程序代码\access数据库操作\addressList.mdb"; //绝对路径
        string strcon = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Environment.CurrentDirectory+"\\addressList.mdb"; //相对路径

        #endregion

        #region 查询
        private void tsbQuery_Click(object sender, EventArgs e)
        {
           query();
        }
        #endregion
        #region 查询语句
        private void query()
        {
                       try
            {
                gridView1.Columns.Clear();
                OleDbConnection connet1 = new OleDbConnection(strcon);
                string sql = "select * from new1";
                connet1.Open();
                OleDbDataAdapter myadapter = new OleDbDataAdapter();
                DataSet ds = new DataSet();
                myadapter.SelectCommand = new OleDbCommand(sql, connet1);
                myadapter.Fill(ds);
                gridControl1.DataSource = ds.Tables[0];
                connet1.Close();
                gridControl1.Refresh();
            }
            catch (Exception exp)
            {

                throw exp;
            }
        }
        #endregion

        #region 保存
        private void tsbSave_Click(object sender, EventArgs e)
        {
            Savebt();
        }
        #endregion
        #region 保存语句
        private void Savebt()
        {
            try
            {
                int[] rowCount = this.gridView1.GetSelectedRows();
                string strSql = "";
                foreach (int i in rowCount)
                {
                    this.gridView1.FocusedRowHandle = -1;
                    string strID = "", strBH = "", strMC = "", strLXID = "", strLX = "", strSM = "", strFZ = "";
                    strID = this.gridView1.GetRowCellValue(i, "ZMID").ToString();
                    strBH = this.gridView1.GetRowCellValue(i, "帐目编号").ToString();
                    strMC = this.gridView1.GetRowCellValue(i, "帐目名称").ToString();
                    strLXID = this.gridView1.GetRowCellValue(i, "帐目类型ID").ToString();
                    strLX = this.gridView1.GetRowCellValue(i, "帐目类型").ToString();
                    strSM = this.gridView1.GetRowCellValue(i, "说明").ToString();
                    strFZ = this.gridView1.GetRowCellValue(i, "附注").ToString();
                    strSql = "Update new1 set 帐目编号='" + strBH + "', 帐目名称='" + strMC + "',帐目类型ID='" + strLXID + "',帐目类型='" + strLX + "',说明='" + strSM + "',附注='" + strFZ + "' where ZMID = " + strID + ""; //注意where处没有单引号               
                }
                OleDbConnection connet1 = new OleDbConnection(strcon);
                connet1.Open();
                OleDbCommand cmd = new OleDbCommand(strSql, connet1);
                int a = cmd.ExecuteNonQuery();
                connet1.Close();
                if (a > 0)
                {
                    MessageBox.Show("保存成功！");
                }
                query();
            }
            catch (Exception exp)
            {

                throw exp;
            }
        }
        #endregion       

        #region 添加一条新记录
        private void tsbAddNew_Click(object sender, EventArgs e)
        {
            addnew();
        }
        #endregion
        #region 添加语句
        private void addnew()
        {
            try
            {
                string strSql = "";
                OleDbConnection connet1 = new OleDbConnection(strcon);
                connet1.Open();
                strSql = "insert into new1(帐目编号) values('NewValues')";
                OleDbCommand cmd = new OleDbCommand(strSql, connet1);
                int a = cmd.ExecuteNonQuery();
                connet1.Close();
                if (a > 0)
                {
                    query();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
         #endregion

        #region 删除
        private void tsbDelete_Click(object sender, EventArgs e)
        {
            delete();
        }
        #endregion
        #region 删除语句
        private void delete()
        {
            try
            {
                int[] rowCount = this.gridView1.GetSelectedRows();
                string strSql = "";
                foreach (int i in rowCount)
                {
                    this.gridView1.FocusedRowHandle = -1;
                    string strID = "";
                    strID = this.gridView1.GetRowCellValue(i, "ZMID").ToString();
                    strSql = "delete from new1 where ZMID=" + strID + ""; //注意where处没有单引号               
                }
                OleDbConnection connet1 = new OleDbConnection(strcon);
                connet1.Open();
                OleDbCommand cmd = new OleDbCommand(strSql, connet1);
                int a = cmd.ExecuteNonQuery();
                connet1.Close();
                if (a > 0)
                {
                    MessageBox.Show("删除成功");
                }
                query();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);

            }
        }
        #endregion
    }
}

 

以上内容引用至http://hi.baidu.com/ruheshi/blog/item/7da4b2cb78d3f2f452664feb.html