6 answers

247 views

Dear Telerik team,

i have a grid with some extra icon column (GridImageColumn). The value of this column is in another column from db. I make it visible = false from server code.
When i export the grid in Excel (ExportOnlyData = True), i cannot see the value of the GridImageColumn
i want to show on excel the value of the column (db column) and not the icon column.

Thank you in advance for your time.

I Use:
VS 2008 (VB)
Telerik 2011.3.1305.35

Below is the client and server code.

<telerik:RadGrid ID="grdPPCOrders" runat="server" Height="300px" Skin="Windows7"

AllowMultiRowSelection="true">

<HeaderContextMenu CssClass="">

</HeaderContextMenu>

<MasterTableView DataKeyNames="ID">

<Columns>

<telerik:GridClientSelectColumn UniqueName="Selected" HeaderStyle-Width="30">

<HeaderStyle Width="30px"></HeaderStyle>

</telerik:GridClientSelectColumn>

<telerik:GridImageColumn UniqueName="CardTypeImage" HeaderStyle-Width="30" >

<HeaderStyle Width="30px"></HeaderStyle>

</telerik:GridImageColumn>

<telerik:GridImageColumn UniqueName="OrderStatusImage" HeaderStyle-Width="30">

<HeaderStyle Width="30px"></HeaderStyle>

</telerik:GridImageColumn>

<telerik:GridImageColumn UniqueName="HasCreditNoteImage" HeaderStyle-Width="30">

<HeaderStyle Width="30px"></HeaderStyle>

</telerik:GridImageColumn>

<telerik:GridBoundColumn FilterControlWidth="105px" DataField="ID" HeaderText="ID"

SortExpression="ID" UniqueName="ID2" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains"

ShowFilterIcon="false" ItemStyle-Width="50" HeaderStyle-Width="50">

<HeaderStyle Width="50px"></HeaderStyle>

<ItemStyle Width="50px"></ItemStyle>

</telerik:GridBoundColumn>

</Columns>

<CommandItemSettings ShowExportToExcelButton="true" ShowAddNewRecordButton="false" />

<RowIndicatorColumn FilterControlAltText="Filter RowIndicator column">

<HeaderStyle Width="20px"></HeaderStyle>

</RowIndicatorColumn>

<ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column">

<HeaderStyle Width="20px"></HeaderStyle>

</ExpandCollapseColumn>

<EditFormSettings>

<EditColumn FilterControlAltText="Filter EditCommandColumn column">

</EditColumn>

</EditFormSettings>

</MasterTableView>

<ClientSettings AllowKeyboardNavigation="true" EnablePostBackOnRowClick="true" EnableRowHoverStyle="True">

<Selecting AllowRowSelect="True" EnableDragToSelectRows="False" />

<ClientEvents />

<Scrolling AllowScroll="true" UseStaticHeaders="True" SaveScrollPosition="True" />

<Resizing AllowColumnResize="True" AllowResizeToFit="True" EnableRealTimeResize="True" />

</ClientSettings>

<FilterMenu EnableImageSprites="False">

</FilterMenu>

</telerik:RadGrid>

Server:

Protected Sub btnExportExcel_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnExportExcel.Click

grdPPCOrders.ExportSettings.ExportOnlyData = True

'grdPPCOrders.MasterTableView.Columns.Item(0).Visible = False

'grdPPCOrders.MasterTableView.Columns.FindByDataField("CardType").Visible = True !ERROR Cannot find column bound to field

'grdPPCOrders.Columns.FindByDataField("CardType").Visible = True !ERROR Cannot find column bound to field

'grdPPCOrders.MasterTableView.Columns.Item(9).Visible = True

grdPPCOrders.MasterTableView.ExportToExcel()

End Sub

Protected Sub grdPPCOrders_ColumnCreated(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridColumnCreatedEventArgs) Handles grdPPCOrders.ColumnCreated

Select Case e.Column.UniqueName

Case "Notes", "ID", "SupplierID_CustomerID", "VesselID", "OrderStatus", "CardType", "HasCreditNote", "InvoiceDate", "Price", "NetProfit"

