Questions on UI for ASP.NET AJAX Forum

2 answers

226 views

Hi,

I have implemented a Radgrid in my website and i have added the following attribute to each Gridboundcolumn:

DataFormatString="<nobr>{0}</nobr>"

The purpose of this was to resize the width of each column to the data it contains automatically as i understand there is no other way to do so.

The problem I have is that when I export the gridcontents to Excel or csv, then the <nobr></nobr> tags surround each cell's data.

Is there a way to eliminate these tags on export without having to first replace the tags in the grid contents, which in turn removes the formatting?

Regards,

Shane

Grid

answered on 27 Oct 2011

1 answer

304 views

Grand Total on top of the stacked bar chart

Hi

I want to display the grand total on top of the last series. When i do the DefaultLabelValue for the last chart series, it is overriding the last series label value. Please guide me to achieve the grand total in the stacked bar. Please see the attached image.

if (cs.Index == chart.Series.Count-1)

{

cs.DefaultLabelValue = "#STSUM";

cs.Appearance.LabelAppearance.Position.AlignedPosition = Telerik.Charting.Styles.AlignedPositions.Top;

cs.Appearance.LabelAppearance.LabelLocation = Telerik.Charting.Styles.StyleSeriesItemLabel.ItemLabelLocation.Auto;

}

Anyone guide me how the calculation is happening for the

cs.DefaultLabelValue = "#STSUM"; So that i could add one more series with all the values as 1 and substracting 1 from the total.



Regards

Arima

Chart (Obsolete)

answered on 27 Oct 2011

3 answers

158 views

Refresh data on lower levels of a RadGrid

Hello, Telerik Team,
I have a question about your RadGrid control.

I have a Hierarchical RadGrid with two levels, the markup of the grid looks like this:

<telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="true" AllowCustomPaging="true"

AllowMultiRowSelection="true">

<MasterTableView DataKeyNames="ID" ClientDataKeyNames="ID" InsertItemPageIndexAction="ShowItemOnCurrentPage">

<Columns>

<telerik:GridButtonColumn ButtonType="ImageButton" ImageUrl="~/Images/Icons/Edit.png"

CommandName="Edit" Text="Edit"

UniqueName="EditColumn">

</telerik:GridButtonColumn>

<telerik:GridButtonColumn ButtonType="ImageButton" ImageUrl="~/Images/Icons/Delete.png"

CommandName="DeleteShift" ConfirmText="Do you want to delete this Shift?" ConfirmDialogHeight="150"

ConfirmTitle="Confirmation" ConfirmDialogType="RadWindow"

Text="Delete" UniqueName="DeleteColumn">

</telerik:GridButtonColumn>

<telerik:GridButtonColumn ButtonType="ImageButton" ImageUrl="~/Images/Icons/AddRecord.png"

CommandName="AddJob" Text="Add Job"

UniqueName="AddJob">

</telerik:GridButtonColumn>

<telerik:GridButtonColumn ButtonType="ImageButton" ImageUrl="~/Images/Icons/ExportCSV.png"

CommandName="ExportJobsCSV" Text="Export Jobs"

UniqueName="ExportJobsCSV">

</telerik:GridButtonColumn>

<telerik:GridBoundColumn DataField="ID" HeaderText="ID" UniqueName="ID" Visible="False">

</telerik:GridBoundColumn>

</Columns>

<DetailTables>

<telerik:GridTableView Width="100%" runat="server" DataKeyNames="ID" ClientDataKeyNames="ID" AllowFilteringByColumn="false" AllowPaging="false" ItemStyle-BackColor="#DCD9C5" AlternatingItemStyle-BackColor="#C0BDAE" AllowSorting="false">

<%--<ParentTableRelation>

<telerik:GridRelationFields DetailKeyField="ShiftID" MasterKeyField="ID" />

</ParentTableRelation>--%>

<Columns>

<%-- <telerik:GridEditCommandColumn ButtonType="ImageButton" EditImageUrl="~/Images/Icons/Edit.png"

HeaderStyle-Font-Size="Smaller" HeaderStyle-Width="34px" HeaderText="Edit" UniqueName="EditColumn" />--%>

<telerik:GridButtonColumn ButtonType="ImageButton" ImageUrl="~/Images/Icons/Edit.png"

CommandName="EditJob"

UniqueName="EditColumn" Text="Edit">

</telerik:GridButtonColumn>

<telerik:GridButtonColumn ButtonType="ImageButton" ImageUrl="~/Images/Icons/Delete.png"

