sandan.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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 mychess
{
    class sandan
    {
        public sandan()
        { }
        public DataTable GetMDBData(string sql, string mdbFile)
        {
            //系统打开Access 文件所需要的连接字符串-------dimak (hizmat kilidigan  ruanjian) + (sandan orni )
            string strconn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + mdbFile;
            //根据连接字符串创建一个数据库连接--------dimak  (sandani  oledb.4.0 arkilik ulayman!)
            OleDbConnection conn = new OleDbConnection(strconn);
            try
            {
                //如果这个连接处于关闭状态，则打开--------sinax ilip  bariman!
                if (conn.State == ConnectionState.Closed)
                    conn.Open();
                //根据sql语句和连接读取数据--------okup alidigan   obikitni iniklayman !
                OleDbDataAdapter mazmun = new OleDbDataAdapter(sql, conn);
                //创建一个存放数据的DataSet 数据集或数据巢-------sanlar topi  xaklida  saklaydigan "dataset" ni iniklayman ! 
                DataSet santopi = new DataSet();
                //用读取的数据填写dataset
                mazmun.Fill(santopi);
                //获取数据集的第一个表，然后返回
                DataTable dt = santopi.Tables[0];
                return dt;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                return null;
            }
        }
        public int RunMDBSQL(string sql, string mdbFile)
        {
            int ret = -1;//ret  kaytidigan  kimmat  ( agar ijraklix  muwpikiyatlik bolsa baxka sanga  aylinidu ) maglup bolsa : "ret=-1";
            string StrConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + mdbFile;
            // bu  ohxaxlar  ( ixlatkan tuanjian bilan  sandan orni ulaymiz)
            try
            {
                OleDbConnection conn = new OleDbConnection(StrConn);//korsutulgan  "orun" wa "ijra kilguqi bilan" ulinix yasaymiz ! 
                if (conn.State == ConnectionState.Closed)
                    conn.Open();
                OleDbCommand comm = new OleDbCommand(sql, conn);//  command  bolsa  buyruk bolup wazipisi ( "buyruk" asasan sandan da  uzgirix yasaydu !)

                ret = comm.ExecuteNonQuery();// buyruk ijrabolup hazirki  ornini kayturidu !
                return ret;
            }
            catch (Exception ex) //hatalik bolsa  ijra kilidu !
            {
                MessageBox.Show(ex.Message);