| 注册
请输入搜索内容

热门搜索

Java Linux MySQL PHP JavaScript Hibernate jQuery Nginx
dfeeee
10年前发布

操作mysql的C#类

需要mysql.data.dll

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  }