Questions on UI for ASP.NET AJAX Forum

2 answers

109 views

ExportToPdf wide grid overflows out of paper

Hello, I have a wide RadGrid (> 16 cols) that I am trying to export to PDF. When I export to PDF, the grid overflows out of the PDF width. Is there a way to make it use more than 1 page for the width of the table (e.g. 3 pages wide by N pages long)? I want to get something similar to what I get with the RadReport (in another page I am using the RadReport control and it renders the report 3p wide by N pages long). Included is the body of the RadGrid and the code-behind in which I format it. The RadGrid is ajaxified. Thanks for any help you can provide.

Private Sub PDFButton_Click(sender As Object, e As System.EventArgs) Handles PDFButton.Click

_isExport = True

For Each column As Telerik.Web.UI.GridColumn In ReportGrid.MasterTableView.Columns

If column.UniqueName = "SelectCheckbox" Or column.UniqueName = "ViewButton" Then

column.Visible = False

EndIf

Next

ReportGrid.Width = New Unit(22)

ReportGrid.MasterTableView.ExportToPdf()

End Sub

Private Sub ReportGrid_ItemCreated(sender As Object, e As Telerik.Web.UI.GridItemEventArgs) Handles ReportGrid.ItemCreated

If _isExport Then

If TypeOf (e.Item) Is GridHeaderItem Then

Dim headerItem As GridHeaderItem = e.Item

headerItem.Style("font-size") = "8pt"

headerItem.Style("color") = "white"

headerItem.Style("background-color") = "gray"

headerItem.Style("vertical-align") = "bottom"

For Each cell As TableCell In headerItem.Cells

cell.Style("text-align") = "left"

cell.Style("font-weight") = "bold"

cell.Style("border-color") = "red"

Next

ElseIf TypeOf (e.Item) Is GridDataItem Then

Dim bodyItem As GridDataItem = e.Item

bodyItem.Style("font-size") = "8pt"

bodyItem.Style("vertical-align") = "bottom"

For Each cell As TableCell In bodyItem.Cells

cell.Style("text-align") = "left"

Next

End If

End Sub

<telerik:RadGrid ID="ReportGrid" runat="server" Height="99%" AllowPaging="True" GridLines="None" PageSize="50" AllowSorting="True" AllowFilteringByColumn="false" AllowMultiRowSelection="true" AutoGenerateColumns="false">

<ClientSettings AllowColumnsReorder="true">

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

<Selecting AllowRowSelect="true" />

<Resizing AllowColumnResize="true" AllowResizeToFit="false" ClipCellContentOnResize="true" ResizeGridOnColumnResize="true" EnableRealTimeResize="false" />

<ClientEvents OnRowDeselected="ReportGrid_OnRowDeselected" OnRowSelected="ReportGrid_OnRowSelected" />

</ClientSettings>

<MasterTableView>

<Columns>

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

<telerik:GridButtonColumn DataTextField="FullFileName" CommandName="View" ButtonType="ImageButton" UniqueName="ViewButton" ImageUrl="/Images/preview.png" HeaderStyle-Width="30" />

<telerik:GridBoundColumn DataField="DocArchiveSysKey" DataType="System.String" HeaderText="DocArchiveSysKey" SortExpression="DocArchiveSysKey" UniqueName="DocArchiveSysKey" />

<telerik:GridBoundColumn DataField="Division" DataType="System.String" HeaderText="Division" SortExpression="Division" UniqueName="Division" />

<telerik:GridBoundColumn DataField="Route" DataType="System.String" HeaderText="Route" SortExpression="Route" UniqueName="Route" />

<telerik:GridBoundColumn DataField="Outlet" DataType="System.String" HeaderText="Outlet" SortExpression="Outlet" UniqueName="Outlet" />

<telerik:GridBoundColumn DataField="OutletName" DataType="System.String" HeaderText="OutletName" SortExpression="OutletName" UniqueName="OutletName" />

<telerik:GridBoundColumn DataField="DocType" DataType="System.String" HeaderText="DocType" SortExpression="DocType" UniqueName="DocType" />

