Questions on UI for ASP.NET AJAX Forum

110,764 questions

0 answers

89 views

Radgrid Date column swapped century and year values 2015 as 1520

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.

Filter

asked on 03 Apr 2015

1 answer

47 views

To have ConfigurationPanel only not the pivot result

I have used RadPivotgrid with ConfigurationPanel on one page. On other page i want to show only the ConfigurationPanel not the Pivot result as this page contains option to edit the pivot criteria. i have attached the screenshot for the same. Please suggest.

PivotGrid

answered on 03 Apr 2015

1 answer

245 views

Tooltip on image hover

I'm trying to figure out how I can display a tooltip when hovering over an image. I'm using advanced binding and fetching the data from a database. I would like the tooltip to contain information from the datasource. I'm using this in the context of Sitefinity 7.3 which is using version 2014.3.1209 of RadControls, so I can't use an ItemTemplate. Any ideas on how this can be achieved?

ImageGallery

answered on 03 Apr 2015

1 answer

100 views

Incorrect RecurrenceRule creating - URGENT

Hi,

We are facing critical issue here with Calender control and which needs to be fixed TODAY itself. Seeking urgent support in this.

We are passing parameter as Interval :14 and Recurrence is DailyPattern as seen in the screenshot but the rule is creating as DailyPattern and Interval: 1 which is incorrect.

Interval must be 14 as we have passed but the function :

var rrule = RecurrenceRule.FromPatternAndRange(schedulerPattern, schedulerRange); >> Creating Interval as 1 instead of 14.

Complete function code is attached:

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;

}

Please help us in this URGENT as we need to fix today.

Calendar

answered on 03 Apr 2015

1 answer

356 views

Visual Studio 2015 Support

Is UI for ASP.Net Ajax compatible with new Visual Studio 2015? If not - can you provide a time line for new compatible release?

Installer and VS Extensions

answered on 03 Apr 2015

5 answers

135 views

Custom sprites for burger menu

I have had good success with Mobile render mode even for full-size pages. With a few CSS adjustments provided to me earlier, I have replaced the default burger icon with a 64x64 PNG image.

With reference to the attached screen-grab, are there any options that would allow me to make the menu more prominent?

I'm thinking some type of shading to give it a dimensional look so that it is perceived by the home page visitor as an active control.

I tried the usual properties settings that have worked with the standard rendering, but none of that is helpful for mobile.

Additionally, I'd also like to make it bigger, which may help, but I know of no way to make this work with a larger icon. (Metro Touch skin)

answered on 03 Apr 2015

7 answers

181 views

Export NestedViewTemplate Grid

Hi there,

I have gone through almost all the posts in the forum, however, none of them has helped me :(

I have got a Grid which contains a nested view template object and that consists of a grid as follow:

<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>

My approach is to export the grid into an excel or a pdf file with the following code:

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

}

The above code jumps into "JobStatusGrid_NeedDataSource" method in order to populate the nested data grid, however, it doesn't help me out to come up in the exported file.

Could you please advise me ?
Thank you

Grid

answered on 03 Apr 2015

4 answers

1.0K+ views

ArgumentException, Column 'x' does not belong to table Table

Hi,

we are using a radgrid and randomly get the below error for the column used in GroupByExpressions. The column exists in the query and it works fine most of the time, but sometimes it throws the below error. I have gone through many forum posts but no avail. The try catch statements too dont handle the error and we get the yellow screen of death. we have posted the server log too below. We are using version 2014.1.403.45 of the controls.
Any help would be greatly appreciated.
aspx

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>

Code

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

Server Error Log

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)

Grid

answered on 03 Apr 2015

2 answers

157 views

Disable resize options for specific HTML elements

Hi,

We're using your editor for editing HTML e-mail templates. Almost each container as IMG, TD, TABLE are resizeable in the editor, but we don't want this option for the TABLE and TD tags, se we want to disable this option for specific HTML tags. Is this possible?

Kind regards,
Jelle de Boer

Editor

answered on 03 Apr 2015

1 answer

82 views

Export difference

Hi there,

I do receive the combobox list information in the PDF file, however , it doesn't come in the csv file.
what could be the reason ?
thank you
I've added the grid format.

<telerik:RadGrid AutoGenerateColumns="False" ID="RadGrid4" AllowFilteringByColumn="True" AllowSorting="True" runat="server" OnItemCommand="RadGrid4_ItemCommand" OnItemCreated="RadGrid4_ItemCreated" EnableLinqExpressions="false" HtmlEncode="true" OnNeedDataSource="RadGrid4_NeedDataSource" GroupingSettings-RetainGroupFootersVisibility="true"

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 Job Part Used Report" ExportOnlyData="true">

<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" ShowGroupFooter="true" AllowMultiColumnSorting="true">

<Columns>

<telerik:GridMaskedColumn DataField="JobID" HeaderText="JobID#"

FilterControlWidth="50px" AutoPostBackOnFilter="false" CurrentFilterFunction="EqualTo"

FilterDelay="2000" ShowFilterIcon="false" Mask="#####" GroupByExpression="JobID Group By JobID">

<ColumnValidationSettings>

<ModelErrorMessage Text=""></ModelErrorMessage>

</ColumnValidationSettings>

</telerik:GridMaskedColumn>

<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"

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

</telerik:GridDateTimeColumn>

