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("*")); }