<telerik:GridBoundColumn DataField="DisplayDocType" DataType="System.String" HeaderText="DisplayDocType" SortExpression="DisplayDocType" UniqueName="DisplayDocType" />

<telerik:GridBoundColumn DataField="DocID" DataType="System.String" HeaderText="DocID" SortExpression="DocID" UniqueName="DocID" />

<telerik:GridBoundColumn DataField="DisplayDocDate" DataType="System.String" HeaderText="DisplayDocDate Date" SortExpression="DisplayDocDate" UniqueName="DisplayDocDate" />

<telerik:GridBoundColumn DataField="FileName" DataType="System.String" HeaderText="FileName" SortExpression="FileName" UniqueName="FileName" />

<telerik:GridBoundColumn DataField="FullFileName" DataType="System.String" HeaderText="FullFileName" SortExpression="FullFileName" UniqueName="FullFileName" />

<telerik:GridBoundColumn DataField="DisplaySettlementDate" DataType="System.DateTime" HeaderText="DisplaySettlementDate" SortExpression="DisplaySettlementDate" UniqueName="DisplaySettlementDate" />

<telerik:GridBoundColumn DataField="RC2Code" DataType="System.String" HeaderText="RC2Code" SortExpression="RC2Code" UniqueName="RC2Code" />

<telerik:GridBoundColumn DataField="RC3Code" DataType="System.String" HeaderText="RC3Code" SortExpression="RC3Code" UniqueName="RC3Code" />

<telerik:GridBoundColumn DataField="RC4Code" DataType="System.String" HeaderText="RC4Code" SortExpression="RC4Code" UniqueName="RC4Code" />

<telerik:GridBoundColumn DataField="RC5Code" DataType="System.String" HeaderText="RC5Code" SortExpression="RC5Code" UniqueName="RC5Code" />

<telerik:GridBoundColumn DataField="EA1Code" DataType="System.String" HeaderText="EA1Code" SortExpression="EA1Code" UniqueName="EA1Code" />

<telerik:GridBoundColumn DataField="EA2Code" DataType="System.String" HeaderText="EA2Code" SortExpression="EA2Code" UniqueName="EA2Code" />

<telerik:GridBoundColumn DataField="EA3Code" DataType="System.String" HeaderText="EA3Code" SortExpression="EA3Code" UniqueName="EA3Code" />

<telerik:GridBoundColumn DataField="EA4Code" DataType="System.String" HeaderText="EA4Code" SortExpression="EA4Code" UniqueName="EA4Code" />

<telerik:GridBoundColumn DataField="EA5Code" DataType="System.String" HeaderText="EA5Code" SortExpression="EA5Code" UniqueName="EA5Code" />

<telerik:GridBoundColumn DataField="EA6Code" DataType="System.String" HeaderText="EA6Code" SortExpression="EA6Code" UniqueName="EA6Code" />

<telerik:GridBoundColumn DataField="EA7Code" DataType="System.String" HeaderText="EA7Code" SortExpression="EA7Code" UniqueName="EA7Code" />

<telerik:GridBoundColumn DataField="EA8Code" DataType="System.String" HeaderText="EA8Code" SortExpression="EA8Code" UniqueName="EA8Code" />

<telerik:GridBoundColumn DataField="EA9Code" DataType="System.String" HeaderText="EA9Code" SortExpression="EA9Code" UniqueName="EA9Code" />

<telerik:GridBoundColumn DataField="EA10Code" DataType="System.String" HeaderText="EA10Code" SortExpression="EA10Code" UniqueName="EA10Code" />

</Columns>

</MasterTableView>

<ExportSettings HideStructureColumns="true" ExportOnlyData="true" IgnorePaging="true" OpenInNewWindow="true">

<Pdf PageWidth="11in" PageHeight="8.5in" PageLeftMargin=".5in" PageRightMargin=".5in" PageTopMargin=".5in" PageBottomMargin=".5in" AllowCopy="true" AllowModify="true" AllowPrinting="true" />

</ExportSettings>

</telerik:RadGrid>

Grid

answered on 26 May 2011

1 answer

75 views

Grid delete button on Mozilla 4.x