Dim boundColumn As GridBoundColumn = CType(e.Column, GridBoundColumn)

boundColumn.Visible = False

End Select

End Sub

Protected Sub grdPPCOrders_ItemDataBound(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridItemEventArgs) Handles grdPPCOrders.ItemDataBound

'Dim SelectedColumn(GridColumns.Count) As String

If TypeOf e.Item Is GridHeaderItem Then

Dim header As GridHeaderItem = DirectCast(e.Item, GridHeaderItem)

'header("OrderStatus").Text = ""

'header("HasCreditNote").Text = ""

End If

If TypeOf e.Item Is GridDataItem Then

Dim dataItem As GridDataItem = CType(e.Item, GridDataItem)

Dim CardTypeColumn As String = dataItem("CardType").Text

If CardTypeColumn = "Virtual" Then

CType(dataItem("CardTypeImage").Controls(0), Image).ImageUrl = "~/Images/CardVirtual.png"

ElseIf CardTypeColumn = "Scratch" Then

CType(dataItem("CardTypeImage").Controls(0), Image).ImageUrl = "~/Images/CardScratch.png"

ElseIf CardTypeColumn = "VirtualOP" Then

CType(dataItem("CardTypeImage").Controls(0), Image).ImageUrl = "~/Images/CardVirtualOP.png"

ElseIf CardTypeColumn = "ScratchOP" Then

CType(dataItem("CardTypeImage").Controls(0), Image).ImageUrl = "~/Images/CardScratchOP.png"

End If

Dim OrderStatusColumn As String = dataItem("OrderStatus").Text

If OrderStatusColumn = "1" Then

CType(dataItem("OrderStatusImage").Controls(0), Image).ImageUrl = "~/Images/OrderClosed.png"

ElseIf OrderStatusColumn = "2" Then

CType(dataItem("OrderStatusImage").Controls(0), Image).ImageUrl = "~/Images/OrderOpen.png"

ElseIf OrderStatusColumn = "3" Then

CType(dataItem("OrderStatusImage").Controls(0), Image).ImageUrl = "~/Images/OrderSuspended.png"

ElseIf OrderStatusColumn = "4" Then

CType(dataItem("OrderStatusImage").Controls(0), Image).ImageUrl = "~/Images/OrderClosedTr.png"

ElseIf OrderStatusColumn = "5" Then

CType(dataItem("OrderStatusImage").Controls(0), Image).ImageUrl = "~/Images/OrderOpenTr.png"

ElseIf OrderStatusColumn = "6" Then

CType(dataItem("OrderStatusImage").Controls(0), Image).ImageUrl = "~/Images/OrderSuspendedTr.png"

End If

Dim HasCreditNoteColumn As String = dataItem("HasCreditNote").Text

If HasCreditNoteColumn = "1" Then

CType(dataItem("HasCreditNoteImage").Controls(0), Image).ImageUrl = "~/Images/CreditNoteDiscount.png"

ElseIf HasCreditNoteColumn = "2" Then

CType(dataItem("HasCreditNoteImage").Controls(0), Image).ImageUrl = "~/Images/CreditNoteCards.png"

Else

dataItem("HasCreditNoteImage").Controls(0).Visible = False

End If

Dim TotalChargeColumn As String = dataItem("Charge").Text

dataItem("Charge").Text = ConvertStringToDecimal(dataItem("Charge").Text, 2)

dataItem("TotalCharge").Text = ConvertStringToDecimal(dataItem("TotalCharge").Text, 2)

'dataItem("Price").Text = ConvertStringToDecimal(dataItem("Price").Text, 2)

dataItem("Charge").HorizontalAlign = HorizontalAlign.Right

dataItem("TotalCharge").HorizontalAlign = HorizontalAlign.Right

'dataItem("Price").HorizontalAlign = HorizontalAlign.Right

dataItem("Cards").HorizontalAlign = HorizontalAlign.Right

Charge += dataItem("TotalCharge").Text

Cards += dataItem("Cards").Text

