c# mysql 注册码_C# MySqlHelper

usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Text;usingSystem.Data;usingMySql.Data.MySqlClient;namespacedrWm.mdal

{public classMySqlHelper

{//private static string connstr = @"server=localhost;uid=root;pwd=121535;database=tem;charset=utf8";

private static string connstr = @"Host=127.0.0.1;UserName=root;Password=xxxx;Database=xxxx;Port=3406;CharSet=utf8;Allow Zero Datetime=true";///

///执行sql///

///

///

public static int ExecuteSql(stringsql)

{using (MySqlConnection conn = newMySqlConnection(connstr))

{using (MySqlCommand cmd = newMySqlCommand(sql, conn))

{try{

conn.Open();int rows =cmd.ExecuteNonQuery();returnrows;

}catch(MySql.Data.MySqlClient.MySqlException e)

{

conn.Close();throwe;

}finally{

cmd.Dispose();

conn.Close();

}

}

}

}///

///执行查询语句，返回DataSet///

///

///

///

public static DataSet GetDataSet(stringsql)

{using (MySqlConnection conn = newMySqlConnection(connstr))

{

DataSet ds= newDataSet();try{

conn.Open();

MySqlDataAdapter DataAdapter= newMySqlDataAdapter(sql, conn);

DataAdapter.Fill(ds);

}catch(Exception ex)

{throwex;

}finally{

conn.Close();

}returnds;

}

}

}

}