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