'If INMBData <> " " Then

' INMBValue += CDec(INMBData)

'End If

'Dim fieldValue As Int32 = Integer.Parse(dataItem("ID").Text)

'TotalCharge = TotalCharge + TotalChargeField

End If

If (TypeOf e.Item Is GridFooterItem) Then

Dim footerItem As GridFooterItem = CType(e.Item, GridFooterItem)

footerItem("TotalCharge").Text = ConvertStringToDecimal(Charge.ToString, 2)

footerItem("TotalCharge").HorizontalAlign = HorizontalAlign.Right

footerItem("Cards").Text = ConvertStringToDecimal(Cards, 0)

footerItem("Cards").HorizontalAlign = HorizontalAlign.Right

'footerItem("INMB~Data (1.35$ / MIN)").Text = INMBValue.ToString()

footerItem("Vessel").Controls.Add(New LiteralControl("<span style='color: Black; font-weight: bold;'>Totals:</span> "))

End If

End Sub

Grid

answered on 29 Nov 2012

3 answers

109 views

Required field validation for GridEditorColumn

Hi guys

I am staring at this but cannot see anything wrong. But it does not trigger validation when there is no text entered in the editor on Update. What am I missing?

Thanks

Clive
PS Q2 2010 asp.net 4 . I am not using ajax manager on this page

<telerik:GridHTMLEditorColumn DataField="BodyText" HeaderText="BodyText" SortExpression="BodyText" UniqueName="BodyText" ColumnEditorID="MyColumnEditor1">

</telerik:GridHTMLEditorColumn>

Protected Sub RadGrid1_ItemCreated(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridItemEventArgs)

If (TypeOf e.Item Is GridEditableItem AndAlso e.Item.IsInEditMode) Then

Dim item As GridEditableItem = CType(e.Item, GridEditableItem)

Dim editor As GridTextBoxColumnEditor = CType(item.EditManager.GetColumnEditor("BodyText"), GridTextBoxColumnEditor)

Dim cell As TableCell = CType(editor.TextBoxControl.Parent, TableCell)

Dim validator As RequiredFieldValidator = New RequiredFieldValidator

editor.TextBoxControl.ID = "MyColumnEditor1"

validator.ControlToValidate = editor.TextBoxControl.ID

validator.ErrorMessage = "Please enter some text!"

cell.Controls.Add(validator)

End If

End Sub

Grid

answered on 29 Nov 2012

1 answer

79 views

Applying filter produces JavaScript error

I've got a bound column that may contain null values. If I try to use filtering on it such as "contains" or "equal", I'm getting a javascript error "Object reference not set to an instance of the object". I believe the generated logic should check for null before applying the "contains" filter. Am I doing something wrong here or is it a bug? In some posts I found that EnableLinqExpressions="false" would fix something like that. However, when I try to do that I'm getting

Server Error in '/' Application.

Cannot interpret token '?' at position 12

The grid is bound to a list of objects and is defined as follows

<telerik:RadGrid ID="EmployeesRadGrid" runat="server" AutoGenerateColumns="false"

AllowPaging="true" OnNeedDataSource="EmployeesRadGrid_NeedDataSource" EnableLinqExpressions="false"

oninit="EmployeesRadGrid_Init" onitemcommand="EmployeesRadGrid_ItemCommand">

<GroupingSettings CaseSensitive="False" />

<ExportSettings HideStructureColumns="true" FileName="Employees" Excel-Format="Biff"

OpenInNewWindow="false" Excel-FileExtension="xls" IgnorePaging="true" ExportOnlyData="false" />

<MasterTableView EditMode="PopUp" AllowFilteringByColumn="true" AllowSorting="true"

CommandItemDisplay="Top">

<CommandItemSettings ShowExportToExcelButton="true" ExportToExcelText="Export to Excel"

ShowAddNewRecordButton="false" />

<Columns>

<telerik:GridHyperLinkColumn DataNavigateUrlFields="PersonnelNo" UniqueName="Edit"

