操作mysql的C#类
发布时间:2020-12-15 17:58:25 所属栏目:百科 来源:网络整理
导读:今天PHP站长网 52php.cn把收集自互联网的代码分享给大家,仅供参考。 需要mysql.data.dll using System;using System.Collections.Generic;using System.Text;using System.Windows.Forms;using System.Data;using System
以下代码由PHP站长网 52php.cn收集自互联网 现在PHP站长网小编把它分享给大家,仅供参考
需要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 } 以上内容由PHP站长网【52php.cn】收集整理供大家参考研究 如果以上内容对您有帮助,欢迎收藏、点赞、推荐、分享。 (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |