Questions on UI for ASP.NET AJAX Forum

1 answer

131 views

Export to Excel in Telerik Parent Child hierarchical grid

Hi,
We are using having parent child hierarchical Telerik Grid. The grid is containing large number of records(77506 items in 7751 pages).After 2-3 mins,after clicking the Export to Excel button, It's throwing Exception as "Exception of type 'System.OutOfMemoryException' was thrown."

Using the below code for Export to Excel button click event.

gviewAuditTrial.MasterTableView.HierarchyLoadMode = GridChildLoadMode.ServerBind;
gviewAuditTrial.ExportSettings.Excel.Format = GridExcelExportFormat.ExcelML;
gviewAuditTrial.ExportSettings.IgnorePaging = true;
gviewAuditTrial.ExportSettings.OpenInNewWindow = true;
gviewAuditTrial.ExportSettings.FileName = "CRF_Details";
gviewAuditTrial.ExportSettings.ExportOnlyData = true;
gviewAuditTrial.MasterTableView.ExportToExcel();

Please let me know the solution for this.

Thanks,
Prasad
Prasad@magnasys.net

General Discussions

answered on 10 Dec 2012

3 answers

133 views

close radwindow inside...

Dear friends, I found may threads but none of them worked for me. what I'm trying to do is:

main page (with masterpage) will call page1 in radwindow
o page1, I need to close radwindow and sense its closed so I'll go on...

problem is, I could not find main page's radwindow control and cannot close it. can you help me ?

on main page I open as:

<telerik:radwindowmanager id="RadWindowManager1" reloadonshow="true" runat="server">

<Windows>

<telerik:RadWindow runat="server" Width="600px" Height="550px" VisibleStatusbar="true" Style="z-index: 10000;"

ID="ExplorerWindow" Modal="true" Behaviors="Default" ShowContentDuringLoad="true" RegisterWithScriptManager="true" >

</telerik:RadWindow>

</Windows>

</telerik:radwindowmanager>

Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click

ExplorerWindow.NavigateUrl = "page1.aspx"

ExplorerWindow.VisibleOnPageLoad = True

End Sub

I dont know howto find radwindow from the page inside radwindow.

Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click

' close window

End Sub

there's nothing in pages as this is isolated test application. just trying to close radwindow.
thanks...

Window

answered on 10 Dec 2012

1 answer

160 views

'AjaxControlToolkit.NumericUpDownExtender'

'AjaxControlToolkit.NumericUpDownExtender' cannot extend controls of type 'Telerik.Web.UI.RadNumericTextBox'..How to use
'Telerik.Web.UI.RadNumericTextBox' with numeric updown extender

Input

answered on 10 Dec 2012

1 answer

77 views

Add columns before export

I have a grid that is pulling data from a stored procedure. When I export, I want to query another stored procedure that has many additional columns of data returned. Is it possible to bind my grid to a separate datasource prior to exporting to excel or pdf? It is not an option for me to loop through the columns returned and show/hide each one. Any thoughts are appreciated!

Grid

answered on 10 Dec 2012

2 answers

128 views

Radgrid column value selection on client side slection (select index changed event)

Hi Everybody
I m stuck.. my radgrid fetches data from a stored procedure ..(DeptID,SubDeptID,DocSubject,DateUploaded).Can I have a select button (like in asp.net grids) which can be used to fire selectedindexchanged event. On the event of slectedindexchanged I want to fetch the rows values for particular columns..
Thanks in advance

Animesh Chatterjee

Grid

answered on 10 Dec 2012

1 answer

362 views

Error "Only one instance of a scriptManager can be added on page"

Hi,
I have a rad grid on my page. I added the below ajax code from one of the examples available in the rad grid site:

<telerik:RadScriptManager runat="server" ID="RadScriptManager1" />

<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">

<AjaxSettings>

<telerik:AjaxSetting AjaxControlID="radgrid1">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="radgrid1"></telerik:AjaxUpdatedControl>

</UpdatedControls>

</telerik:AjaxSetting>

</AjaxSettings>

</telerik:RadAjaxManager>

I am getting the error "Only one instance of a ScriptManager can be added to the page".

How to fix this?
Thanks

Grid

answered on 10 Dec 2012

2 answers

197 views

Program Flow for using my own GridButtonColumn to Edit ?

Hi ,
I am trying to understand how to use a GridButtonColumn as an Edit button to display my FormTemplate. A few questions.  When I use it, the form magicaly appears. Thats great, but the control freak in me is puzzled.  I would like to control when it displays the form ?

1) When I use a GridButtonColumn, I see it comming into the ItemCommand event, but it disappears, then the form appears. Is it the CommandName, CommandArgument or UniqueName that goes somewhere beyond that to display the actual form ? What events, properties or code is used to turn on a FormTemplate ?  Perhaps the code that turns on the form is expecting a certain combination of CommandName, CommandArgument or even UniqueName ?  Or maybe on of the 'on' properties (onInsert, onUpdate, etc) in combination with ?
  2) Is it just good Telerik to always use the GridEditCommandColum for this ?