AllowFiltering="false" DataNavigateUrlFormatString="EditEmployee.aspx?PersonnelNo={0}"

Text="Edit" >

</telerik:GridHyperLinkColumn>

<telerik:GridCalculatedColumn HeaderTooltip="*= override" Expression="IsOverriden? Convert.ToChar(42): Convert.ToChar(32)"

AllowFiltering="false">

</telerik:GridCalculatedColumn>

<telerik:GridBoundColumn DataField="RacfID" HeaderText="RACF ID" CurrentFilterFunction="Contains"

FilterControlWidth="4em" AutoPostBackOnFilter="true" ShowFilterIcon="true" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="FullName" HeaderText="Name" CurrentFilterFunction="Contains"

AutoPostBackOnFilter="true" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="PositionName" HeaderText="Job Title" CurrentFilterFunction="Contains"

FilterControlToolTip="Enter search value and press Tab or Enter" FilterControlWidth="9em"

AutoPostBackOnFilter="true" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="PersonnelAreaDescription" HeaderText="Work Location"

CurrentFilterFunction="Contains" FilterControlWidth="11em" AutoPostBackOnFilter="true"

ShowFilterIcon="false">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="OrgUnit" HeaderText="Org Unit" CurrentFilterFunction="Contains"

FilterControlWidth="6em" AutoPostBackOnFilter="true">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="BusinessSalesUnit" HeaderText="Sls-Bus Unit" FilterDelay="10000"

FilterControlWidth="4em" AutoPostBackOnFilter="true" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="DeptRegion" HeaderText="Dept-Region" CurrentFilterFunction="Contains"

FilterControlWidth="4em" AutoPostBackOnFilter="true" >

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="CostCenterDisplay" HeaderText="Cost center" CurrentFilterFunction="Contains"

FilterControlWidth="4em" AutoPostBackOnFilter="true" >

</telerik:GridBoundColumn>

</Columns>

</MasterTableView>

</telerik:RadGrid>

Thanks,
Alex

Grid

answered on 29 Nov 2012

4 answers

105 views

Grid in inline edit mode

Hi,

i am using the grid and have written a function that allow me to set all the viable rows to be edited using the inline edit method.

the grid is initially populated with 1000 rows by being bound to a data table, the grid has paging set at 25 lines per page and the user can edit all 25 items in one go, when they click update my code loops through the viable items and adds them to a new data table and this is returned to an update function.

the data table that is sent back only contain 25 rows but seems to be over a meg in size and this really kill the performance of the page when using it over a Normal ADSL connection.

can anyone tell me why the data table is so big as the data contained with in it should be a few K and i do not seem to have the same issue when the data is retrieved on load of the page.

Grid

answered on 29 Nov 2012

3 answers

268 views

EnableEmbeddedBaseStylesheet Odd Behavior

I have a RadMenu instance defined on a master page like this:

<telerik:RadMenu runat="server" ID="rdMenu" Skin="CustomSkin" EnableEmbeddedBaseStylesheet="false" EnableEmbeddedSkins="false" DataSourceID="menu" />

For the main page of the site (not in a subfolder), this works exactly as expected - I have a CSS file that is linked to the page which contains both a modified version of the base stylesheet plus the contents of my custom skin's CSS. The problem I'm having is any page on a subfolder seems to be having the EnableEmbeddedBaseStylesheet property ignored so I get a reference to WebResource.axd for the base which throws off all of my CSS.

Any guesses as to what would cause this property to be selectively applied when it should always be in effect? I'm on version 2012.3.1016.45.

Menu

answered on 29 Nov 2012

3 answers

78 views

Masterpage - Splitter - AjaxUpdate

Hi,
i need a Splitter in my Masterpage with Ajaxupdate my Contentpages.
I want Leftpane with treeview bind to web.sitemap and Rightpane with ContentPlaceholder updated ajaxified every time i select a node in treeview.
I can not get it to work. Everytime i click on treeview node the hole Masterpage is refreshing (flickering)
Any Ideas. If i place GridView in Leftpane Buttom or in contentpages the page flickers.
Thanks

Ajax