Hello. I have a simple page containing a text box and a rad grid. I have attached a delete button on the grid row has a confirm text displayed on click of the btn.

The problem I am having is: If I have the cursor on the text box and I hit enter, its invoking the rad grid delete event, strating with delete confirm prompt. I do not want this to happen. I need to hook the enter key to some other events. And this is happening only on Mozilla. rest of the browsers do not invoke the delete event.

Any clues/fixes for this behaviour. Appreciate your help. thanks

code below:

<asp:textbox id="txtMLSNumber" runat="server" Width="110px"></asp:textbox>

<telerik:RadGrid ID="grdPartials" DataSourceID ="ObjectDataSource1" CssClass="RemoveBorders"

Skin="Outlook" runat="server" GridLines="None" AutoGenerateColumns="False"

Width="690px" height="196px">

<AlternatingItemStyle BackColor="#DDECFE" />

<MasterTableView datasourceid="ObjectDataSource1" GridLines=none AllowAutomaticDeletes="true" EnableNoRecordsTemplate=true DataKeyNames ="PartialId,PropType" >

<CommandItemSettings ExportToPdfText="Export to Pdf"></CommandItemSettings>

<RowIndicatorColumn>

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

</RowIndicatorColumn>

<ExpandCollapseColumn>

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

</ExpandCollapseColumn>

<Columns>

<telerik:GridHyperLinkColumn HeaderText = "" ItemStyle-HorizontalAlign="Left" Text ="Edit"

UniqueName="lnkEdit" HeaderStyle-Font-Bold="false" HeaderStyle-Wrap="false"

HeaderStyle-Width="40px">

</telerik:GridHyperLinkColumn>

<telerik:GridBoundColumn DataField="PartialId" Visible =true HeaderText="Partial Id" ItemStyle-Width="100px" HeaderStyle-Width="100px" ItemStyle-Wrap=false HeaderStyle-Wrap="false"

MaxLength="0" UniqueName="PartialId">

<HeaderStyle Wrap="False"></HeaderStyle>

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="StreetNumber" HeaderText="Street Number" ItemStyle-Width="100px" HeaderStyle-Width="100px" ItemStyle-Wrap=false HeaderStyle-Wrap="false"

UniqueName="StreetNumber">

<HeaderStyle Wrap="False"></HeaderStyle>

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="StreetName" HeaderText="Street Name" ItemStyle-Width="100px" HeaderStyle-Width="100px" ItemStyle-Wrap=false HeaderStyle-Wrap="false"

UniqueName="StreetName">

<HeaderStyle Wrap="False"></HeaderStyle>

<ItemStyle Wrap="False"></ItemStyle>

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="City" HeaderText="City" UniqueName="City" DataFormatString="{0}" ItemStyle-Width="100px" HeaderStyle-Width="100px" ItemStyle-Wrap=false HeaderStyle-Wrap="false">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="PropType" HeaderText="Prop Type" ItemStyle-Width="100px" HeaderStyle-Width="100px" ItemStyle-Wrap=false HeaderStyle-Wrap="false"

UniqueName="PropType">

<HeaderStyle Wrap="False"></HeaderStyle>

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="CreateDate" HeaderText="Create Date" DataFormatString="{0:MM/dd/yyyy}" ItemStyle-Width="100px" HeaderStyle-Width="100px" ItemStyle-Wrap=false HeaderStyle-Wrap="false"

UniqueName="CreateDate">

</telerik:GridBoundColumn>

<telerik:GridButtonColumn ConfirmText="Delete this record?" ConfirmDialogType="RadWindow"

ConfirmTitle="Delete" ButtonType="ImageButton" CommandName="Delete" Text="Delete"

UniqueName="DeleteColumn">

<ItemStyle HorizontalAlign="Center" CssClass="MyImageButton" />

</telerik:GridButtonColumn>

</Columns>

<NoRecordsTemplate>

<div style="text-align:center;padding-top:70px;font-size:medium">No Partial Listings Found!!!</div>

<br />

</NoRecordsTemplate>

</MasterTableView>

<SelectedItemStyle />

<HeaderStyle BackColor="#D6E7FC" />

