mysql新建data的方法_分享一个Mysql操作方法类(MySql数据库连接、执行MySqlCommand命令、创建MySqlDataReader对象)...

帮助类：usingSystem;usingSystem.Collections.Generic;usingSystem.Data;usingSystem.Linq;usingSystem.Text;usingSystem.Threading.Tasks;usingMySql.Data.MySqlClient;namespaceTestMYSQL

{public classMySqlHelper

{string M_str_sqlcon = string.Empty;privateMySqlHelper()

{

}public MySqlHelper(stringstr_sqlcon)

{

M_str_sqlcon=str_sqlcon;

}#region 建立MySql数据库连接

///

///建立数据库连接.///

/// 返回MySqlConnection对象

privateMySqlConnection getmysqlcon()

{//string M_str_sqlcon = "server=localhost;user id=root;password=root;database=abc";//根据自己的设置

MySqlConnection myCon = newMySqlConnection(M_str_sqlcon);returnmyCon;

}#endregion

#region 执行MySqlCommand命令

///

///执行MySqlCommand///

/// SQL语句

public int getmysqlcom(stringM_str_sqlstr)

{int rel = 0;

MySqlConnection mysqlcon=null;

MySqlCommand mysqlcom=null;try{

mysqlcon= this.getmysqlcon();

mysqlcon.Open();

mysqlcom= newMySqlCommand(M_str_sqlstr, mysqlcon);

rel=mysqlcom.ExecuteNonQuery();returnrel;

}catch(Exception ex)

{throwex;

}finally{if (mysqlcom != null)

{

mysqlcom.Dispose();

}if (mysqlcon != null)

{

mysqlcon.Close();

mysqlcon.Dispose();

}

}

}#endregion

#region 创建MySqlDataReader对象

///

///创建一个MySqlDataReader对象///

/// SQL语句

/// 返回MySqlDataReader对象

public MySqlDataReader getmysqlread(stringM_str_sqlstr)

{

MySqlConnection mysqlcon= null;

MySqlCommand mysqlcom= null;try{

mysqlcon= this.getmysqlcon();

mysqlcom= newMySqlCommand(M_str_sqlstr, mysqlcon);

mysqlcon.Open();

MySqlDataReader mysqlread=mysqlcom.ExecuteReader(CommandBehavior.CloseConnection);returnmysqlread;

}catch(Exception ex)

{throwex;

}finally{if (mysqlcom != null)

{

mysqlcom.Dispose();

}if (mysqlcon != null)

{

mysqlcon.Close();

mysqlcon.Dispose();

}

}

}#endregion}

}

后台：usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Linq;usingSystem.Text;usingSystem.Threading.Tasks;usingSystem.Windows.Forms;namespaceSQLToMysql_Move

{public partial classForm1 : Form

{publicForm1()

{

InitializeComponent();

}

TestMYSQL.MySqlHelper mysql= new TestMYSQL.MySqlHelper("server=127.0.0.1;user id=root;password=123456;database=ce");private void button1_Click(objectsender, EventArgs e)

{int rel = 0;try{

DataSet dataset= Common.DbHelperSQL.Query("select * from dbo.Num");

DataTable dt= dataset.Tables[0];

dataGridView1.DataSource=dt;for (int i = 0; i < dt.Rows.Count ; i++)

{

label1.Text= dt.Rows[i][0].ToString();

label2.Text= dt.Rows[i][1].ToString();

rel= mysql.getmysqlcom("INSERT INTO `ce`.`notice` (`Content`, `Start_date`, `End_date`) VALUES ('" + dt.Rows[i][1].ToString() + "', '" + dt.Rows[i][0].ToString() + "', '2');");

}

MessageBox.Show((rel> 0) ? "成功" : "失败");

}catch(Exception ex)

{throwex;

}//TestMYSQL.MySqlHelper mysql = new TestMYSQL.MySqlHelper("server=127.0.0.1;user id=root;password=123456;database=ce");//string sql = "INSERT INTO `ce`.`notice` (`Id`, `Content`, `Start_date`, `End_date`) VALUES ('2', '2', '2', '2');";//try//{//int rel = mysql.getmysqlcom(sql);//MessageBox.Show((rel > 0) ? "成功" : "失败");//}//catch (Exception ex)//{//MessageBox.Show(ex.Message);//}

}

}

}

相关DLL:

https://i.cnblogs.com/Files.aspx