private DataTable FillValuesFromDBDateFormatted()
{
string strColumnDataType = lblColType.Text;
switch (strColumnDataType)
{
case "int":
case "bigint":
break;
case "date":
case "datetime":
case "smalldatetime":
case "datetime2":
case "datetimeoffset":
break;
default:
throw new Exception("Only Date or Integer data types can be selected for Date");
}
string strColumnName = (string)cmbColumns.SelectedItem;
strColumnName = UtilGeneral.GetQuotedString(strColumnName);
int timeperiod = GetTimePeriodType();
DataTable dt = new DataTable();
dt = UtilDwQuery.GetColumnValuesWithDateFormat(SchemaName, TableName, strColumnName, strColumnDataType, timeperiod, SQLDwConfig);
return(dt);
}
private DataTable FillValuesFromDB()
{
string colName = (string)cmbColumns.SelectedItem;
DataTable dt = UtilDwQuery.GetColumnValues(SchemaName, TableName, colName, SQLDwConfig);
return(dt);
}