/// <summary>
/// 返回一个Datatable（有参）
/// </summary>
/// <param name="sql">语句</param>
/// <param name="values">参数</param>
/// <returns>DataTable</returns>
public static DataTable GetDataSet(string sql, params MySQLDriverCS.MySQLParameter[] values)
{
DataSet ds = new DataSet();
MySQLDriverCS.MySQLCommand cmd = new MySQLDriverCS.MySQLCommand(sql, Connection);
cmd.Parameters.AddRange(values);
MySQLDriverCS.MySQLDataAdapter da = new MySQLDriverCS.MySQLDataAdapter(cmd);
da.Fill(ds);
return(ds.Tables[0]);
}
/// <summary>
/// 返回一个Datatable（无参）
/// </summary>
/// <param name="safeSql">语句</param>
/// <returns>DataTable</returns>
public static DataTable GetDataSet(string safeSql)
{
DataSet ds = new DataSet();
MySQLDriverCS.MySQLCommand cmd = new MySQLDriverCS.MySQLCommand("set names gbk", Connection);
cmd.ExecuteNonQuery();
cmd = new MySQLDriverCS.MySQLCommand(safeSql, Connection);
MySQLDriverCS.MySQLDataAdapter da = new MySQLDriverCS.MySQLDataAdapter(cmd);
da.Fill(ds);
return(ds.Tables[0]);
}