protected ArrayList GetValidColumns()
{
try
{
ArrayList allColumns = new ArrayList();
foreach (Column dc in _currentTable.GetColumnsFullHierarchy())
{
if (!(dc.DataType == System.Data.SqlDbType.Binary ||
dc.DataType == System.Data.SqlDbType.Image ||
dc.DataType == System.Data.SqlDbType.NText ||
dc.DataType == System.Data.SqlDbType.Text ||
dc.DataType == System.Data.SqlDbType.Timestamp ||
dc.DataType == System.Data.SqlDbType.Udt ||
dc.DataType == System.Data.SqlDbType.VarBinary ||
dc.DataType == System.Data.SqlDbType.Variant ||
dc.DataType == System.Data.SqlDbType.Money))
{
allColumns.Add(dc);
}
}
return allColumns;
}
catch (Exception ex)
{
throw new Exception(_currentTable.DatabaseName + ": Failed on generation of paging select statement", ex);
}
}