public IList <DataFilterField> GetSourceFieldsFromDatabase(string databaseObject) { IList <DataFilterField> entities = new List <DataFilterField>(); string sql = string.Format("select top 1 * from {0}", databaseObject); // try { Database db = GetDatabaseInstance(); DbCommand dbCommand = db.GetSqlStringCommand(sql); DataSet ds = db.ExecuteDataSet(dbCommand); if (ds != null && ds.Tables.Count > 0) { foreach (DataColumn dc in ds.Tables[0].Columns) { DataFilterField dff = new DataFilterField(); dff.KeyField = dc.ColumnName; dff.KeyType = dc.DataType.Name; dff.IsAttribute = false; dff.KeyDesc = string.Empty; entities.Add(dff); } } } catch (Exception ex) { ExceptionPolicy.HandleException(ex, ExceptionPolicy.DataAccessDefaultPolicy); } // return(entities); }
/// <summary> /// Clear method implementation /// </summary> public void Clear() { filterfield = DataFilterField.UserName; filteroperator = DataFilterOperator.Contains; filtermethod = PreferredMethod.None; filtervalue = string.Empty; enabledonly = false; filterisactive = false; }