CommandName="DeleteJob" ConfirmTitle="Confirmation" ConfirmText="Are you sure you want do delete this Job?"

ConfirmDialogHeight="150" ConfirmDialogType="RadWindow"

Text="Delete" UniqueName="DeleteColumn" />

</Columns>

</telerik:GridTableView>

</DetailTables>

<CommandItemTemplate>

<div class="cmdItem">

<asp:LinkButton ID="btnAddShift" runat="server" CommandName="Add Shift" OnClientClick="javascript:lastTableView=null;">

<img alt="" src="../../Images/Icons/AddRecord.png" />Add Shift</asp:LinkButton>

<asp:LinkButton ID="btnExportCSV" runat="server" CommandName="Export CSV" OnClientClick="return exportGrid('CSV');"><img alt="" src="../../Images/Icons/ExportCSV.png" />Export to CSV</asp:LinkButton>

<asp:LinkButton ID="btnManageShiftColumns" runat="server" CommandName="Manage Shift Columns">

<img alt="" src="../../Images/Icons/Columns.png" />Manage Shift Columns</asp:LinkButton>

<asp:LinkButton ID="btnManageJobColumns" runat="server" CommandName="Manage Job Columns">

<img alt="" src="../../Images/Icons/Columns.png" />Manage Job Columns</asp:LinkButton>

<%--<asp:LinkButton ID="btnDetailedExportCSV" runat="server" CommandName="Export CSV Detailed"

OnClientClick="return exportGrid('CSVDetailed');"><img alt="" src="../../Images/Icons/ExportCSV.png" />Detailed Export to CSV</asp:LinkButton>

<asp:LinkButton ID="btnExportPDF" runat="server" CommandName="Export PDF" OnClientClick="return exportGrid('PDF');"><img alt="" src="../../Images/Icons/ExportPDF.png" />Export to PDF</asp:LinkButton> --%>

</div>

</CommandItemTemplate>

</MasterTableView>

<ClientSettings>

<ClientEvents OnCommand="gridCommand" />

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

</ClientSettings>

</telerik:RadGrid>

The refreshGrid Javascript function looks like this:

function refreshGrid(sender) {

$find("<%= RadGrid1.ClientID %>").get_masterTableView().rebind();

showScrollBars();

}

I have a RadWindow where another page is loaded where I can add/delete/modify columns and I have a "sunny day" scenario when the columns in the outer level are changed: the grid is rebinded and the new columns appear nicely. However, when I modify/delete/add columns in the inner levels the grid is rebinded, but the column set in the inner levels is not refreshed. I've debugged the server-side code and everything is fine there, but on the client side I have the old column setup. Is there a solution to my problem, or should I wait for a new version of Telerik?

Note: I've done a temporary hack to hide this anomality from the users where the refreshGrid function only rebinds if the column modification/deletion/insertion happened in the outer layer. Elseway the page is reloaded. I know this is an ugly hack, but I don't see any alternatives.

I appreciate any help.
Sincerely Yours,
Lajos Arpad.

Grid

answered on 27 Oct 2011

6 answers

201 views

Control bind order changed with RadAjaxManager?

I have a fairly simple page that contains a DropDownList control and a DetailsView control in a master/details type setup.

The DetailsView displays the details of the record selected in the DropDownList.

This form works perfectly without RadAjaxManager.

However, as soon as I hook up the RadAjaxManager I get errors in the code.

Troubleshooting the issue I was able to determine that the DetailsView.DataBound event is being triggered BEFORE the DropDownList.DataBound event. Code in the DetailsView.DataBound event populates a control within the DetailsView with data associated with the currently selected item in the DropDownList. But an error occurs because there is no DropDownList.SelectedValue because the DropDownList control hasn't been databound yet.

As I said, this does not occur when RadAjaxManager is not on the page.

What do I need to set in RadAjaxManager to make sure that the controls get bound in the correct order? (top-down)

Note I've hooked up event handlers for DetailsView.ModeChanged and DetailsView.DataBound. Also note I've hooked up the DropDownList.PreRender event as well with the following code:

    
            CType(sender, DropDownList).Attributes.Add("onChange", "window.focus();")

I need to have this code because the user may use his mouse wheel to scroll the page, but if the DropDownList is selected it will scroll that instead and reload the DetailsView.

Ajax

answered on 27 Oct 2011

1 answer

139 views

Client-side paging events?

Hi,

Are there any events on the client side which fire when a new page is requested from the grid for which I can write javascript code to handle?

