I followed the exact example as given in the demo - http://demos.telerik.com/aspnet-ajax/grid/examples/functionality/filtering/filter-templates/defaultvb.aspx?show-source=true
When the radgrid is displayed, the date is given as 1/16/1520, see attached image.
When tried to filter using the raddatepicker, it takes in the input as M/d/yyyy (e.g. 4/3/2015) format and gives the OracleSQL error "month not valid"
I tried to set the date format in the radgrid_columncreated -
CType(e.Column, GridBoundColumn).DataFormatString = "{0:MM\/dd\/yyyy}"
CType(e.Column, GridBoundColumn).DataFormatString = "{0:d}"
and other rad date formats. Still no luck.
With the rad filter template the date formats are wrong but with the basic filter or no filter the Radgrid is good.
private
RecurrenceRule CreateRecurrenceRule(Appointment appq, ExchangeService service)
{
var pattern = (Microsoft.Exchange.WebServices.Data.Recurrence.IntervalPattern)appq.Recurrence;
var interval = pattern.Interval;
var schedulerPattern =
new
RecurrencePattern();
var schedulerRange =
new
RecurrenceRange { Start = appq.Start, EventDuration = appq.Duration };
if
(!appq.Recurrence.HasEnd) { }
else
{
if
(appq.Recurrence.NumberOfOccurrences !=
null
)
schedulerRange.MaxOccurrences = Convert.ToInt32(appq.Recurrence.NumberOfOccurrences);
else
if
(appq.Recurrence.EndDate !=
null
)
schedulerRange.RecursUntil = Convert.ToDateTime(appq.Recurrence.EndDate).Date.AddMinutes(appq.Duration.Minutes);
if
(appq.Recurrence.GetType() ==
typeof
(Microsoft.Exchange.WebServices.Data.Recurrence.DailyPattern) || appq.Recurrence.GetType() ==
typeof
(Microsoft.Exchange.WebServices.Data.Recurrence.DailyRegenerationPattern))
{
schedulerPattern.Frequency = RecurrenceFrequency.Daily;
schedulerPattern.Interval = interval;
}
else
if
(appq.Recurrence.GetType() ==
typeof
(Microsoft.Exchange.WebServices.Data.Recurrence.WeeklyPattern) || appq.Recurrence.GetType() ==
typeof
(Microsoft.Exchange.WebServices.Data.Recurrence.WeeklyRegenerationPattern))
{
var weekpattern = (Microsoft.Exchange.WebServices.Data.Recurrence.WeeklyPattern)appq.Recurrence;
schedulerPattern.Frequency = RecurrenceFrequency.Weekly;
schedulerPattern.Interval = interval;
var dayOfWeekMask =
new
RecurrenceDay();
foreach
(var day
in
weekpattern.DaysOfTheWeek)
{
switch
(day)
{
case
DayOfTheWeek.Monday: dayOfWeekMask = dayOfWeekMask | RecurrenceDay.Monday;
break
;
case
DayOfTheWeek.Tuesday: dayOfWeekMask = dayOfWeekMask | RecurrenceDay.Tuesday;
break
;
case
DayOfTheWeek.Wednesday: dayOfWeekMask = dayOfWeekMask | RecurrenceDay.Wednesday;
break
;
case
DayOfTheWeek.Thursday: dayOfWeekMask = dayOfWeekMask | RecurrenceDay.Thursday;
break
;
case
DayOfTheWeek.Friday: dayOfWeekMask = dayOfWeekMask | RecurrenceDay.Friday;
break
;
case
DayOfTheWeek.Saturday: dayOfWeekMask = dayOfWeekMask | RecurrenceDay.Saturday;
break
;
case
DayOfTheWeek.Sunday: dayOfWeekMask = dayOfWeekMask | RecurrenceDay.Sunday;
break
;
}
}
schedulerPattern.DaysOfWeekMask = dayOfWeekMask;
}
else
if
(appq.Recurrence.GetType() ==
typeof
(Microsoft.Exchange.WebServices.Data.Recurrence.MonthlyPattern) || appq.Recurrence.GetType() ==
typeof
(Microsoft.Exchange.WebServices.Data.Recurrence.MonthlyRegenerationPattern))
{
var monthpattern = (Microsoft.Exchange.WebServices.Data.Recurrence.MonthlyPattern)appq.Recurrence;
schedulerPattern.Frequency = RecurrenceFrequency.Monthly;
schedulerPattern.Interval = interval;
schedulerPattern.DayOfMonth = monthpattern.DayOfMonth;
}
else
if
(appq.Recurrence.GetType() ==
typeof
(Microsoft.Exchange.WebServices.Data.Recurrence.RelativeMonthlyPattern))
{
var monthpattern = (Microsoft.Exchange.WebServices.Data.Recurrence.RelativeMonthlyPattern)appq.Recurrence;
schedulerPattern.Frequency = RecurrenceFrequency.Monthly;
schedulerPattern.Interval = interval;
schedulerPattern.DaysOfWeekMask = GetDayOfWeekMask(monthpattern.DayOfTheWeek);
schedulerPattern.DayOrdinal = GetDayOfTheWeekIndex(monthpattern.DayOfTheWeekIndex);
}
else
if
(appq.Recurrence.GetType() ==
typeof
(Microsoft.Exchange.WebServices.Data.Recurrence.YearlyPattern) || appq.Recurrence.GetType() ==
typeof
(Microsoft.Exchange.WebServices.Data.Recurrence.YearlyRegenerationPattern))
{
var yearpattern = (Microsoft.Exchange.WebServices.Data.Recurrence.YearlyPattern)appq.Recurrence;
schedulerPattern.Frequency = RecurrenceFrequency.Yearly;
schedulerPattern.DayOfMonth = yearpattern.DayOfMonth;
schedulerPattern.Month = GetRecurrenceMonth(yearpattern.Month);
}
else
if
(appq.Recurrence.GetType() ==
typeof
(Microsoft.Exchange.WebServices.Data.Recurrence.RelativeYearlyPattern))
{
var yearpattern = (Microsoft.Exchange.WebServices.Data.Recurrence.RelativeYearlyPattern)appq.Recurrence;
schedulerPattern.Frequency = RecurrenceFrequency.Yearly;
schedulerPattern.DaysOfWeekMask = GetDayOfWeekMask(yearpattern.DayOfTheWeek);
schedulerPattern.DayOrdinal = GetDayOfTheWeekIndex(yearpattern.DayOfTheWeekIndex);
schedulerPattern.Month = GetRecurrenceMonth(yearpattern.Month);
}
var rrule = RecurrenceRule.FromPatternAndRange(schedulerPattern, schedulerRange);
if
(appq.ModifiedOccurrences !=
null
)
{
foreach
(var item
in
appq.ModifiedOccurrences)
{
rrule.Exceptions.Add(
new
DateTime(Convert.ToInt32(item.OriginalStart.Year), Convert.ToInt32(item.OriginalStart.Month), Convert.ToInt32(item.OriginalStart.Day), Convert.ToInt32(item.OriginalStart.Hour), Convert.ToInt32(item.OriginalStart.Minute), Convert.ToInt32(item.OriginalStart.Second)).ToLocalTime());
}
}
if
(appq.DeletedOccurrences ==
null
)
return
rrule;
foreach
(var item
in
appq.DeletedOccurrences)
{
rrule.Exceptions.Add(
new
DateTime(Convert.ToInt32(item.OriginalStart.Year), Convert.ToInt32(item.OriginalStart.Month), Convert.ToInt32(item.OriginalStart.Day), Convert.ToInt32(item.OriginalStart.Hour), Convert.ToInt32(item.OriginalStart.Minute), Convert.ToInt32(item.OriginalStart.Second)).ToLocalTime());
}
return
rrule;
}
return
null
;
}
<
telerik:RadGrid
AutoGenerateColumns
=
"False"
ID
=
"RadGrid1"
AllowFilteringByColumn
=
"True"
AllowPaging
=
"True"
AllowSorting
=
"True"
runat
=
"server"
OnItemCommand
=
"RadGrid1_ItemCommand"
OnItemCreated
=
"RadGrid1_ItemCreated"
EnableLinqExpressions
=
"true"
HtmlEncode
=
"true"
OnNeedDataSource
=
"RadGrid1_NeedDataSource"
GroupByExpression
=
"JobStatusID Group By JobStatusID"
ShowGroupPanel
=
"True"
CellSpacing
=
"-1"
GridLines
=
"Both"
Skin
=
"Office2010Silver"
EnableViewState
=
"true"
Width
=
"100%"
>
<
PagerStyle
Mode
=
"NextPrevAndNumeric"
/>
<
GroupingSettings
CaseSensitive
=
"false"
/>
<
ClientSettings
AllowKeyboardNavigation
=
"true"
>
</
ClientSettings
>
<
ExportSettings
OpenInNewWindow
=
"true"
FileName
=
"i-Dispatch General Report"
>
<
Pdf
PageHeight
=
"210mm"
PageWidth
=
"297mm"
DefaultFontFamily
=
"Arial Unicode MS"
PageTopMargin
=
"45mm"
BorderStyle
=
"Medium"
BorderColor
=
"#666666"
PaperSize
=
"A4"
>
</
Pdf
>
</
ExportSettings
>
<
MasterTableView
Width
=
"100%"
DataKeyNames
=
"JobID"
HierarchyLoadMode
=
"ServerOnDemand"
>
<
Columns
>
<
telerik:GridMaskedColumn
DataField
=
"JobID"
HeaderText
=
"JobID#"
FilterControlWidth
=
"50px"
AutoPostBackOnFilter
=
"false"
CurrentFilterFunction
=
"EqualTo"
FilterDelay
=
"2000"
ShowFilterIcon
=
"false"
Mask
=
"#####"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
></
ModelErrorMessage
>
</
ColumnValidationSettings
>
</
telerik:GridMaskedColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"Customer Ref No"
DataField
=
"JobCustomerRefNo"
UniqueName
=
"JobCustomerRefNo"
SortExpression
=
"JobCustomerRefNo"
HeaderStyle-Width
=
"180px"
FilterControlAltText
=
"Filter JobCustomerRefNo column"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
></
ModelErrorMessage
>
</
ColumnValidationSettings
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"JobTitle"
FilterControlAltText
=
"Filter JobTitle column"
HeaderText
=
"Job Title"
SortExpression
=
"JobTitle"
UniqueName
=
"JobTitle"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
</
telerik:GridBoundColumn
>
<
telerik:GridDateTimeColumn
DataField
=
"JobBookedDate"
PickerType
=
"DatePicker"
EnableTimeIndependentFiltering
=
"true"
DataFormatString
=
"{0:dd/MM/yyyy HH:mm }"
DataType
=
"System.DateTime"
FilterControlAltText
=
"Filter JobBookedDate column"
HeaderText
=
"Job Booked Date"
SortExpression
=
"JobBookedDate"
UniqueName
=
"JobBookedDate"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
</
telerik:GridDateTimeColumn
>
<
telerik:GridBoundColumn
DataField
=
"JobAddress1"
FilterControlAltText
=
"Filter JobAddress1 column"
HeaderText
=
"Address"
SortExpression
=
"JobAddress1"
UniqueName
=
"JobAddress1"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"JobSuburb"
FilterControlAltText
=
"Filter JobSuburb column"
HeaderText
=
"Suburb"
SortExpression
=
"JobSuburb"
UniqueName
=
"JobSuburb"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"JobPostCode"
FilterControlAltText
=
"Filter JobPostCode column"
HeaderText
=
"PostCode"
SortExpression
=
"JobPostCode"
UniqueName
=
"JobPostCode"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"JobState"
FilterControlAltText
=
"Filter JobState column"
HeaderText
=
"State"
SortExpression
=
"JobState"
UniqueName
=
"JobState"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
</
telerik:GridBoundColumn
>
<
telerik:GridTemplateColumn
DataField
=
"JobStatusID"
HeaderText
=
"Status Type"
UniqueName
=
"JobStatusID"
HeaderStyle-Width
=
"200px"
SortExpression
=
"JobStatusID"
>
<
FilterTemplate
>
<
telerik:RadComboBox
ID
=
"comboJobStatus"
DataTextField
=
"JobStatusName"
DataValueField
=
"JobStatusID"
Height
=
"100px"
AppendDataBoundItems
=
"true"
SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("JobStatusID").CurrentFilterValue %>'
runat="server" OnClientSelectedIndexChanged="JobStatusIndexChanged">
<
Items
>
<
telerik:RadComboBoxItem
Text
=
"All"
/>
</
Items
>
</
telerik:RadComboBox
>
<
telerik:RadScriptBlock
ID
=
"RadScriptBlock3"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
function JobStatusIndexChanged(sender, args) {
var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
tableView.filter("JobStatusID", args.get_item().get_value(), "EqualTo");
}
</
script
>
</
telerik:RadScriptBlock
>
</
FilterTemplate
>
<
ItemTemplate
>
<%# Eval("JobStatus") %>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
DataField
=
"ClientID"
HeaderText
=
"Client"
UniqueName
=
"ClientID"
HeaderStyle-Width
=
"200px"
SortExpression
=
"ClientID"
>
<
FilterTemplate
>
<
telerik:RadComboBox
ID
=
"comboClient"
DataTextField
=
"ClientName"
DataValueField
=
"ClientID"
Height
=
"100px"
AppendDataBoundItems
=
"true"
SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("ClientID").CurrentFilterValue %>'
runat="server" OnClientSelectedIndexChanged="ClientIndexChanged">
<
Items
>
<
telerik:RadComboBoxItem
Text
=
"All"
/>
</
Items
>
</
telerik:RadComboBox
>
<
telerik:RadScriptBlock
ID
=
"RadScriptBlock2"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
function ClientIndexChanged(sender, args) {
var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
tableView.filter("ClientID", args.get_item().get_value(), "EqualTo");
}
</
script
>
</
telerik:RadScriptBlock
>
</
FilterTemplate
>
<
ItemTemplate
>
<%# Eval("Client") %>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
DataField
=
"AssignedStaffID"
HeaderText
=
"Staff"
UniqueName
=
"AssignedStaffID"
HeaderStyle-Width
=
"200px"
SortExpression
=
"AssignedStaffID"
>
<
FilterTemplate
>
<
telerik:RadComboBox
ID
=
"comboStaff"
DataTextField
=
"StaffName"
DataValueField
=
"StaffID"
Height
=
"100px"
AppendDataBoundItems
=
"true"
SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("AssignedStaffID").CurrentFilterValue %>'
runat="server" OnClientSelectedIndexChanged="StaffIndexChanged">
<
Items
>
<
telerik:RadComboBoxItem
Text
=
"All"
/>
</
Items
>
</
telerik:RadComboBox
>
<
telerik:RadScriptBlock
ID
=
"RadScriptBlock10"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
function StaffIndexChanged(sender, args) {
var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
tableView.filter("AssignedStaffID", args.get_item().get_value(), "EqualTo");
}
</
script
>
</
telerik:RadScriptBlock
>
</
FilterTemplate
>
<
ItemTemplate
>
<%# Eval("AssignedStaff") %>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
</
Columns
>
<
NestedViewTemplate
>
<
asp:Panel
runat
=
"server"
ID
=
"InnerContainer"
CssClass
=
"viewWrap"
Visible
=
"false"
>
<
telerik:RadGrid
runat
=
"server"
ID
=
"JobStatusGrid"
OnNeedDataSource
=
"JobStatusGrid_NeedDataSource"
>
<
MasterTableView
ShowHeader
=
"true"
AutoGenerateColumns
=
"False"
AllowPaging
=
"true"
DataKeyNames
=
"JobStatusHistoryID"
PageSize
=
"7"
HierarchyLoadMode
=
"Client"
>
<
Columns
>
<
telerik:GridBoundColumn
HeaderText
=
"Status Type"
HeaderButtonType
=
"TextButton"
DataField
=
"JobStatus"
UniqueName
=
"JobStatusID"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"Created By"
HeaderButtonType
=
"TextButton"
DataField
=
"CreatedBy"
UniqueName
=
"CreatedBy"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
HeaderText
=
"Created On"
HeaderButtonType
=
"TextButton"
DataField
=
"CreatedOn"
UniqueName
=
"CreatedOn"
>
</
telerik:GridBoundColumn
>
</
Columns
>
</
MasterTableView
>
</
telerik:RadGrid
>
</
asp:Panel
>
</
NestedViewTemplate
>
</
MasterTableView
>
<
ClientSettings
AllowDragToGroup
=
"true"
>
<
Scrolling
AllowScroll
=
"True"
UseStaticHeaders
=
"True"
/>
</
ClientSettings
>
</
telerik:RadGrid
>
protected
void
btnGeneralReportPDF_Click(
object
sender, ImageClickEventArgs e)
{
//RadGrid1.ExportSettings.ExportOnlyData = true;
RadGrid1.ExportSettings.OpenInNewWindow =
true
;
//RadGrid1.ExportSettings.IgnorePaging = true;
headerMiddleCell = headerMiddleCell.Replace(
"<$companyname$>"
, "company name");
headerMiddleCell = headerMiddleCell.Replace(
"<$reportname$>"
,
"Report"
);
headerMiddleCell = headerMiddleCell.Replace(
"<$daterange$>"
, "1-1-2015 / 2-2-2015"
);
RadGrid1.ExportSettings.Pdf.PageHeader.MiddleCell.Text = headerMiddleCell;
// to get lanscape orientation
RadGrid1.ExportSettings.Pdf.PageHeight = Unit.Parse(
"162mm"
);
RadGrid1.ExportSettings.Pdf.PageWidth = Unit.Parse(
"600mm"
);
foreach
(GridDataItem gi
in
RadGrid1.MasterTableView.Items)
{
gi.Expanded =
true
;
if
(gi.HasChildItems)
{
RadGrid rgHeader = (RadGrid)gi.ChildItem.NestedViewCell.Controls[0].Controls[1].Controls[1];
rgHeader.Rebind();
}
}
RadGrid1.MasterTableView.HierarchyDefaultExpanded =
true
;
//RadGrid1.Rebind();
RadGrid1.MasterTableView.ExportToPdf();
}
001.
<
telerik:RadGrid
ID
=
"radProject3"
runat
=
"server"
002.
AutoGenerateColumns
=
"False"
003.
AllowSorting
=
"True"
004.
AllowPaging
=
"True"
005.
ShowFooter
=
"True"
006.
ShowGroupPanel
=
"true"
007.
AllowFilteringByColumn
=
"False"
008.
EnableGroupsExpandAll
=
"True"
009.
EnableHeaderContextMenu
=
"true"
010.
EnableHeaderContextFilterMenu
=
"False"
011.
CellSpacing
=
"0"
012.
PageSize
=
"25"
013.
>
014.
<
ExportSettings
HideStructureColumns
=
"true"
015.
ExportOnlyData
=
"true"
016.
IgnorePaging
=
"true"
017.
OpenInNewWindow
=
"true"
018.
FileName
=
"TaskSheet"
019.
>
020.
<
Csv
RowDelimiter
=
"Tab"
/>
021.
<
Excel
Format
=
"Html"
AutoFitImages
=
"true"
/>
022.
<
Pdf
FontType
=
"Link"
ForceTextWrap
=
"true"
BorderColor
=
"#000000"
BorderStyle
=
"Thin"
BorderType
=
"AllBorders"
DefaultFontFamily
=
"Arial"
>
023.
<
PageHeader
>
024.
<
LeftCell
Text
=
""
TextAlign
=
"Left"
/>
025.
<
RightCell
Text
=
""
TextAlign
=
"Right"
/>
026.
</
PageHeader
>
027.
</
Pdf
>
028.
</
ExportSettings
>
029.
<
MasterTableView
DataKeyNames
=
"FullJobNo, t_Briefno, t_BriefVersionNo, t_BriefRevisionNo"
030.
ClientDataKeyNames
=
"FullJobNo, t_Briefno, t_BriefVersionNo, t_BriefRevisionNo"
031.
AllowMultiColumnSorting
=
"True"
032.
EnableHierarchyExpandAll
=
"true"
033.
GroupLoadMode
=
"Server"
034.
Name
=
"ARMPROJECT"
035.
FilterItemStyle-Height
=
"10px"
036.
CommandItemDisplay
=
"top"
037.
CommandItemStyle-Height
=
"5px"
038.
>
039.
<
PagerStyle
Mode
=
"NextPrevAndNumeric"
AlwaysVisible
=
"true"
PageSizes
=
"{20, 25, 50, 75, 100, 200, 250, 500, 750, 1000, 1000}"
></
PagerStyle
>
040.
<
GroupByExpressions
>
041.
<
telerik:GridGroupByExpression
>
042.
<
SelectFields
>
043.
<
telerik:GridGroupByField
FieldName
=
"assignedto"
HeaderText
=
"Assigned To"
/>
044.
</
SelectFields
>
045.
<
GroupByFields
>
046.
<
telerik:GridGroupByField
FieldName
=
"assignedto"
SortOrder
=
"Ascending"
/>
047.
</
GroupByFields
>
048.
</
telerik:GridGroupByExpression
>
049.
</
GroupByExpressions
>
050.
<
CommandItemSettings
051.
ShowExportToExcelButton
=
"false"
052.
ShowRefreshButton
=
"true"
053.
ShowAddNewRecordButton
=
"false"
/>
054.
<
Columns
>
055.
<
telerik:GridTemplateColumn
DataField
=
"Fav"
GroupByExpression
=
"Fav Group By Fav"
UniqueName
=
"Fav"
HeaderText
=
"Fav"
SortExpression
=
"Fav"
ItemStyle-Width
=
"16px"
AllowFiltering
=
"false"
HeaderStyle-Width
=
"16px"
>
056.
<
ItemTemplate
>
057.
<
asp:ImageButton
runat
=
"server"
ID
=
"ImgFav"
ImageUrl='<%# String.Format("~/images/icons/{0}", Eval("imgFav"))%>' Width="16px" Height="16px" />
058.
<
asp:HiddenField
runat
=
"server"
ID
=
"hdnFav"
Value='<%#Eval("Fav") %>' />
059.
<
asp:HiddenField
runat
=
"server"
ID
=
"hdnIntRev"
Value='<%#Eval("InternalReview1") %>' />
060.
<
asp:HiddenField
runat
=
"server"
ID
=
"hdnClPr"
Value='<%#Eval("ClientPresentation1") %>' />
061.
<
asp:HiddenField
runat
=
"server"
ID
=
"hdnDead"
Value='<%#Eval("Deadline1") %>' />
062.
</
ItemTemplate
>
063.
</
telerik:GridTemplateColumn
>
064.
<
telerik:GridBoundColumn
DataField
=
"FavText"
UniqueName
=
"FavText"
HeaderText
=
"Fav"
SortExpression
=
"FavText"
AllowFiltering
=
"false"
Visible
=
"false"
ItemStyle-Width
=
"30px"
HeaderStyle-Width
=
"30px"
>
065.
<
ColumnValidationSettings
>
066.
<
ModelErrorMessage
Text
=
""
></
ModelErrorMessage
>
067.
</
ColumnValidationSettings
>
068.
</
telerik:GridBoundColumn
>
069.
<
telerik:GridBoundColumn
DataField
=
"FullJobNo"
UniqueName
=
"FullJobNo"
HeaderText
=
"Job No"
SortExpression
=
"FullJobNo"
ItemStyle-Width
=
"90px"
AllowFiltering
=
"false"
>
070.
<
ColumnValidationSettings
>
071.
<
ModelErrorMessage
Text
=
""
></
ModelErrorMessage
>
072.
</
ColumnValidationSettings
>
073.
</
telerik:GridBoundColumn
>
074.
<
telerik:GridTemplateColumn
GroupByExpression
=
"FullBriefNo Group By FullBriefNo"
UniqueName
=
"FullBriefNo"
HeaderText
=
"Brief No"
SortExpression
=
"FullBriefNo"
AllowFiltering
=
"false"
ItemStyle-Width
=
"70px"
>
075.
<
ItemTemplate
>
076.
<
asp:Label
runat
=
"server"
ID
=
"lblFullBriefNoWithD"
Text='<%#Eval("FullBriefNoWithD")%>' Width="70px"></
asp:Label
>
077.
<
asp:Label
runat
=
"server"
ID
=
"lblFullBriefNo"
Text='<%#Eval("FullBriefNo") %>' Visible="false"></
asp:Label
>
078.
<
asp:HiddenField
runat
=
"server"
ID
=
"hdnCostCentreCode"
Value='<%#Eval("t_costcentrecode") %>' />
079.
</
ItemTemplate
>
080.
</
telerik:GridTemplateColumn
>
081.
<
telerik:GridBoundColumn
DataField
=
"t_BriefType"
UniqueName
=
"t_BriefType"
HeaderText
=
"Brief Type"
SortExpression
=
"t_BriefType"
AllowFiltering
=
"false"
>
082.
<
ColumnValidationSettings
>
083.
<
ModelErrorMessage
Text
=
""
></
ModelErrorMessage
>
084.
</
ColumnValidationSettings
>
085.
</
telerik:GridBoundColumn
>
086.
<
telerik:GridBoundColumn
DataField
=
"t_briefdescription"
UniqueName
=
"t_briefdescription"
HeaderText
=
"Brief Title"
SortExpression
=
"t_briefdescription"
AllowFiltering
=
"false"
087.
ItemStyle-HorizontalAlign
=
"Left"
HeaderStyle-HorizontalAlign
=
"Left"
>
088.
<
ColumnValidationSettings
>
089.
<
ModelErrorMessage
Text
=
""
></
ModelErrorMessage
>
090.
</
ColumnValidationSettings
>
091.
</
telerik:GridBoundColumn
>
092.
<
telerik:GridBoundColumn
DataField
=
"t_jobdescription"
UniqueName
=
"t_jobdescription"
HeaderText
=
"Job Description"
SortExpression
=
"t_jobdescription"
AllowFiltering
=
"false"
093.
ItemStyle-HorizontalAlign
=
"Left"
HeaderStyle-HorizontalAlign
=
"Left"
HeaderStyle-width
=
"200px"
>
094.
<
ColumnValidationSettings
>
095.
<
ModelErrorMessage
Text
=
""
></
ModelErrorMessage
>
096.
</
ColumnValidationSettings
>
097.
</
telerik:GridBoundColumn
>
098.
<
telerik:GridBoundColumn
DataField
=
"brieffeed"
UniqueName
=
"t_brieffeed"
HeaderText
=
"Feed"
SortExpression
=
"brieffeed"
AllowFiltering
=
"false"
>
099.
<
ColumnValidationSettings
>
100.
<
ModelErrorMessage
Text
=
""
></
ModelErrorMessage
>
101.
</
ColumnValidationSettings
>
102.
</
telerik:GridBoundColumn
>
103.
<
telerik:GridBoundColumn
DataField
=
"t_taskname"
UniqueName
=
"t_taskname"
HeaderText
=
"Task Name"
SortExpression
=
"t_taskname"
AllowFiltering
=
"false"
>
104.
<
ColumnValidationSettings
>
105.
<
ModelErrorMessage
Text
=
""
></
ModelErrorMessage
>
106.
</
ColumnValidationSettings
>
107.
</
telerik:GridBoundColumn
>
108.
<
telerik:GridBoundColumn
DataField
=
"assignedto"
UniqueName
=
"t_assignedto"
HeaderText
=
"Assigned To"
SortExpression
=
"assignedto"
AllowFiltering
=
"false"
>
109.
<
ColumnValidationSettings
>
110.
<
ModelErrorMessage
Text
=
""
></
ModelErrorMessage
>
111.
</
ColumnValidationSettings
>
112.
</
telerik:GridBoundColumn
>
113.
<
telerik:GridBoundColumn
DataField
=
"ClientName"
UniqueName
=
"ClientName"
HeaderText
=
"Client Name"
SortExpression
=
"ClientName"
AllowFiltering
=
"false"
>
114.
<
ColumnValidationSettings
>
115.
<
ModelErrorMessage
Text
=
""
></
ModelErrorMessage
>
116.
</
ColumnValidationSettings
>
117.
</
telerik:GridBoundColumn
>
118.
<
telerik:GridBoundColumn
DataField
=
"BrandName"
UniqueName
=
"BrandName"
HeaderText
=
"Brand Name"
SortExpression
=
"BrandName"
AllowFiltering
=
"false"
>
119.
<
ColumnValidationSettings
>
120.
<
ModelErrorMessage
Text
=
""
></
ModelErrorMessage
>
121.
</
ColumnValidationSettings
>
122.
</
telerik:GridBoundColumn
>
123.
<
telerik:GridTemplateColumn
GroupByExpression
=
"t_OriginalFileName Group By t_OriginalFileName"
UniqueName
=
"t_FileName"
HeaderText
=
"File Name"
SortExpression
=
"t_OriginalFileName"
124.
AllowFiltering
=
"false"
125.
Exportable
=
"false"
>
126.
<
ItemTemplate
>
127.
<%-- <
asp:LinkButton
runat
=
"server"
ID
=
"lnkViewFile"
OnClick
=
"lnkViewFile_Click"
Text='<%#Eval("t_FileName") %>'></
asp:LinkButton
>--%>
128.
<
asp:Label
runat
=
"server"
ID
=
"lblViewFile"
Text='<%#Eval("t_OriginalFileName")%>' Visible="true" ></
asp:Label
>
129.
</
ItemTemplate
>
130.
</
telerik:GridTemplateColumn
>
131.
<
telerik:GridBoundColumn
DataField
=
"InternalReview"
UniqueName
=
"InternalReview"
HeaderText
=
"Internal Review"
SortExpression
=
"InternalReview1"
AllowFiltering
=
"false"
132.
HeaderStyle-HorizontalAlign
=
"Left"
ItemStyle-HorizontalAlign
=
"Left"
>
133.
<
ColumnValidationSettings
>
134.
<
ModelErrorMessage
Text
=
""
></
ModelErrorMessage
>
135.
</
ColumnValidationSettings
>
136.
</
telerik:GridBoundColumn
>
137.
<
telerik:GridBoundColumn
DataField
=
"Deadline"
UniqueName
=
"Deadline"
HeaderText
=
"Deadline"
SortExpression
=
"Deadline1"
AllowFiltering
=
"false"
138.
HeaderStyle-HorizontalAlign
=
"Left"
ItemStyle-HorizontalAlign
=
"Left"
>
139.
<
ColumnValidationSettings
>
140.
<
ModelErrorMessage
Text
=
""
></
ModelErrorMessage
>
141.
</
ColumnValidationSettings
>
142.
</
telerik:GridBoundColumn
>
143.
<
telerik:GridBoundColumn
DataField
=
"ClientPresentation"
UniqueName
=
"ClientPresentation"
HeaderText
=
"Client Presentation"
SortExpression
=
"ClientPresentation1"
AllowFiltering
=
"false"
144.
HeaderStyle-HorizontalAlign
=
"Left"
ItemStyle-HorizontalAlign
=
"Left"
>
145.
<
ColumnValidationSettings
>
146.
<
ModelErrorMessage
Text
=
""
></
ModelErrorMessage
>
147.
</
ColumnValidationSettings
>
148.
</
telerik:GridBoundColumn
>
149.
<
telerik:GridBoundColumn
DataField
=
"t_UploadedBy"
UniqueName
=
"t_UploadedBy"
HeaderText
=
"Created By"
SortExpression
=
"t_UploadedBy"
AllowFiltering
=
"false"
>
150.
<
ColumnValidationSettings
>
151.
<
ModelErrorMessage
Text
=
""
></
ModelErrorMessage
>
152.
</
ColumnValidationSettings
>
153.
</
telerik:GridBoundColumn
>
154.
<
telerik:GridBoundColumn
DataField
=
"t_UploadedOn"
UniqueName
=
"t_UploadedOn"
HeaderText
=
"Created Date"
SortExpression
=
"t_UploadedOn"
DataFormatString
=
"{0:dd-MM-yyyy HH:mm:ss}"
AllowFiltering
=
"false"
ItemStyle-Width
=
"110px"
>
155.
<
ColumnValidationSettings
>
156.
<
ModelErrorMessage
Text
=
""
></
ModelErrorMessage
>
157.
</
ColumnValidationSettings
>
158.
</
telerik:GridBoundColumn
>
159.
<
telerik:GridBoundColumn
DataField
=
"t_ApprovalStatus"
UniqueName
=
"t_ApprovalStatus"
HeaderText
=
"Brief Status"
SortExpression
=
"t_ApprovalStatus"
AllowFiltering
=
"false"
>
160.
<
ColumnValidationSettings
>
161.
<
ModelErrorMessage
Text
=
""
></
ModelErrorMessage
>
162.
</
ColumnValidationSettings
>
163.
</
telerik:GridBoundColumn
>
164.
<
telerik:GridBoundColumn
DataField
=
"t_flowstatusname"
UniqueName
=
"t_flowstatusname"
HeaderText
=
"Flow Status"
SortExpression
=
"t_flowstatusname"
AllowFiltering
=
"false"
>
165.
<
ColumnValidationSettings
>
166.
<
ModelErrorMessage
Text
=
""
></
ModelErrorMessage
>
167.
</
ColumnValidationSettings
>
168.
</
telerik:GridBoundColumn
>
169.
<
telerik:GridBoundColumn
DataField
=
"CreativeDirectorName"
UniqueName
=
"t_CreativeDirectorCode"
HeaderText
=
"Creative Director"
SortExpression
=
"CreativeDirectorName"
AllowFiltering
=
"false"
>
170.
<
ColumnValidationSettings
>
171.
<
ModelErrorMessage
Text
=
""
></
ModelErrorMessage
>
172.
</
ColumnValidationSettings
>
173.
</
telerik:GridBoundColumn
>
174.
<
telerik:GridBoundColumn
DataField
=
"taskstatus"
UniqueName
=
"taskstatus"
HeaderText
=
"Status"
SortExpression
=
"taskstatus"
AllowFiltering
=
"false"
>
175.
<
ColumnValidationSettings
>
176.
<
ModelErrorMessage
Text
=
""
></
ModelErrorMessage
>
177.
</
ColumnValidationSettings
>
178.
</
telerik:GridBoundColumn
>
179.
</
Columns
>
180.
</
MasterTableView
>
181.
182.
<
ClientSettings
AllowDragToGroup
=
"true"
AllowColumnsReorder
=
"true"
183.
ReorderColumnsOnClient
=
"true"
ColumnsReorderMethod
=
"Reorder"
>
184.
<
Resizing
EnableRealTimeResize
=
"True"
ResizeGridOnColumnResize
=
"True"
185.
AllowColumnResize
=
"True"
ClipCellContentOnResize
=
"false"
AllowResizeToFit
=
"true"
/>
186.
<
ClientEvents
OnRowDblClick
=
"RowDblClick"
187.
OnRowContextMenu
=
"RowContextMenu"
/>
188.
</
ClientSettings
>
189.
<
GroupingSettings
ShowUnGroupButton
=
"true"
></
GroupingSettings
>
190.
</
telerik:RadGrid
>
01.
Private
Sub
radProject_NeedDataSource(sender
As
Object
, e
As
GridNeedDataSourceEventArgs)
Handles
radProject3.NeedDataSource
02.
Try
03.
Dim
dsData
As
DataSet =
New
DataSet
04.
dsData = LoadBrief()
05.
radProject3.DataSource = dsData
06.
Catch
ex
As
Exception
07.
08.
End
Try
09.
End
Sub
01.
Exception information:
02.
Exception type: ArgumentException
03.
Exception message: Column 'assignedto' does not belong to table Table.
04.
at System.Data.DataRow.GetDataColumn(String columnName)
05.
at System.Data.DataRow.get_Item(String columnName)
06.
at lambda_method(Closure , DataRowView )
07.
at System.Linq.Lookup`2.Create[TSource](IEnumerable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer)
08.
at System.Linq.GroupedEnumerable`3.GetEnumerator()
09.
at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
10.
at System.Linq.OrderedEnumerable`1.<
GetEnumerator
>d__0.MoveNext()
11.
at Telerik.Web.UI.GridLinqGroupingHelper.CreateAllGroups(IEnumerable enumerable, List`1 groupFields, GridGroup parentGroup, Int32 level)
12.
at Telerik.Web.UI.GridLinqGroupingHelper.GetGroupedItemsForCurrentPage(IQueryable queryable)
13.
at Telerik.Web.UI.GridDataTableFromEnumerable.FillData35()
14.
at Telerik.Web.UI.GridDataTableFromEnumerable.FillData()
15.
at Telerik.Web.UI.GridResolveEnumerable.Initialize()
16.
at Telerik.Web.UI.GridResolveEnumerable.EnsureInitialized()
17.
at Telerik.Web.UI.GridEnumerableFromDataView..ctor(GridTableView owner, DataView dataView, Boolean autoGenerateColumns, GridColumnCollection presentColumns, String[] additionalField, Boolean retrieveAllFields, Boolean enableSplitHeaderText)
18.
at Telerik.Web.UI.GridDataSourceHelper.CreateGridEnumerable(GridTableView owner, IEnumerable enumerable, Boolean caseSensitive, Boolean autoGenerateColumns, GridColumnCollection presentColumns, String[] additionalField, Boolean retrieveAllFields, Boolean enableSplitHeaderText)
19.
at Telerik.Web.UI.GridDataSourceHelper.GetResolvedDataSource(GridTableView owner, Object dataSource, String dataMember, Boolean caseSensitive, Boolean autoGenerateColumns, GridColumnCollection presentColumns, String[] additionalField, Boolean retrieveAllFields, Boolean enableSplitHeaderText)
20.
at Telerik.Web.UI.GridTableView.get_ResolvedDataSource()
21.
at Telerik.Web.UI.GridTableView.CreateChildControls(IEnumerable dataSource, Boolean useDataSource)
22.
at System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data)
23.
at System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data)
24.
at System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback)
25.
at System.Web.UI.WebControls.DataBoundControl.PerformSelect()
26.
at Telerik.Web.UI.GridTableView.PerformSelect()
27.
at System.Web.UI.WebControls.BaseDataBoundControl.DataBind()
28.
at Telerik.Web.UI.GridTableView.DataBind()
29.
at Telerik.Web.UI.RadGrid.DataBind()
30.
at Telerik.Web.UI.RadGrid.AutoDataBind(GridRebindReason rebindReason)
31.
at Telerik.Web.UI.RadGrid.OnLoad(EventArgs e)
32.
at System.Web.UI.Control.LoadRecursive()
33.
at System.Web.UI.Control.LoadRecursive()
34.
at System.Web.UI.Control.LoadRecursive()
35.
at System.Web.UI.Control.LoadRecursive()
36.
at System.Web.UI.Control.LoadRecursive()
37.
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)