Ejemplo n.º 1
0
 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;
 }
Ejemplo n.º 2
0
        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;
        }