<telerik:GridTemplateColumn DataField="AssignedStaffID" HeaderText="Mobile 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("Staff") %>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn DataField="CreatedBy" HeaderText="Added By" UniqueName="CreatedBy"

HeaderStyle-Width="200px" SortExpression="CreatedBy">

<FilterTemplate>

<telerik:RadComboBox ID="comboAdded" DataTextField="StaffName"

DataValueField="StaffID" Height="100px" AppendDataBoundItems="true" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("CreatedBy").CurrentFilterValue %>'

runat="server" OnClientSelectedIndexChanged="AddedByIndexChanged">

<Items>

<telerik:RadComboBoxItem Text="All" />

</Items>

</telerik:RadComboBox>

<telerik:RadScriptBlock ID="RadScriptBlock11" runat="server">

<script type="text/javascript">

function AddedByIndexChanged(sender, args) {

var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");

tableView.filter("CreatedBy", args.get_item().get_value(), "EqualTo");

}

</script>

</telerik:RadScriptBlock>

</FilterTemplate>

<ItemTemplate>

<%# Eval("AddedBy") %>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn DataField="PartCode" FilterControlAltText="Filter PartCode column" HeaderText="Part Code" SortExpression="PartCode" UniqueName="PartCode">

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="PartName" Aggregate="Count" FooterText="Total parts: " FilterControlAltText="Filter PartName column" HeaderText="Part Name" SortExpression="PartName" UniqueName="Part Name">

<ColumnValidationSettings>

<ModelErrorMessage Text="" />

</ColumnValidationSettings>

</telerik:GridBoundColumn>

<telerik:GridNumericColumn DataFormatString="{0:$###,##0.00}" DataField="PartPurchasePrice" DataType="System.Double" NumericType="Currency"

HeaderText="Purchase Price" SortExpression="PartPurchasePrice" UniqueName="PartPurchasePrice" Aggregate="Sum" FooterText="Total : " FooterAggregateFormatString="{0:C}">

<FooterStyle Font-Bold="true"></FooterStyle>

</telerik:GridNumericColumn>

<telerik:GridNumericColumn DataFormatString="{0:$###,##0.00}" DataField="PartSalePrice" DataType="System.Double" NumericType="Currency"

HeaderText="Recommended Sale Price" SortExpression="PartSalePrice" UniqueName="PartSalePrice" FooterText="Total: " Aggregate="Sum" FooterAggregateFormatString="{0:C}">

<FooterStyle Font-Bold="true"></FooterStyle>

</telerik:GridNumericColumn>

<telerik:GridNumericColumn DataFormatString="{0:$###,##0.00}" DataField="JobPartUnitPrice" DataType="System.Double" NumericType="Currency"

HeaderText="Sale Price Charged" SortExpression="JobPartUnitPrice" UniqueName="JobPartUnitPrice" Aggregate="Sum" FooterAggregateFormatString="{0:C}">

<FooterStyle Font-Bold="true"></FooterStyle>

</telerik:GridNumericColumn>

<telerik:GridNumericColumn DataField="JobPartQuantity" DataType="System.Double"

HeaderText="Quantity" SortExpression="JobPartQuantity" UniqueName="JobPartQuantity" Aggregate="Sum" FooterAggregateFormatString="{0:n}">

<FooterStyle Font-Bold="true"></FooterStyle>

</telerik:GridNumericColumn>

<telerik:GridNumericColumn DataFormatString="{0:$###,##0.00}" DataField="JobPartGST" DataType="System.Double" NumericType="Currency"

HeaderText="GST Charged" SortExpression="JobPartGST" UniqueName="JobPartGST" Aggregate="Sum" FooterAggregateFormatString="{0:C}">

<FooterStyle Font-Bold="true"></FooterStyle>

</telerik:GridNumericColumn>

<telerik:GridNumericColumn DataFormatString="{0:$###,##0.00}" DataField="JobPartTotal" DataType="System.Double" NumericType="Currency"

HeaderText="Total" SortExpression="JobPartTotal" UniqueName="JobPartTotal" Aggregate="Sum" FooterAggregateFormatString="{0:C}">

<FooterStyle Font-Bold="true"></FooterStyle>

</telerik:GridNumericColumn>

<telerik:GridCalculatedColumn HeaderText="Gross Margin" UniqueName="GrossMargin" DataType="System.Double" DataFormatString="{0:$###,##0.00}"

DataFields="JobPartUnitPrice, PartPurchasePrice" Expression="{0}-{1}" FooterText="Total : "

Aggregate="Sum">

</telerik:GridCalculatedColumn>

<telerik:GridCalculatedColumn HeaderText="Gross Margin Percentage" UniqueName="GrossMarginPercentage" DataType="System.Double" DataFormatString="{0:P}"

DataFields="JobPartUnitPrice, PartPurchasePrice" Expression="iif({0}=0,0,iif(({0}-{1})=0,0,(({0}-{1})/{0})*100))" FooterText="Total : "

Aggregate="Sum">

</telerik:GridCalculatedColumn>

</Columns>

<GroupByExpressions>

<telerik:GridGroupByExpression>

<GroupByFields>

<telerik:GridGroupByField FieldName="JobID"></telerik:GridGroupByField>

</GroupByFields>

<SelectFields>

<telerik:GridGroupByField FieldName="JobID" HeaderText="JobID#"></telerik:GridGroupByField>

</SelectFields>