C#MySQL连接、增删改查方法类
using MySql.Data.MySqlClient;
using System;
using System.Data;
namespace MySQL
{
public class sqlhelp
{
public static string connString = "server=server ip; User ID=用户名; password=密码;database=连接的数据库名;Sslmode=none";//Sslmode=none消除一些版本差异造成的影响
//查询 保存结果为DataTable
public static DataTable LoadData(string sql)
{
DataSet Ds = new DataSet();
MySqlConnection conn = new MySqlConnection(connString);
try
{
conn.Open();
MySqlCommand Cmd = new MySqlCommand(sql, conn);
MySqlDataAdapter Da = new MySqlDataAdapter(Cmd);
Da.Fill(Ds);
}
catch (Exception Ex)
{
throw Ex;
}
finally
{
conn.Close();
}
return Ds.Tables[0];
}
//增、删、改操作类 返回受影响行数 返回0 即操作失败
public static int CURD(string strsql)
{
int flag = 0;
MySqlConnection conn = new MySqlConnection(connString);
try
{
conn.Open();
MySqlCommand Cmd = new MySqlCommand(strsql, conn);
flag = Cmd.ExecuteNonQuery();
}
catch (Exception Ex)
{
throw Ex;
}
finally
{
conn.Close();
}
return flag;
}
}
}