first.cs

数据库操作功能类

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;

namespace dbclass
{
    public class dbclass
    {
        private OleDbConnection conn;
        private OleDbCommand comm;
        public OleDbDataReader dr;
        public OleDbDataAdapter da;
        public DataSet ds;
        public string Sql;

       
        public bool open()
        {
            string strinfo;
            strinfo = "Provider=Microsoft.Jet.OleDb.4.0;";
            strinfo += @"Data Source=G:\db\db1.mdb";
            conn = new System.Data.OleDb.OleDbConnection(strinfo);
            try
            {
                conn.Open();
                return true;
            }
            catch (System.Data.OleDb.OleDbException e)
            {
                return false;
            }

        }
        public void close()
        {
            conn.Close();
        }



        public void dataView()
        {
           
            da = new OleDbDataAdapter(Sql, conn);
            ds = new DataSet();
            da.Fill(ds);
            DataView dv = new DataView(ds.Tables[0]);
        }


        public void readerData()
        {
            try
            {
                comm = new OleDbCommand(Sql, conn);
                dr = comm.ExecuteReader();
            }
            catch(OleDbException e)
            {
               // System.Windows.Forms.MessageBox.Show(e.Message);
            }
            
        }
        

        public bool exesql(string Sql)
        {
           
            comm = new OleDbCommand(Sql, conn);
            try{
                comm.ExecuteNonQuery();
                
                return true;
            }
            catch(OleDbException e){
                System.Windows.Forms.MessageBox.Show(e.Message);
                return false;
            }
            
        }

    }
}