<ClientSettings Scrolling-ScrollHeight =200>

<Selecting AllowRowSelect="True" />

<Scrolling AllowScroll =true UseStaticHeaders =true />

<Resizing AllowColumnResize="True" AllowRowResize="false" />

</ClientSettings>

<ActiveItemStyle BackColor="#CC0099" />

</telerik:RadGrid>

<asp:ObjectDataSource

ID="ObjectDataSource1"

runat="server"

SelectMethod="GetPartials"

TypeName = "Partials"

DeleteMethod ="DeletePartials"

>

<DeleteParameters>

<asp:Parameter Name="PartialId" Type ="String" />

<asp:Parameter Name="PropType" Type ="String" />

</DeleteParameters>

</asp:ObjectDataSource>

Grid

answered on 26 May 2011

1 answer

80 views

Wrong dates when expanding weekly recurrence using 'ExpandRecurrence_UDF.zip'

Hi,

When expanding weekly recurrence rule wiAth interval =2 it is showing wrong dates between the range.
i am not finding any reply from blogs. it is not problem with cofiguration of 'ExpandRecurrece_UDF' , because all the other events like
day,weekly,monthly,yearly are working fine. only problem with weelky recurrence with interval = 2 and weekly day 'SAT,SUN' not working

can u check this issue. please check below rule and expand the rule you know the problem.

DTSTART:20110505T063000Z DTEND:20110505T073000Z RRULE:FREQ=WEEKLY;COUNT=6;INTERVAL=2;BYDAY=FR,SA,SU

Regards
Shashi...

Scheduler

answered on 26 May 2011

3 answers

136 views

Bi-Weekly recurrence not working correctly using ExpandRecurrence function

Hi,

While using below weekly recurrence rule not getting exact dates.
DTSTART:20110505T063000Z DTEND:20110505T073000Z RRULE:FREQ=WEEKLY;COUNT=6;INTERVAL=2;BYDAY=FR,SA,SU
Bi-Weekly recurrence not working correctly using ' ExpandRecurrence ' function . can u help in this

It is giving below output :

5/6/2011 (Friday )
5/7/2011 (Saturday)
5/15/2011 (Sunday)

5/20/2011 ( Friday )
5/21/2011 ( Saturday)
5/29/2011 ( Sunday )

Thanks & Regards
Shashi...

Scheduler

answered on 26 May 2011

2 answers

88 views

Programmatic Creation of RadGrid with Export to excel/pdf

Hi,

I am trying to create a Radgrid from the codebehind at runtime. The grid works fine with paging, but the problem is i need to have the export functionality I tried the following code along with the grid creation even then the grid header is not displayed.

RadGrid1.MasterTableView.CommandItemSettings.ShowExportToPdfButton = true;
RadGrid1.MasterTableView.CommandItemSettings.ShowExportToExcelButton = true;
RadGrid1.MasterTableView.CommandItemSettings.ShowRefreshButton = true;
RadGrid1.ExportSettings.HideStructureColumns = true;
RadGrid1.ExportSettings.ExportOnlyData = true;
RadGrid1.ExportSettings.IgnorePaging = true;
RadGrid1.ExportSettings.OpenInNewWindow = true;

Am i missing something?

Thanks in advance.

Grid

answered on 26 May 2011

2 answers

788 views

Change Radcombobox datasource by using another comobobox's selected value

Hi,

i have a RadGrid with templated columns. I have a ReportLevel RadCombobox & a CostCentreLow RadComboBox in the edit template.
The CostCentreLow Radcombobox is populated from a SqlDatasource but what i want to do is base the sqldatasource select command on the value selected in the ReportLevel combobox & then rebind datasource to the CostCentreLow combobox. I need this to work on the reportlevel selectedIndexChanged.
I have tried the RadGrid ItemCreated method but i get a databind error when i try to change the SqlDataSource select command in the ReportLevel SelectedIndexChanged event & it doesn't work if i try to bind the datasource in the Radgrid ItemCreated event (as i need the datasource changed based on the value in the ReportLevel ComboBox).

here is the code for my project:

