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

namespace 第四次實驗
{
    class myClass  
    {
        public OleDbConnection getConnect()  
        {
            string MySqlCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\\Visual Studio 2005\\Projects\\C#\\第四次實驗\\第四次實驗\\database\\學生信息.mdb";
            OleDbConnection myCon = new OleDbConnection(MySqlCon);
            return myCon;
        }

        public void getCommon(string sqlLanguage)   
        {
            OleDbConnection con = this.getConnect();
            con.Open();

            OleDbCommand cmd = new OleDbCommand(sqlLanguage, con);
            cmd.ExecuteNonQuery();

            cmd.Dispose();
            con.Close();
            con.Dispose();
        }

        public DataSet getDS(string sqlLanguage, string tableName)
        {
            OleDbConnection con = this.getConnect();
            OleDbDataAdapter da = new OleDbDataAdapter(sqlLanguage, con);
            DataSet myds = new DataSet();
            da.Fill(myds, tableName);
            return myds;
        }

        public OleDbDataReader getRead(string sqlLanguage)
        {
            OleDbConnection con = this.getConnect();
            OleDbCommand cmd = new OleDbCommand(sqlLanguage, con);
            con.Open();
            OleDbDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            return dr;
        }

    }
}