Questions on UI for ASP.NET AJAX Forum

3 answers

205 views

Poor performance for large number of records

Hello,

Using Telerik.Web.UI_2011_3_1305
I have a SQL Server table with approx 600,000 records and 28 columns. I created an ASP.Net page with a RadGrid set-up in "Grid / Virtual Scrolling and Paging" as described in the article at:
http://demos.telerik.com/aspnet-ajax/grid/examples/client/virtualscrollpaging/defaultcs.aspx
(see code below)
However the performance is poor: loading a new grid page takes a very long time, approx 30 seconds...

Please also note the following:
- the SQL Server database is hosted on the same machine
- the development machine is very fast and has 6GB of RAM
Therefore it is not the environment that causes the performance issue.

Please advise.
Regards,
M.R.

<telerik:RadGrid ID="RadGrid1" runat="server" CellSpacing="0" DataSourceID="SqlDataSource1"

GridLines="None" Width="916px" AllowPaging="True" VirtualItemCount="5000" PageSize="10">

<ClientSettings>

<Scrolling AllowScroll="True" EnableVirtualScrollPaging="True" UseStaticHeaders="True"

SaveScrollPosition="True"></Scrolling>

</ClientSettings>

<MasterTableView AutoGenerateColumns="False" DataKeyNames="SBACTN" DataSourceID="SqlDataSource1"

AllowCustomPaging="False" AllowPaging="True" AllowSorting="True" VirtualItemCount="5000"

AlternatingItemStyle-ForeColor="#CC00CC">

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

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

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

</RowIndicatorColumn>

<ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column">

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

</ExpandCollapseColumn>

<Columns>

<telerik:GridBoundColumn DataField="SBSACT" FilterControlAltText="Filter SBSACT column"

HeaderText="SBSACT" SortExpression="SBSACT" UniqueName="SBSACT">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SBACTN" FilterControlAltText="Filter SBACTN column"

HeaderText="SBACTN" ReadOnly="True" SortExpression="SBACTN" UniqueName="SBACTN">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SBNAM" FilterControlAltText="Filter SBNAM column"

HeaderText="SBNAM" SortExpression="SBNAM" UniqueName="SBNAM">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SBSTAT" FilterControlAltText="Filter SBSTAT column"

HeaderText="SBSTAT" SortExpression="SBSTAT" UniqueName="SBSTAT" ReadOnly="False">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SBCTY2" FilterControlAltText="Filter SBCTY2 column"

HeaderText="SBCTY2" SortExpression="SBCTY2" UniqueName="SBCTY2">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SBCTY1" FilterControlAltText="Filter SBCTY1 column"

HeaderText="SBCTY1" SortExpression="SBCTY1" UniqueName="SBCTY1">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SBGRID" FilterControlAltText="Filter SBGRID column"

HeaderText="SBGRID" SortExpression="SBGRID" UniqueName="SBGRID">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SBCNCL" FilterControlAltText="Filter SBCNCL column"

HeaderText="SBCNCL" SortExpression="SBCNCL" UniqueName="SBCNCL">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SBI2NO" FilterControlAltText="Filter SBI2NO column"

HeaderText="SBI2NO" SortExpression="SBI2NO" UniqueName="SBI2NO">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SBDMS1" FilterControlAltText="Filter SBDMS1 column"

HeaderText="SBDMS1" SortExpression="SBDMS1" UniqueName="SBDMS1">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SBDMS2" FilterControlAltText="Filter SBDMS2 column"

HeaderText="SBDMS2" SortExpression="SBDMS2" UniqueName="SBDMS2">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SBDTIN" DataType="System.DateTime" FilterControlAltText="Filter SBDTIN column"

HeaderText="SBDTIN" SortExpression="SBDTIN" UniqueName="SBDTIN">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SBDTCN" DataType="System.DateTime" FilterControlAltText="Filter SBDTCN column"

HeaderText="SBDTCN" SortExpression="SBDTCN" UniqueName="SBDTCN">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SBDTST" DataType="System.DateTime" FilterControlAltText="Filter SBDTST column"

HeaderText="SBDTST" SortExpression="SBDTST" UniqueName="SBDTST">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SBLANG" FilterControlAltText="Filter SBLANG column"

HeaderText="SBLANG" SortExpression="SBLANG" UniqueName="SBLANG">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SBCONT" FilterControlAltText="Filter SBCONT column"

HeaderText="SBCONT" SortExpression="SBCONT" UniqueName="SBCONT">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SBADDR" FilterControlAltText="Filter SBADDR column"

HeaderText="SBADDR" SortExpression="SBADDR" UniqueName="SBADDR">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SBSTR" FilterControlAltText="Filter SBSTR column"

HeaderText="SBSTR" SortExpression="SBSTR" UniqueName="SBSTR">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SBCTY" FilterControlAltText="Filter SBCTY column"