<telerik:RadGrid ID="RadGrid1" GridLines="None" runat="server" AllowAutomaticDeletes="True"

AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AllowPaging="True"

AutoGenerateColumns="False" DataSourceID="SqlDataSource1" Skin="Web20"

Width="99%" AllowFilteringByColumn="True" OnItemUpdated="RadGrid1_ItemUpdated"

OnItemDeleted="RadGrid1_ItemDeleted" OnItemInserted="RadGrid1_ItemInserted"

OnDataBound="RadGrid1_DataBound" OnItemDataBound="RadGrid1_ItemDataBound" OnItemCreated="RadGrid1_ItemCreated"

onitemcommand="RadGrid1_ItemCommand" AllowSorting="True" Culture="en-GB"

CssClass="Grid" Font-Size="X-Small" Font-Names="verdana"

PageSize="15" >

<PagerStyle Mode="NextPrevAndNumeric" />

<AlternatingItemStyle BackColor="#E8F1FF" />

<MasterTableView CommandItemDisplay="TopAndBottom" DataKeyNames="U_ID"

DataSourceID="SqlDataSource1" HorizontalAlign="NotSet" AutoGenerateColumns="False">

<CommandItemSettings ExportToPdfText="Export to Pdf"></CommandItemSettings>

<RowIndicatorColumn FilterControlAltText="Filter RowIndicator column"></RowIndicatorColumn>

<ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column"></ExpandCollapseColumn>

<Columns>

<telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumn">

<ItemStyle CssClass="MyImageButton" Width="20px" />

</telerik:GridEditCommandColumn>

<telerik:GridTemplateColumn HeaderText="ID" SortExpression="U_ID" UniqueName="U_ID" AllowFiltering="true"

EditFormColumnIndex="0" FilterControlWidth="50%" DataField="U_ID" >

<ItemTemplate>

<asp:Label runat="server" CssClass="Label2" Width="30px" ID="U_ID" Text='<%# Eval("U_ID") %>'></asp:Label>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="UserName" SortExpression="UserName" UniqueName="UserName" AllowFiltering="true"

EditFormColumnIndex="0" FilterControlWidth="70%" DataField="UserName" >

<EditItemTemplate>

<span style="font-size:13px;color:Red;">

<telerik:RadTextBox runat="server" Width="200px" Text='<%# Bind("UserName") %>' ID="UserName" Visible="true" MaxLength="12" >

</telerik:RadTextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator9" ControlToValidate="UserName"

ErrorMessage="*" runat="server">

</asp:RequiredFieldValidator>

</EditItemTemplate>

<InsertItemTemplate>

<span style="font-size:13px;color:Red;">

<telerik:RadTextBox runat="server" Width="200px" Text='<%# Bind("UserName") %>' ID="UserName" Visible="true" MaxLength="12" >

</telerik:RadTextBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator10" ControlToValidate="UserName"

ErrorMessage="*" runat="server">

</asp:RequiredFieldValidator>

</InsertItemTemplate>

<ItemTemplate>

<asp:Label runat="server" CssClass="Label2" Width="80px" ID="UserName" Text='<%# Eval("UserName") %>'></asp:Label>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="Report Level" SortExpression="ReportLevel" UniqueName="ReportLevel" AllowFiltering="true"

EditFormColumnIndex="0" FilterControlWidth="70%" DataField="ReportLevel" >

<EditItemTemplate>

<span style="font-size:13px; color:Red;">

<telerik:RadComboBox runat="server" Width="205px" Height="100px"

EmptyMessage="Select a value"

HeaderText="ReportLevel" SelectedValue='<%# Bind("ReportLevel") %>'

UniqueName="ReportLevel" ID="ReportLevel" >

<Items>

<telerik:RadComboBoxItem Value="" Text="" />

<telerik:RadComboBoxItem Value="CC" Text="CC" />

<telerik:RadComboBoxItem Value="DIR" Text="DIR" />

</Items>

</telerik:RadComboBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator5" ControlToValidate="ReportLevel"

ErrorMessage="*" runat="server">

</asp:RequiredFieldValidator>

</EditItemTemplate>

<InsertItemTemplate>

<span style="font-size:13px; color:Red;">

