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;
}
