public static string Get(string table_name, string PK_name, string PK_value, string field_name) { string sql = "SELECT " + field_name + " FROM " + table_name + " WHERE " + PK_name + " = " + PK_value; return(AccessHelper.GetSingle(sql).ToString()); }
public static DataTable GetDataTable(string sql) { return(AccessHelper.Query(sql).Tables[0]); }
public static bool Exists(string table_name, string PK_name, string PK_value) { string sql = "SELECT * FROM " + table_name + " WHERE " + PK_name + " = " + PK_value; return(AccessHelper.Exists(sql)); }
public static DataSet GetDataSet(string sql) { return(AccessHelper.Query(sql)); }