public string getColumns()
{
string htmlCols = "";
TableColumn = TableColumnNames.Split(',');
if (TableColumnWidths != null & TableColumnWidths != "")
{
TableColumnWidth = TableColumnWidths.Split(',');
}
int i = 0;
foreach (string colname in TableColumn)
{
if (TableColumnWidths != null & TableColumnWidths != "")
{
htmlCols = String.Concat(htmlCols, @"
<th style=""text-align: center;"" width=""", TableColumnWidth[i], @""">
", TableColumn[i], @"
</th>");
}
else
{
htmlCols = String.Concat(htmlCols, @"
<th style=""text-align: center;"" width=""", (i == 0 ? 65 : (int)30 / TableColumn.Count()), @"%"">
", TableColumn[i], @"
</th>");
}
i++;
}
return(htmlCols);
}
public SQLQuery SelectAllExcept(params string[] exceptCols)
{
if (TableColumnNames.NotNulle())
{
return(Select(new SelectColumns(this).Except(exceptCols)));
}
return(SelectClause("*"));
}
public SQLQuery SelectAll()
{
if (TableColumnNames.NotNulle())
{
return(Select(new SelectColumns(this)));
}
return(SelectClause("*"));
}