The reason that I ask is that I have a grid with client-side binding and caching enabled. This works pretty much as I would expect except that when you go to a page which is cached the RadAjaxLoadingPanel isn't shown and I would really like to show it and hide it again for the cached pages as it is great indicator as to whether something is going on.

Stuart

Grid

answered on 27 Oct 2011

1 answer

635 views

[Solved] Close RadWindow Programmatically

I am working with the RadWindow, and an objective is to close the RadWindow once a navigateUrl is applied to a HyperLink;

The issue is with the close of the RadWindow, and how best to close the RadWindow programmatically with C# and/or JavaScript;

Thank in advance for any insight; Best regards - Rob

Window

answered on 27 Oct 2011

1 answer

118 views

ExportToExcel Causing Object not set to an Instance of an Object

I have successfully tested this feature on my dev and live server on multiple browsers on my machine. However the user is receiving the attached screen. The user is using Internet Explorer, although not sure which version at this time.

I used an ImageButton for the export button.

protected void exportToExcel_Click(object sender, ImageClickEventArgs e) {

radGridVesselUtil.ExportSettings.IgnorePaging = true;

radGridVesselUtil.ExportSettings.OpenInNewWindow = true;

radGridVesselUtil.ExportSettings.ExportOnlyData = true;

radGridVesselUtil.ExportSettings.FileName = "vessel_util_" + DateTime.Now.ToShortDateString();

radGridVesselUtil.MasterTableView.ExportToExcel();

}

 protected void gridDpSummary_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e) {

                gridDpSummary.DataSource = SqlDataSource1;

            }

RadGridMarkup

<telerik:RadGrid ID="radGridVesselUtil" runat="server" CellSpacing="0"

AllowPaging="True" AllowSorting="True" PageSize="25"

GridLines="None" EnableEmbeddedSkins="False" Skin="dpgrid"

ShowGroupPanel="True" AutoGenerateColumns="False"

onneeddatasource="radGridVesselUtil_NeedDataSource">

<MasterTableView>

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

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

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

<Columns>

<telerik:GridBoundColumn FilterControlAltText="Filter Voyage Column"

HeaderText="Voyage" UniqueName="Voyage" DataField="VoyageID">

<HeaderStyle Width="55px" HorizontalAlign="Center"/>

<ItemStyle HorizontalAlign="Center"/>

</telerik:GridBoundColumn>

<telerik:GridBoundColumn FilterControlAltText="Filter Leg Start Column"

UniqueName="LegStart" HeaderText="Start Date" DataField="LegStart">

<HeaderStyle Width="125px" HorizontalAlign="Center"/>

<ItemStyle HorizontalAlign="Center"/>

</telerik:GridBoundColumn>

<telerik:GridBoundColumn FilterControlAltText="Filter Leg End Column"

UniqueName="LegEnd" HeaderText="End Date" DataField="LegEnd">

<HeaderStyle Width="125px" HorizontalAlign="Center"/>

<ItemStyle HorizontalAlign="Center"/>

</telerik:GridBoundColumn>

<telerik:GridBoundColumn FilterControlAltText="Filter Vessel Column"

UniqueName="VesselName" HeaderText="Vessel" DataField="VesselName">

<HeaderStyle HorizontalAlign="Center"/>

</telerik:GridBoundColumn>

<telerik:GridBoundColumn FilterControlAltText="Filter Facility Column"

UniqueName="FacilityName" HeaderText="Facility" DataField="FacilityName">

<HeaderStyle HorizontalAlign="Center"/>

</telerik:GridBoundColumn>

<telerik:GridBoundColumn FilterControlAltText="Filter Time Usage column"

HeaderText="Time Usage" UniqueName="TimeUsage" DataField="TimeUsage">

<HeaderStyle HorizontalAlign="Center"/>

</telerik:GridBoundColumn>

<telerik:GridBoundColumn FilterControlAltText="Filter Volume Usage column"

HeaderText="Volume Usage" UniqueName="VolumeUsage" DataField="VolumeUsage">

<HeaderStyle HorizontalAlign="Center"/>

</telerik:GridBoundColumn>

<telerik:GridBoundColumn FilterControlAltText="Filter Weight column"

HeaderText="Weight" UniqueName="Weight" DataField="Weight">

<HeaderStyle HorizontalAlign="Center"/>

</telerik:GridBoundColumn>

<telerik:GridBoundColumn FilterControlAltText="Filter Capacity Usage Column"

