ADO 访问数据库

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

namespace WindowsApplication1
{
    public partial class Form1 : Form
    {
        /// <summary>
        /// 
        /// </summary>
        private ADODB.Connection cn = new ADODB.Connection();

        /// <summary>
        /// 
        /// </summary>
        private ADODB.Recordset rs = new ADODB.Recordset();

        /// <summary>
        /// 
        /// </summary>
        public Form1()
        {
            InitializeComponent();
        }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button1_Click(object sender, EventArgs e)
        {
            try
            {
                cn.ConnectionTimeout = 2;
                cn.Open("Provider=SQLOLEDB.1;Persist Security Info=True;User ID=sa;Initial Catalog=test;Data Source=MHRUSR10","","",-1);
                cn.BeginTrans();
                updates();
                cn.CommitTrans();
            }
            catch (Exception Err)
            {
                MessageBox.Show(Err.Message);
                cn.RollbackTrans();
            }
            finally
            {
                if (cn.State == 1)
                {
                    cn.Close();
                }
            }
        }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button2_Click(object sender, EventArgs e)
        {
            try
            {
                cn.ConnectionTimeout = 2;
                cn.Open("Provider=SQLOLEDB.1;Persist Security Info=True;User ID=sa;Initial Catalog=test;Data Source=MHRUSR10", "", "", -1);
                updates();
            }
            catch(Exception Err)
            {
                MessageBox.Show(Err.Message);
            }
            finally
            {
                if (cn.State == 1)
                {
                    cn.Close();
                }
            }
        }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button3_Click(object sender, EventArgs e)
        {
            try
            {
                cn.ConnectionTimeout = 2;
                cn.Open("Provider=SQLOLEDB.1;Persist Security Info=True;User ID=sa;Initial Catalog=test;Data Source=MHRUSR10", "", "", -1);
                deletes();
            }
            catch (Exception Err)
            {
                MessageBox.Show(Err.Message);
            }
            finally
            {
                if (cn.State == 1)
                {
                    cn.Close();
                }
            }
        }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button4_Click(object sender, EventArgs e)
        {
            try
            {
                cn.ConnectionTimeout = 2;
                cn.Open("Provider=SQLOLEDB.1;Persist Security Info=True;User ID=sa;Initial Catalog=test;Data Source=MHRUSR10", "", "", -1);
                showdata();
            }
            catch (Exception Err)
            {
                MessageBox.Show(Err.Message);
            }
            finally
            {
                if (cn.State == 1)
                {
                    cn.Close();
                }
            }
        }

        /// <summary>
        /// 
        /// </summary>
        private void updates()
        {
            Updates1();
            Updates2();
            Updates3();
            Updates4();
        }

        /// <summary>
        /// 
        /// </summary>
        private void Updates1()
        {
            rs.Open("insert into ta values(1,'王康')", cn, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic, -1);
        }

        /// <summary>
        /// 
        /// </summary>
        private void Updates2()
        {
            rs.Open("insert into ta values(2,'王康')", cn, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic, -1);
        }

        /// <summary>
        /// 
        /// </summary>
        private void Updates3()
        {
            rs.Open("insert into ta values(3,'王康')", cn, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic, -1);
        }

        /// <summary>
        /// 
        /// </summary>
        private void Updates4()
        {
            rs.Open("insert into ta values(1,'王康')", cn, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic, -1);
        }

        /// <summary>
        /// 删除数据
        /// </summary>
        private void deletes()
        {
            rs.Open("delete from ta", cn, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic, -1);
        }

        /// <summary>
        /// 显示数据
        /// </summary>
        private void showdata()
        {
            System.Data.DataTable dt = new System.Data.DataTable();
            dt.TableName = "XXXX";
            System.Data.DataRow dr;
            dt.Columns.Add(new System.Data.DataColumn("编号", typeof(System.String)));
            dt.Columns.Add(new System.Data.DataColumn("姓名", typeof(System.String)));
            rs.Open("select * from ta", cn, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockOptimistic, -1);
            while (!rs.EOF)
            {
                dr = dt.NewRow();
                dr[0] = Convert.ToString(rs.Fields["ID"].Value);
                dr[1] = Convert.ToString(rs.Fields["Name"].Value);
                dt.Rows.Add(dr);
                rs.MoveNext();
            }
            DataSet ds = new DataSet();
            ds.DataSetName = "XXXX";
            ds.Tables.Add(dt);
            dataGridView1.DataSource = ds.Tables["XXXX"];
        }

    }
}