C#访问SqlServer的工具类SqlServerHelper

概述C#访问SqlServer的工具类SqlServerHelper

下面是内存溢出 jb51.cc 通过网络收集整理的代码片段。

内存溢出小编现在分享给大家，也给大家做个参考。

using System;using System.Collections.Generic;using System.linq;using System.Text;using mysql.data.MysqLClIEnt;using System.Data;class MysqLHelper:Idisposable    {        private MysqLConnection m_conn = null;        private MysqLTransaction m_trans = null;        private bool m_tran_enabled = false;        public MysqLHelper()        {            m_conn = new MysqLConnection();            m_conn.ConnectionString = "Server=localhost;Port=3301;UID=sa;Pwd=000";            m_conn.open();        }        public voID BeginTrans()        {            m_trans = m_conn.BeginTransaction();            m_tran_enabled = true;        }        public voID Commit()        {            if (m_trans != null && m_tran_enabled)            {                m_tran_enabled = false;                m_trans.Commit();            }        }        public voID Rollback()        {            if (m_trans != null && m_tran_enabled)            {                m_tran_enabled = false;                m_trans.Rollback();            }        }        public object querySome(string sql,int fIEldindex)        {            using (MysqLCommand cmd = new MysqLCommand(sql,m_conn))            {                using (MysqLDataReader sr = cmd.ExecuteReader())                {                    if (sr.Read())                    {                        return sr.GetValue(fIEldindex);                    }                }            }            return null;        }        public delegate voID FillValues(MysqLDataReader sr);               public voID querySomes(string sql,FillValues fill)        {            using (MysqLCommand cmd = new MysqLCommand(sql,m_conn))            {                using (MysqLDataReader sr = cmd.ExecuteReader())                {                    fill(sr);                }            }        }        public Datatable Source(string sql)        {            Datatable dt = null;            MysqLCommand cmd = null;            MysqLDataAdapter ad = null;            try            {                lock (dt = new Datatable())                {                    cmd = new MysqLCommand(sql,m_conn);                    ad = new MysqLDataAdapter((MysqLCommand)cmd);                    dt.Clear();                    ad.Fill(dt);                }            }            catch (Exception e)            {                throw e;            }            return dt;        }        public voID ExecProc(string proc,params MysqLParameter[] ps)        {            using (MysqLCommand cmd = new MysqLCommand(proc,m_conn))            {                cmd.CommandType = System.Data.CommandType.StoredProcedure;                foreach (MysqLParameter p in ps)                {                    cmd.Parameters.Add(p);                }                cmd.ExecuteNonquery();            }        }        voID Idisposable.dispose()        {            m_conn.Close();            m_conn.dispose();            if (m_trans != null)            {                m_trans.dispose();            }        }    }

以上是内存溢出(jb51.cc)为你收集整理的全部代码内容，希望文章能够帮你解决所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。

总结

以上是内存溢出为你收集整理的C#访问SqlServer的工具类SqlServerHelper全部内容，希望文章能够帮你解决C#访问SqlServer的工具类SqlServerHelper所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。