answered on 29 Nov 2012

3 answers

190 views

Using ellipsis with items

I am using a RadPanelBar for a navigation menu and this will eventually be used within a frameset which can have the frame width dynamically altered.

I am using a text-overflow:ellipsis css style on the text and that works fine in keeping the text together and not wrapping midword, however the problem is that as the width of my radpanel gets smaller the text in its entirety will wrap to the next line seperating from the icons(which I have placed at the left of each radpanelitem). As far as I know I cannot use the css white-space:nowrap as that only applies to the text itself. Is there any other way to make it so the radpanelitem as a whole does not wrap?

Jan

PanelBar

answered on 29 Nov 2012

1 answer

216 views

Passing parameter to telerik grid selectmethod

HI,

I added a telerik radgrid in my aspx page. I specifed the SelectedMethod and the Typename, which is a business class other than the web UI class. I got the UI working but I need to pass a parameter from the web ui class to the business class. the aspx will get the parameter from the url and store it in a string. When the telerik invokes the SelectMethod, which is in another business class, what is the best practive method to pass the parameter to the SelectMethod, which gets invoke automatically?

Grid

answered on 29 Nov 2012

11 answers

339 views

[Solved] Cannot find a control in a radGrid FilterTemplate via Javascript

I'm performing a Custom Filter on a RadGrid. The filter works when my Button is pressed, I'd like to now have the button's code behind fire when the User types into the Search Textbox.

I am able to find the Grid using Javascript, but the $find to the 'btnFilter' always fails. As you can see below, I've tried multiple ways.

function doFilter(sender, e) {

if (e.keyCode == 13) {

var masterTable = $find("<%=AgreementsGrid.ClientID%>").get_masterTableView();

//var btn = masterTable.get_dataItems()[0].findControl('btnFilter');

var btn = $find("ctl00$MainContentPlaceHolder$AgreementsGrid$ctl00$ctl02$ctl01$btnFilter");

if (btn != null) {

e.cancelBubble = true;

e.returnValue = false;

if (e.preventDefault) {

e.preventDefault();

}

alert("yes!");

//btn.click();

} else {

alert("no!");

}

<telerik:RadGrid ID="AgreementsGrid" runat="server" CellSpacing="0" GridLines="None" EnableLinqExpressions="false"

AllowFilteringByColumn="true" AllowPaging="false" AllowSorting="True" EnableViewState="true"

AutoGenerateColumns="False" Height="240">

<MasterTableView DataKeyNames="AgreementID" TableLayout="Auto">

<Columns>

<telerik:GridBoundColumn DataField="AgreementName"

FilterControlAltText="Filter AgreementName column" HeaderText="Agreement" HeaderStyle-Width="350" FilterControlWidth="350"

SortExpression="AgreementName" UniqueName="AgreementName" >

<FilterTemplate>

<telerik:RadTextBox ID="AgreementName" runat="server" EmptyMessageStyle-Font-Italic="true" onkeydown="doFilter(this,event)"

HoveredStyle-Font-Italic="true" Width="90%">

</telerik:RadTextBox>

<asp:Button ID="btnFilter" runat="server" Width="20px" Text="" OnClick="FilterTextbox_Changed" CommandName="btnSearch" />

</FilterTemplate>

</telerik:GridBoundColumn>

</Columns>

<FilterItemStyle Width="10px" />

</MasterTableView>

<FilterMenu EnableImageSprites="False"></FilterMenu>

</telerik:RadGrid>

Grid

answered on 29 Nov 2012

1 answer

247 views

RadEditor SkinID

Hi,

RadEditor's SkinID property seems to be ignored when an Editor is placed in an RadGris Edit Template like:

<telerik:GridTemplateColumn UniqueName="tekst">
                    <EditItemTemplate>
                        <telerik:RadEditor SkinID="Editor" ID="RadEditor1" runat="server" content='<%# Bind("tekst") %>' />
                    </EditItemTemplate>
</telerik:GridTemplateColumn>

Any suggestions?

Marc

Editor

answered on 29 Nov 2012