<telerik:RadComboBox runat="server" Width="205px" Height="100px"

EmptyMessage="Select a value"

HeaderText="ReportLevel" SelectedValue='<%# Bind("ReportLevel") %>'

UniqueName="ReportLevel" ID="ReportLevel" >

<Items>

<telerik:RadComboBoxItem Value="" Text="" />

<telerik:RadComboBoxItem Value="CC" Text="CC" />

<telerik:RadComboBoxItem Value="DIR" Text="DIR" />

</Items>

</telerik:RadComboBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator6" ControlToValidate="ReportLevel"

ErrorMessage="*" runat="server">

</asp:RequiredFieldValidator>

</InsertItemTemplate>

<ItemTemplate>

<asp:Label runat="server" CssClass="Label2" Width="80px" ID="lblReportLevel" Text='<%# Eval("ReportLevel") %>'></asp:Label>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="Cost Centre Low" SortExpression="CostCentreLow" UniqueName="CostCentreLow" AllowFiltering="true"

EditFormColumnIndex="0" FilterControlWidth="70%" DataField="CostCentreLow" >

<EditItemTemplate>

<span style="font-size:13px; color:Red;" runat="server" >

<telerik:RadComboBox ID="CostCentreLow" runat="server" Enabled="false"

DataSourceID="DS_CostCentre" DataTextField="costcentre"

DataValueField="costcentre" DropDownWidth="200px"

SelectedValue='<%# Bind("CostCentreLow") %>'  Width="205px" TabIndex="8" Font-Size="X-Small" Font-Names="Verdana" AppendDataBoundItems="True" >

</telerik:RadComboBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator1" ControlToValidate="CostCentreLow"

ErrorMessage="*" runat="server">

</asp:RequiredFieldValidator>

</EditItemTemplate>

<InsertItemTemplate>

<span style="font-size:13px; color:Red;">

<telerik:RadComboBox ID="CostCentreLow" runat="server"

DataSourceID="DS_CostCentre" DataTextField="costcentre"

DataValueField="costcentre" DropDownWidth="200px"

SelectedValue='<%# Bind("CostCentreLow") %>'  Width="205px" TabIndex="8" Font-Size="X-Small" Font-Names="Verdana" AppendDataBoundItems="True" >

</telerik:RadComboBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator2" ControlToValidate="CostCentreLow"

ErrorMessage="*" runat="server">

</asp:RequiredFieldValidator>

</InsertItemTemplate>

<ItemTemplate>

<asp:Label runat="server" CssClass="Label2" Width="80px" ID="CostCentreLow" Text='<%# Eval("CostCentreLow") %>'></asp:Label>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn HeaderText="Cost Centre High" SortExpression="CostCentreHigh" UniqueName="CostCentreHigh" AllowFiltering="true"

EditFormColumnIndex="0" FilterControlWidth="70%" DataField="CostCentreHigh" >

<EditItemTemplate>

<span style="font-size:13px; color:Red;">

<telerik:RadComboBox ID="CostCentreHigh" runat="server" Enabled="false"

DataSourceID="DS_CostCentre" DataTextField="costcentre"

DataValueField="costcentre" DropDownWidth="200px"

SelectedValue='<%# Bind("CostCentreHigh") %>'  Width="205px" TabIndex="8" Font-Size="X-Small" Font-Names="Verdana" AppendDataBoundItems="True" >

</telerik:RadComboBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator3" ControlToValidate="CostCentreHigh"

ErrorMessage="*" runat="server">

</asp:RequiredFieldValidator>

</EditItemTemplate>

<InsertItemTemplate>

<span style="font-size:13px; color:Red;">

<telerik:RadComboBox ID="CostCentreHigh" runat="server"

DataSourceID="DS_CostCentre" DataTextField="costcentre"

DataValueField="costcentre" DropDownWidth="200px"

SelectedValue='<%# Bind("CostCentreHigh") %>'  Width="205px" TabIndex="8" Font-Size="X-Small" Font-Names="Verdana" AppendDataBoundItems="True" >

</telerik:RadComboBox>

