C# mysql类代码,CSharp代码库,德仔网

代码语言
代码分类
【CSharp】 C# mysql类
作者:Dezai.CN / 发布于2011/6/15/ 605
<div>using System;
using System.Collections.Generic;
using System.Text;
using System.Windows.Forms;
using System.Data;
using System.Text.RegularExpressions;
///
using MySql.Data.MySqlClient;</div>
<div>
namespace NameSpace
{
 class MysqlConnection
 {
 MySqlConnection mysqlConnection;
 DataSet dataSet;
 string IP = null;
 string UserName = "root";
 string Password = "root";
 string Database = null;</div>
<div> 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);
 }
 }
<div> 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);
 }
 }
<div> 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;
 }
<div> 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;
 }
<div> //
 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
}
<div></div>
试试其它关键字
　mysql类　
同语言下
可能有用的
Dezai.CN贡献的其它代码(4037)