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

namespace schoolManager
{
    class DataMessager
    {
        public DataMessager(String runPath)
        {
            conStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + runPath + @"\data.mdb;User ID=Admin;Password=;";
            myCon = new OleDbConnection(conStr);
        }
        private string conStr;
        private OleDbConnection myCon;

        public DataTable query(String queryString,String tableName)//查詢字符串
        {
           try
           {
                if (myCon.State == ConnectionState.Closed) { myCon.Open(); }
                OleDbDataAdapter thisAdapter= new OleDbDataAdapter(queryString,myCon);
				OleDbCommandBuilder thisBuilder=new OleDbCommandBuilder(thisAdapter);
				DataSet thisDataSet=new DataSet();
				thisAdapter.Fill(thisDataSet,tableName);
                return thisDataSet.Tables[tableName];
           }
           catch(Exception e)
           {
               MessageBox.Show(e.Message.ToString(),"出錯",MessageBoxButtons.OK,MessageBoxIcon.Error);
               return null;
           }
           finally
           {
               myCon.Close();
           }
        }
        public bool modify(String modifyString)//更新命令
        {
            try
            {
                if (myCon.State == ConnectionState.Closed) { myCon.Open(); }                    
                OleDbCommand myCommand = new OleDbCommand(modifyString, myCon);
                myCommand.ExecuteNonQuery();
                return true;
            }
            catch (Exception e)
            {
                MessageBox.Show(e.Message.ToString(), "出錯", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return false;
            }
            finally
            {
                myCon.Close();
            }
        }
    }
}