public static object GetValue(OleDbConnection conn, string tableName, string fieldName, string filter) { string sql = string.Format(conn.GetDataBaseType() == DataBaseType.MSSQL ? format_MSSQL_GetValueByTableNameAndColumnName : format_Oracle_GetValueByTableNameAndColumnName , tableName, fieldName, string.IsNullOrEmpty(filter) ? "1=1" : filter); object fieldValue = DBHelper.ExecuteScalar(conn, sql); return fieldValue; }
public static List<object> GetValues(OleDbConnection conn, string tableName, string fieldName, string filter) { string sql = string.Format(conn.GetDataBaseType() == DataBaseType.MSSQL ? format_MSSQL_GetValuesByTableNameAndColumnName : format_Oracle_GetValuesByTableNameAndColumnName , tableName, fieldName, string.IsNullOrEmpty(filter) ? "1=1" : filter); DataTable table = DBHelper.ExecuteDataTable(conn, sql); List<object> results = new List<object>(); for (int i = 0; i < table.Rows.Count; i++) { results.Add(table.Rows[i]["fieldValue"]); } return results; }