<asp:RequiredFieldValidator ID="RequiredFieldValidator4" ControlToValidate="CostCentreHigh"

ErrorMessage="*" runat="server">

</asp:RequiredFieldValidator>

</InsertItemTemplate>

<ItemTemplate>

<asp:Label runat="server" CssClass="Label2" Width="80px" ID="CostCentreHigh" Text='<%# Eval("CostCentreHigh") %>'></asp:Label>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridButtonColumn ConfirmText="Delete this record?" ConfirmDialogType="RadWindow"

ConfirmTitle="Delete" ButtonType="ImageButton" CommandName="Delete" Text="Delete"

UniqueName="DeleteColumn">

<ItemStyle HorizontalAlign="Center" CssClass="MyImageButton" />

</telerik:GridButtonColumn>

</Columns>

<EditFormSettings ColumnNumber="2" CaptionDataField="U_ID" CaptionFormatString="Edit properties of Record {0}" InsertCaption="New Record">

<FormTableItemStyle Wrap="False"></FormTableItemStyle>

<FormTableStyle CellPadding="2" CellSpacing="0" BackColor="#F2FFEC" Height="60px"></FormTableStyle>

<FormMainTableStyle CellPadding="3" CellSpacing="0" BackColor="#F2FFEC" Width="100%"></FormMainTableStyle>

<FormCaptionStyle CssClass="EditFormHeader"></FormCaptionStyle>

<FormMainTableStyle GridLines="None" CellSpacing="0" CellPadding="3" BackColor="#F2FFEC" Width="100%" />

<FormTableStyle CellSpacing="0" CellPadding="2" Height="60px" BackColor="#F2FFEC" />

<FormTableAlternatingItemStyle Wrap="False"></FormTableAlternatingItemStyle>

<EditColumn ButtonType="ImageButton" InsertText="Insert Record" UpdateText="Update Record"

UniqueName="EditCommandColumn1" CancelText="Cancel edit">

</EditColumn>

<FormTableButtonRowStyle HorizontalAlign="Right" CssClass="EditFormButtonRow"></FormTableButtonRowStyle>

</EditFormSettings>

</MasterTableView>

<ClientSettings>

<Selecting AllowRowSelect="True" />

<ClientEvents OnRowDblClick="RowDblClick" />

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

<ClientEvents OnRowDblClick="RowDblClick"></ClientEvents>

</ClientSettings>

<EditItemStyle BackColor="#F2FFEC" />

<ActiveItemStyle BackColor="#FFF8D9" BorderColor="#FFF8D9" BorderStyle="Solid"

BorderWidth="1px" />

<ActiveItemStyle BackColor="#FFF8D9" BorderColor="#FFF8D9" BorderWidth="1px"

BorderStyle="Solid"></ActiveItemStyle>

<SelectedItemStyle BackColor="#FFF8D9" BorderColor="#FFF8D9"

BorderStyle="Solid" BorderWidth="1px" />

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

<HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Web20"></HeaderContextMenu>

</telerik:RadGrid>

protected void RadGrid1_ItemCreated(object sender, GridItemEventArgs e)

{

if (e.Item is GridEditableItem && e.Item.IsInEditMode)

{

//the dropdown list will be the first control in the Controls collection of the corresponding cell

RadComboBox list = (e.Item as GridEditableItem)["ReportLevel"].Controls[1] as RadComboBox;

//attach SelectedIndexChanged event for the drodown control this.combo_SelectedIndexChanged

list.AutoPostBack = true;

//list.SelectedIndexChanged += new RadComboBoxSelectedIndexChangedEventHandler(this.list_SelectedIndexChanged);

list.SelectedIndexChanged += new RadComboBoxSelectedIndexChangedEventHandler(list_SelectedIndexChanged);

}

void list_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e)

