C#连接mysql类

概述C#连接mysql类

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

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

 using System;using System.Collections.Generic;using System.Text;using System.windows.Forms;using System.Data;using System.Text.RegularExpressions;///using mysql.data.MysqLClIEnt;    namespace nameSpace{    class MysqLConnection    {        MysqLConnection MysqLConnection;        DataSet dataSet;        string IP = null;        string Username = "root";        string Password = "root";        string Database = null;          public MysqLConnection()        {            try            {                MysqLConnection = new MysqLConnection("datasource=20.0.0.20;username=root;password=root;database=sysinfo;charset=gb2312");            }            catch (MysqLException ex)            {                MessageBox.Show(ex.Message);            }        }          public MysqLConnection(string IP,string Username,string Password,string Database)        {            try            {                string connectionString = "datasource=" + IP + ";username="+Username+";password="+Password+";database=" + Database+ ";charset=gb2312" ;                MysqLConnection = new MysqLConnection(connectionString);            }            catch (MysqLException ex)            {                MessageBox.Show(ex.Message);            }        }          public string MysqLInfo()        {            string MysqLInfo = null;            try            {                MysqLConnection.open();                MysqLInfo += "Connection Opened." + Environment.Newline;                MysqLInfo += "Connection String:" + MysqLConnection.ConnectionString.ToString() + Environment.Newline;                MysqLInfo += "Database:" + MysqLConnection.Database.ToString() + Environment.Newline;                MysqLInfo += "Connection ServerVersion:" + MysqLConnection.ServerVersion.ToString() + Environment.Newline;                MysqLInfo += "Connection State:" + MysqLConnection.State.ToString() + Environment.Newline;            }            catch (MysqLException ex)            {                Console.Writeline("MysqLException Error:" + ex.ToString());            }            finally            {                MysqLConnection.Close();            }            return MysqLInfo;        }          public int MysqLCommand(string MysqLCommand)        {            try            {                MysqLConnection.open();                Console.Writeline("MysqLConnection Opened.");                MysqLCommand MysqLCommand = new MysqLCommand(MysqLCommand,MysqLConnection);                return MysqLCommand.ExecuteNonquery();            }            catch (MysqLException ex)            {                Console.Writeline("MysqLException Error:" + ex.ToString());                if (Regex.IsMatch(ex.ToString(),""))                {                    MessageBox.Show("数据库已经存在唯一键值");                }            }            finally            {                MysqLConnection.Close();            }            return -1;        }          //        public DataVIEw MysqLDataAdapter(string table)        {            DataVIEw dataVIEw = new DataVIEw();            try            {                MysqLConnection.open();                MysqLDataAdapter MysqLDataAdapter = new MysqLDataAdapter("Select * from " + table,MysqLConnection);                dataSet = new DataSet();                MysqLDataAdapter.Fill(dataSet,table);                dataVIEw = dataSet.tables[table].defaultview;            }            catch (MysqLException ex)            {                MessageBox.Show(ex.Message);            }            finally            {                MysqLConnection.Close();            }            return dataVIEw;        }    }//end class} 

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

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

总结

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

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