HeaderText="SBCTY" SortExpression="SBCTY" UniqueName="SBCTY">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SBPROV" FilterControlAltText="Filter SBPROV column"

HeaderText="SBPROV" SortExpression="SBPROV" UniqueName="SBPROV">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SBPOST" FilterControlAltText="Filter SBPOST column"

HeaderText="SBPOST" SortExpression="SBPOST" UniqueName="SBPOST">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SBTEL" FilterControlAltText="Filter SBTEL column"

HeaderText="SBTEL" SortExpression="SBTEL" UniqueName="SBTEL">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SBDTSG" DataType="System.DateTime" FilterControlAltText="Filter SBDTSG column"

HeaderText="SBDTSG" SortExpression="SBDTSG" UniqueName="SBDTSG">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SBFMS7" FilterControlAltText="Filter SBFMS7 column"

HeaderText="SBFMS7" SortExpression="SBFMS7" UniqueName="SBFMS7">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SBFMS1" FilterControlAltText="Filter SBFMS1 column"

HeaderText="SBFMS1" SortExpression="SBFMS1" UniqueName="SBFMS1">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SBCOMP" FilterControlAltText="Filter SBCOMP column"

HeaderText="SBCOMP" SortExpression="SBCOMP" UniqueName="SBCOMP">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SBFMS5" FilterControlAltText="Filter SBFMS5 column"

HeaderText="SBFMS5" SortExpression="SBFMS5" UniqueName="SBFMS5">

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="SBSIC" FilterControlAltText="Filter SBSIC column"

HeaderText="SBSIC" SortExpression="SBSIC" UniqueName="SBSIC">

</telerik:GridBoundColumn>

</Columns>

<EditFormSettings>

<EditColumn FilterControlAltText="Filter EditCommandColumn column">

</EditColumn>

</EditFormSettings>

</MasterTableView>

<FilterMenu EnableImageSprites="False">

</FilterMenu>

</telerik:RadGrid>

Grid

answered on 16 Jul 2012

5 answers

382 views

open a regular browser window from a RadWindow and make it active

I have a web page that is a list of reports. I use a RadWindow to get the user to enter parameters for the report. Is it possible to get the RadWindow to open a new browser window that is active? I'm using the javascript below which opens the report in a new window but it ends up behind my report selection window.

    
            function returnToParent() 
        
            { 
        
                window.open(report + paras, "", "height=740,scrollbars=yes,width=1000,status=yes,toolbar=yes,menubar=yes,resizable=yes"); 
        
                self.close(); 
        
            }

I think what's happening is the RadWindow opens the new browser window then closes and the focus reverts back to the parent window. End result is the new browser window opened for the report is behind my report selection window. I'd live to have the new window appear on top as the active window. Any ideas?

Window

answered on 16 Jul 2012

4 answers

235 views

How to use jQuery IsDirty with RadCombobox SelectedIndexChanged and LoadsOnDemand

We are using jQuery to identify if a form isDirty which works great except when there is a radComboBox that has a selectedIndexChanged and loadsOnDemand? When the user types something in the RadComboBox, jQuery sees the form as Dirty and when the user clicks cancel from the confirmation popup there is an error.

Is there a way to exclude the radComBox for the isDirty?

OR

Is there a way to stop the RadComboBox from postingBack to the OnSelectedIndexChanged if the user selects cancel from the confirmation popup?

Attached is the error and here are snippets of our code:

    
            <telerik:RadComboBox runat="server" ID="PermitRadComboBox" Height="190px" Width="250px" 
        
                EmptyMessage="Type a code or name" MarkFirstMatch="true" EnableLoadOnDemand="true" 
        
                HighlightTemplatedItems="true" OnClientItemsRequested="UpdateItemCountField" 
        
                OnDataBound="PermitRadComboBox_DataBound" OnItemDataBound="PermitRadComboBox_ItemDataBound" 
        
                OnItemsRequested="PermitRadComboBox_ItemsRequested" DropDownWidth="450px" AutoPostBack="True" 
        
                CausesValidation="False" OnSelectedIndexChanged="PermitRadComboBox_SelectedIndexChanged">  
        
                <HeaderTemplate> 
        
                    <ul> 
        
                        <li class="col1">Number</li> 
        
                        <li class="col2">Permittee</li> 
        
                    </ul> 
        
                </HeaderTemplate> 
        
                <ItemTemplate> 
        
                    <ul> 
        
                        <li class="col1">  
        
                            <%# DataBinder.Eval(Container.DataItem, "permit_number") %></li>  
        
                        <li class="col2">  
        
                            <%# DataBinder.Eval(Container.DataItem, "permittee") %></li>  
        
                    </ul> 
        
                </ItemTemplate> 
        
                <FooterTemplate> 
        
                    A total of  
        
                    <asp:Literal runat="server" ID="RadComboItemsCount" /> 
        
                    items  
        
                </FooterTemplate> 
        
            </telerik:RadComboBox>

    
            <script type="text/javascript">  
        
                var isDirty = false;  
        
                var msg = 'This page has unsaved changes.\n\nClick OK to abandon the changes and leave the page.\n\nClick Cancel to stay on the page so you can save your changes.';  
        
                $(document).ready(function ()  
        
                {  
        
                    $(':input').change(function ()  
        
                    {  
        
                        if (!isDirty)  
        
                        {  
        
                            isDirty = true;  
        
                        }  
        
                    });  
        
                    window.onbeforeunload = function ()  
        
                    {  
        
                        if (isDirty) return msg;  
        
                    };  
        
                });  
        
            </script>