{

//first reference the edited grid item through the NamingContainer attribute

GridEditableItem editedItem = (sender as RadComboBox).NamingContainer as GridEditableItem;

//the dropdown list will be the first control in the Controls collection of the corresponding cell

//for custom edit forms (WebUserControl/FormTemplate) you can find the column editor with the FindControl(controlId) method

RadComboBox ddRepLev = editedItem["ReportLevel"].Controls[1] as RadComboBox;

RadComboBox ddCostCen = editedItem["CostCentreLow"].Controls[1] as RadComboBox;

if (ddRepLev.SelectedValue == "CC")

{

this.DS_CostCentre.SelectCommand =

"SELECT '' AS costcentre UNION SELECT DISTINCT SEGMENT_CODE AS costcentre FROM ORACLE_DS_GL_CoA_Segments WHERE (SEGMENT_NUMBER = 2) "

; //AND (EFFECTIVE_STATUS = 'Active')

this.DS_CostCentre.DataBind();

}

else

{

this.DS_CostCentre.SelectCommand =

"SELECT '' AS costcentre UNION SELECT DISTINCT PARENT_CODE_L2 AS costcentre FROM ORACLE_DS_GL_CoA_Segments WHERE (SEGMENT_NUMBER = 2)  "

; //AND (EFFECTIVE_STATUS = 'Active')

this.DS_CostCentre.DataBind();

}

//ddCostCen.DataSourceID = "DS_CostCentre";

ddCostCen.Enabled = true;

}

As mentioned, because i need the datasource changed based on the reportlevel value selected, i need the datasource selectcommand being assigned a new value in the ReportLevel SelectedIndexChanged event but this gives me a databind error.

Can you please help me find a solution to this problem?

Regards,

Shuja

ComboBox

answered on 26 May 2011

1 answer

69 views

Problem with emphasis

I have an radmaskedtextbox in my page and i want only character from a to z and A to Z without é, è, etc.

How I can do this ?

Input

answered on 26 May 2011

5 answers

180 views

TreeView in RadComboBox Drop Down Height

Hello,

I am trying to use the treeview in the RadComboBox: http://demos.telerik.com/aspnet-ajax/treeview/examples/functionality/treeviewcombobox/defaultcs.aspx?product=combobox

When the user expands a combo item, I need the RadComboBox drop down to expand too. Seems easy enough to do, but I have a CSS style applied that I would like for it to meet. It doesn't seem to apply the style initially (maybe because its a custom item template) and so how can I handle?

If the style class doesn't work, then I'm thinking tap into the NodeExpanded event on the TreeView, and adjust the size of the drop down. Is there a method that says "reevaluate the combo's contents and allow more room"?

Thanks.

ComboBox

answered on 26 May 2011

1 answer

61 views

Programmatic Creation of RadGrid: Form control values

Hi,
My objective is to create a radgrid based on some parameters.
I am creating the radgrid on page init().
Now the problem for me is to access the values of the controls(say a value of radio button) on the page after a button click in the page_init().

Please help me in this regard.

Thanks in advance.

Regards,
Vijay

Grid

answered on 26 May 2011

1 answer

162 views

How to apply aggregate functions on ChartSeries values?

Hi,

I need to apply generic aggregate functions like sum, min, max or average on ChartSeries.

The Chart data binding is done by assign series, columns and datasource:

Dim vChartSeries = New ChartSeries("Series 1"

, ChartSeriesType.Bar)

vChartSeries.YAxisType = ChartYAxisType.Primary

Dim vChartSeries2 = New ChartSeries("Series 2"

, ChartSeriesType.Bar)

vChartSeries2.YAxisType = ChartYAxisType.Secondary

RadChart2.AddChartSeries(vChartSeries)

RadChart2.AddChartSeries(vChartSeries2)

RadChart2.PlotArea.XAxis.AxisLabel.TextBlock.Text =

"AAA"

RadChart2.PlotArea.YAxis.AxisLabel.TextBlock.Text

"BBB"

RadChart2.Series(0).DataYColumn =

"value_column_left"

RadChart2.Series(1).DataYColumn = "

value_column_right"

RadChart2.PlotArea.XAxis.DataLabelsColumn = "

groupby_column"

RadChart2.DataSource = getDataSource()

RadChart2.DataBind()

How can I apply such aggregate functions? Or can it be done during DataBinding, ItemDataBound or DataBound events "by hand"?

Many thanks for some help,
Andreas

Chart (Obsolete)

answered on 26 May 2011