3) Why is there no GridDeleteCommandColumn or is the GridEditCommandColumn used for delete - I see there are delete like properties there ? And I have seen code to that effect - Is this the standard ?
4) Is there any documentation explaining the how, why and when for the use of the GridEditCommandColumn vs GridButtonColumn ? Or is the GridButtonColumn intended for all other button uses except Edit and Delete ?
5) There is some code that requires a UniqueID, but the GridEditCommandColum and GridButtonColumn only have the UniqueName.

   Sorry, looks like I have 10 "?" for 5 question Items :-)

   When I test changing CommandName, CommandArgument or even UniqueName in certain combinations, I am beginning to think there is a conflict of sorts when I use a GridButtonColumn for Edit vs a GridEditCommandColumn to display the form.

thanks,
David

Grid

answered on 10 Dec 2012

4 answers

99 views

Set Custom Data/Override Data With EntityDataSource and AllowAutomaticUpdates

I have a RadGrid with using AllowAutomaticUpdates and EntityDataSource and I'd like to set some custom data (or override data) before the item is saved.

How do I do this?

I've tried this, but it doesn't work:

protected void rgUnits_UpdateCommand(object sender, GridCommandEventArgs e)

{

GridEditableItem item = (GridEditableItem)e.Item;

((RadDatePicker)item["LastModified"].Controls[0]).SelectedDate = DateTime.Now;

((TextBox)item["LastModifiedBy"].Controls[0]).Text = Context.User.Identity.Name;

}

<telerik:GridDateTimeColumn DataField="LastModified" FilterControlAltText="Filter Last Modified" HeaderText="Last Modified" SortExpression="LastModified" UniqueName="LastModified" ReadOnly="true" AllowFiltering="true" ColumnEditorID="gceSmallDateBox" DataFormatString="{0:dd/MM/yyyy}" PickerType="DatePicker">

</telerik:GridDateTimeColumn>

<telerik:GridBoundColumn DataField="LastModifiedBy" FilterControlAltText="Filter Last Modified By" HeaderText="Last Modified By" SortExpression="LastModifiedBy" UniqueName="LastModifiedBy" ReadOnly="true" AllowFiltering="true">

</telerik:GridBoundColumn>

I don't *need* to have them as Grid Columns, but I figured this is what I'd have to do to get it work.

Grid

answered on 10 Dec 2012

14 answers

233 views

UseStaticHeaders causing a bug in footer

Hi,

I'm having a problem with the RadGrid and using StaticHeader. When UseStaticHeaders="true", the header and footer get a margin-right of 17px (the size of the vertical scrollbar). This results in an empty/white space next to the footer/header. However, if I decrease the page size to 10, the scrollbar disappears. Now, the margin from the header is removed and gets the full width of the grid. But the margin is not removed from the footer.

Steps to reproduce:

Markup:

<telerik:RadGrid ID="grdData" runat="server" PageSize="20" AllowPaging="true" ShowFooter="true" OnNeedDataSource="grdData_NeedDataSource">

<ClientSettings>

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

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

</ClientSettings>

<MasterTableView AutoGenerateColumns="true">

</MasterTableView>

</telerik:RadGrid>

Code behind:

public partial class test : System.Web.UI.Page {

public class MyDataItem {

public int Id { get; set; }

public string Name { get; set; }

}

protected void Page_Load(object sender, EventArgs e) {

}

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

List<MyDataItem> datasource = new List<MyDataItem>();

for (int i = 0; i < 100; i++) {

datasource.Add(new MyDataItem() {

Id = i,

Name = "name_" + i

});

}

grdData.DataSource = datasource;

}

On initial load, the page size is 20 and the vertical scrollbar, including the whitespaces, it rendered.
Now reduce the pagesize to 10: the vertical scrollbar is gone but the whitespace next to the footer remains.

In this example in doesn't look like a problem (besides it doesn't look nice). However, I'm having a grid with 20 columns and values in the footer. The last value can't be read completely because half of the text is cut of due to the margin.

Is this realy a bug or am I doing something wrong? And is there any workaround?

Thanks.

Grid

answered on 09 Dec 2012

1 answer

113 views

radmenu onclick updateprogress

hello,
I' m new in raddevelopment and I'm trying the free Telerik's version
For some reason, I put the radMenu control in an ascx asp.net control and the ascx control is in a masterPage
The basic functions of the menu are working well
But the calling pages are heavy, and it takes several secondes/ minutes to load.
I need to put a waiting message onload
In a normal aspx page, I put the radMenu in an updatepanel, with a updateprogress and there isn't ny problem
But,in the mentioned situation, I tried onclick, onitemclick, onitemdatadound, and every onclient function. I won't be able to fire any waiting message.
Do you have some idea?
Thank you

Menu

answered on 09 Dec 2012