We are very new to the jQuery framework so any help very much appreciated.

Thanks in advance,
Gene.

ComboBox

answered on 16 Jul 2012

3 answers

526 views

how to Cancel Event OnClientNodeClicked

Hi

I have to cancel the event if the condition is False, for example: I have a treeview with images, before opening the image is valid if the image is already displayed, if it is already displayed have to cancel the event, not allowing it to spread

how I do this

thanks

<telerik:RadTreeView ID="DocTreeView" runat="server" CssClass="cssTreeView" Height="100%"

Width="285" OnClientNodeClicked ="onclickTreeview" onNodeClick="DocTreeView_NodeClick">

</telerik:RadTreeView>

My Jquery Code

function onclickTreeview(sender, args) {

code........

if (!AllowImageOpen) {

alert('This image is now displayed');

// cancel the event here

}

TreeView

answered on 16 Jul 2012

5 answers

256 views

How to access TreeListDataItem from TreeListDetailTemplateItem

I'm building a control that runs inside of the DetailsView of Rad TreeList.

My naming container is a TreeListDetailTemplateItem. From this context, I can't find an easy way to get access to the TreeListDataItem for this row (To get DisplayIndex). If it happens we are data-binding, I can do this hack:

var detaiItem = (this.NamingContainer as TreeListDetailTemplateItem);

if (detailItem.DataItem != null)

{

//HACK: Cast to my business class, use the key value to find the appropriate treelistDataItem

var itemId = (detailItem.DataItem as CheckListItem).CheckListItemID;

treeListDataItem = RadTreeList1.Items.Where(i => (int) i.GetDataKeyValue("CheckListItemID") == itemId).SingleOrDefault();

var displayIndex = treeListDataItem.DisplayIndex

.....

}

I have the same limitation from within TreeList -> ItemCreated(). When trying to draw a Context menu for my DetailsView body, I run into an issue getting the DisplayIndex. Per this example: http://www.telerik.com/community/forums/aspnet-ajax/treelist/dose-the-tree-list-have-a-context-menu-funcationality.aspx#1428456

I had to hack around it using this code:

protected void RadTreeList1_ItemCreated(object sender, TreeListItemCreatedEventArgs e)

{

TreeListDataItem treeListDataItem = null;

if (e.Item is TreeListDataItem )

{

treeListDataItem = (TreeListDataItem)e.Item;

treeListDataItem.Attributes["oncontextmenu"] = "ShowContextMenu(" + treeListDataItem.DisplayIndex + ", event);";

}

else if (e.Item is TreeListDetailTemplateItem)

{

// We need the TreeListDataDataItem so we can use it's Display Index

var detailItem = (e.Item as TreeListDetailTemplateItem);

if (detailItem.DataItem != null)

{

var itemId = (detailItem.DataItem as CheckListItem).CheckListItemID;

treeListDataItem = RadTreeList1.Items.Where(i => (int) i.GetDataKeyValue("CheckListItemID") == itemId).SingleOrDefault();

detailItem.Attributes["oncontextmenu"] = "ShowContextMenu(" + treeListDataItem.DisplayIndex + ", event);";

}

Anyone know some magical cast/path to jump from TreeListDetailTemplateItem to TreeListDataItem? Also, will these controls be implementing IDataItemContainer anytime soon?

TreeList

answered on 16 Jul 2012

1 answer

78 views

Sharepoint 2010 folder dialog window

Hi
In my sharepoint 2010 application, need to select a folder thru folder dialog window/popup. How to create it.
Is it possible with any telerik/asp.net controls (or) Is any other way to get dialog window with selecting a folder and upload all the files from folder.

Note: I know RadUpload control upload one file at a time. I need to select folder, no matter what how many files exists in the folder.

regards
Jay

Sharepoint Integration

answered on 16 Jul 2012

3 answers

273 views

Filter & Paging not working in Radgrid

Hi,
I am working on Project which has a Radgrid, project was running successfully and the out come is alright. But my problem is filtering and paging is not working.

<telerik:RadGrid ID="RadGrid1" Skin="WebBlue" runat="server" AllowFilteringByColumn="true" AutoGenerateColumns="true" ShowStatusBar="True" GridLines="None" AllowPaging="true" PageSize="20" AllowSorting="True" onitemdatabound="RadGrid1_ItemDataBound" EnableLinqExpressions ="false">

<telerik:GridBoundColumn FilterControlWidth="50px" DataField=" total_float " HeaderText="Total Float" SortExpression=" total_float " UniqueName=" total_float ">
</telerik:GridBoundColumn>

</Columns>
</MasterTableView>
</telerik:RadGrid>

This is my code and i placed only one row for sample.

Protected Sub RadGrid1_PreRender(ByVal sender As Object, ByVal e As EventArgs)
RadGrid1.MasterTableView.AllowFilteringByColumn = True
RadGrid1.Rebind()
End Sub

Also i placed this in my code(VB) behind file.
Can any one help me, Thanks in advance.

Grid

answered on 16 Jul 2012

1 answer

89 views

RadCombobox Insert and Databind Sample Time

I want insert and databind in radcombobox ,
How i achieve this

RadComboBoxItem Item6 = new RadComboBoxItem(Resources.Ticket.Action_Knowledge_Base);

Item6.Value = "1";

Item6.ImageUrl = "../Content/images/contextmenu/knowledgebase.png";

ddl_Actions.Items.Insert(8, Item6);

RadComboBoxItem Item7 = new RadComboBoxItem(Resources.Ticket.Action_CustomAction);

Item7.Value = "9";

Item7.ImageUrl = "../Content/images/contextmenu/caction.png";

ddl_Actions.Items.Insert(9, Item7);

RadComboBoxItem Item8 = new RadComboBoxItem(Resources.Ticket.Ticket_RemoveFromFolder);

Item8.Value = "12";

Item8.ImageUrl = "../Content/images/contextmenu/remove-from-folder.png";

ddl_Actions.Items.Insert(10, Item8);

RadComboBoxItem Item10 = new RadComboBoxItem(Resources.Ticket.Ticket_Create_Change_Request);

Item10.Value = "10";

Item10.ImageUrl = "../Content/images/contextmenu/changerequest_conf.png";

ddl_Actions.Items.Insert(11, Item10);

RadComboBoxItem Item11 = new RadComboBoxItem(Resources.TicketSubscription.Subscribe);

Item11.Value = "11";

Item11.ImageUrl = "../Content/images/contextmenu/subscribe.png";

ddl_Actions.Items.Insert(12, Item11);

using (var db = new TBSHelpDeskDataContext(Globals.strCon))

{

var md = (from a in db.CustomActions select new { a.CustomAction_ID, a.Name }).ToList();

ddl_Actions.DataSource = md;

ddl_Actions.DataValueField = "CustomAction_ID";

ddl_Actions.DataTextField = "Name";

ddl_Actions.DataBind();

}

Thanks Advance,
Mohamed.

ComboBox

answered on 16 Jul 2012

1 answer

99 views

Custom Module & disabled rad editor

I have a custom module that works fine if my rad editor starts "enabled". On pages where the default state of the editor is disabled until the user puts the form into edit mode, the module just doesn't show up. If I just change the initial state of the editor to enabled it works fine. Is there something I need to be registering when the page mode is changed to edit to ensure that my custom module will show up?

Editor

answered on 16 Jul 2012

1 answer

93 views

Radgrid ItemTemplate Freeze in Chrome

Dear Telerik,

I have some problem here in IE it's work well but in Google chrome all my control located in my Radgrid become freeze. I don't want to use EditItemTemplate in Radgrid because of my business problem. Here is my screenshot :

*Arrow red is indicating freeze control. I cannot change the value.

Here is some of my aspx :

<ItemTemplate>

<telerik:RadNumericTextBox ID="lblNominationInstruction" runat="server" MaxLength="15"

Width="100px" Visible="true" MinValue="0" NumberFormat-DecimalDigits="4" NumberFormat-DecimalSeparator="."

NumberFormat-GroupSeparator="," NumberFormat-GroupSizes="3" NumberFormat-KeepNotRoundedValue="True"

DisabledStyle-BorderStyle="None" Enabled="false" DisabledStyle-BackColor="Transparent"

DisabledStyle-ForeColor="Black" Style="text-align: right" Text='<%# DataBinder.Eval(Container.DataItem, "EntryQuantity")%>'>

</telerik:RadNumericTextBox>

<asp:TextBox ID="txtNominationInstruction" MaxLength="15" runat="server" Visible="false"

Width="100px" Style="text-align: right"></asp:TextBox>

</ItemTemplate>

In my simple term, my questions is :
"How can i using textbox, dropdownlist, and any other control inside RadGrid but I still can edit its value in Google Chrome ?"

Thanks.

Grid

answered on 16 Jul 2012