HeaderText="Capacity Usage" UniqueName="CapacityUsage" DataField="CapacityUsage">

<HeaderStyle HorizontalAlign="Center"/>

</telerik:GridBoundColumn>

<telerik:GridBoundColumn FilterControlAltText="Filter Deck Space Usage Column"

HeaderText="Deck Space Usage" UniqueName="DeckSpaceUsage" DataField="DeckSpaceUsage">

<HeaderStyle HorizontalAlign="Center"/>

</telerik:GridBoundColumn>

</Columns>

<EditFormSettings>

<EditColumn InsertImageUrl="Update.gif" UpdateImageUrl="Update.gif" EditImageUrl="Edit.gif" CancelImageUrl="Cancel.gif" FilterControlAltText="Filter EditCommandColumn column"></EditColumn>

</EditFormSettings>

<GroupByExpressions>

<telerik:GridGroupByExpression>

<SelectFields>

<telerik:GridGroupByField FieldName="VoyageID" HeaderText="Voyage" />

</SelectFields>

<GroupByFields>

<telerik:GridGroupByField FieldName="VoyageID" SortOrder="Descending" />

</GroupByFields>

</telerik:GridGroupByExpression>

</GroupByExpressions>

</MasterTableView>

<PagerStyle Mode="NextPrevNumericAndAdvanced" />

<ClientSettings ReorderColumnsOnClient="True" AllowDragToGroup="True" AllowColumnsReorder="True">

<Resizing AllowRowResize="True" AllowColumnResize="True" EnableRealTimeResize="True"

ResizeGridOnColumnResize="False"></Resizing>

</ClientSettings>

<GroupingSettings ShowUnGroupButton="true"/>

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

<HeaderContextMenu EnableEmbeddedSkins="False" CssClass="GridContextMenu GridContextMenu_dpgrid"></HeaderContextMenu>

</telerik:RadGrid>

Grid

answered on 27 Oct 2011

3 answers

176 views

Put two columns under a header.

I have a radgrid where I want to put two columns under a header. I am attaching a screenshot to this thread to show you what I want. You will see the column "Open Items by Age" is further divided as "Prior" and "Current" columns. Is this possible to do in a radgrid and still maintain the sort for the "Prior" and "Current" columns. I am attaching code to help you see my grid.

Thanks in advance!

<telerik:RadGrid ID="grdCurrentandPrior" runat="server" AllowSorting="True" AutoGenerateColumns="False"

GridLines="Horizontal" Skin="Web20" Style="margin-right: 0px" Width="897px" Height="252px"

OnNeedDataSource="grdCurrentandPrior_NeedDataSource" OnExcelMLExportRowCreated="grdCurrentandPrior_ExcelMLExportRowCreated" OnSortCommand="grdCurrentandPrior_SortCommand">

<ExportSettings FileName="OpenItemsCurrentInventory" IgnorePaging="True" OpenInNewWindow="True"

ExportOnlyData="true" Excel-Format="ExcelML">

</ExportSettings>

<MasterTableView CommandItemDisplay="Bottom" AllowNaturalSort="false" UseAllDataFields="true">

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

ShowRefreshButton="false" />

<Columns>

<telerik:GridTemplateColumn DataField="Assignee" HeaderText="Assignee" UniqueName="Assignee"

SortExpression="Assignee">

<HeaderStyle Font-Bold="True" Width="150px" HorizontalAlign="Center" Font-Names="Arial" />

<ItemTemplate>

<asp:Label ID="lbAssignee" runat="server" Text='<%# Eval("Assignee") %>'></asp:Label>

</ItemTemplate>

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

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn DataField="State" HeaderText="State" UniqueName="State"

SortExpression="State" Visible="false">

<HeaderStyle Font-Bold="True" Width="150px" HorizontalAlign="Center" Font-Names="Arial" />

<ItemTemplate>

<asp:Label ID="lbState" runat="server" Text='<%# Eval("State") %>'></asp:Label>

</ItemTemplate>

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

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn DataField="JurisdictionCount" HeaderText="Jurisdictions"

UniqueName="JurisdictionCount" SortExpression="JurisdictionCount">

<HeaderStyle Font-Bold="True" Width="80px" HorizontalAlign="Center" Font-Names="Arial" />

<ItemTemplate>

<asp:Label ID="lbJurisdiction" runat="server" Text='<%# Eval("JurisdictionCount", "{0:N0}")%>'></asp:Label>

</ItemTemplate>

<ItemStyle HorizontalAlign="Right" ForeColor="Black" />

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

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn DataField="OpenItemsCountPrior" HeaderText="Prior Open Items"

UniqueName="OpenItemsCountPrior" SortExpression="OpenItemsCountPrior">

<HeaderStyle Font-Bold="True" Width="80px" HorizontalAlign="Center" Font-Names="Arial" />

<ItemTemplate>

<asp:Label ID="lbPrior" runat="server" Text='<%# Eval("OpenItemsCountPrior", "{0:N0}") %>'></asp:Label>

</ItemTemplate>

<ItemStyle HorizontalAlign="Right" ForeColor="Black" />

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

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn DataField="OpenItemsCountLastMonth" HeaderText="Last Month Items"

UniqueName="OpenItemsCountLastMonth" SortExpression="OpenItemsCountLastMonth">

<HeaderStyle Font-Bold="True" Width="80px" HorizontalAlign="Center" Font-Names="Arial" />

<ItemTemplate>

<asp:Label ID="lbLastMonth" runat="server" Text='<%# Eval("OpenItemsCountLastMonth", "{0:N0}") %>'></asp:Label>

</ItemTemplate>

<ItemStyle HorizontalAlign="Right" ForeColor="Black" />

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

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn DataField="OpenItemsCountCurrent" HeaderText="Current Open Items"

UniqueName="OpenItemsCountCurrent" SortExpression="OpenItemsCountCurrent">

<HeaderStyle Font-Bold="True" Width="100px" HorizontalAlign="Center" Font-Names="Arial" />

<ItemTemplate>

<asp:Label ID="lbCurrent" runat="server" Text='<%# Eval("OpenItemsCountCurrent", "{0:N0}") %>'></asp:Label>

</ItemTemplate>

<ItemStyle HorizontalAlign="Right" ForeColor="Black" />

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

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn DataField="TotalRemainingItems" HeaderText="Items Left to Pay"

UniqueName="TotalRemainingItems" SortExpression="TotalRemainingItems">

<HeaderStyle Font-Bold="True" Width="95px" HorizontalAlign="Center" Font-Names="Arial" />

<ItemTemplate>

<asp:Label ID="lblTotalRemain" runat="server" Text='<%# Eval("TotalRemainingItems", "{0:N0}") %>'></asp:Label>

</ItemTemplate>

<ItemStyle HorizontalAlign="Right" ForeColor="Black" />

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

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn DataField="CompleteCount" HeaderText="Complete"

UniqueName="CompleteCount" SortExpression="CompleteCount">

<HeaderStyle Font-Bold="True" Width="80px" HorizontalAlign="Center" Font-Names="Arial" />

<ItemTemplate>

<asp:Label ID="lblCompleteCount" runat="server" Text='<%# Eval("CompleteCount", "{0:N0}") %>'></asp:Label>

</ItemTemplate>

<ItemStyle HorizontalAlign="Right" ForeColor="Black" />

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

</telerik:GridTemplateColumn>

<telerik:GridTemplateColumn DataField="PercentComplete" HeaderText="% Complete" UniqueName="clmPctComplete"

SortExpression="PercentComplete">

<HeaderStyle Font-Bold="True" Width="85px" HorizontalAlign="Center" Font-Names="Arial" />

<ItemTemplate>

<asp:Label ID="lblPctComplete" runat="server" Text='<%# Eval("PercentComplete", "{0:N2}%")%>'></asp:Label>

</ItemTemplate>

<ItemStyle HorizontalAlign="Right" ForeColor="Black" />

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

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn DataField="AssigneeEmployeeKey" ReadOnly="True" UniqueName="AssigneeEmployeeKey"

Visible="False">

</telerik:GridBoundColumn>

</Columns>

</MasterTableView>

<HeaderStyle BorderStyle="Solid" />

<ClientSettings>

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

</ClientSettings>

</telerik:RadGrid>

Grid

answered on 27 Oct 2011

1 answer

109 views

How to refresh Radgrid

Greetings,

For various reasons i had to add data to my grid outside the grid itself (no use of Edit,Delete buttom)
Therefore when i make a query the grid does not refresh...
How could i make this ?

Thanks in advance

Grid

answered on 27 Oct 2011

1 answer

195 views

[Solved] Hide Method of RadWindow

I'm writing to ask if there are examples of utilizing the hide method of the RadWindow - to make the RadWindow invisible;

Thanks in advance for any insight; Best regards - Rob

Window

answered on 27 Oct 2011