This is a migrated thread and some comments may be shown as answers.

RadGrid Working Slow When Clicked on Edit/Update/Cancel Buttons or Export to Excel

1 Answer 242 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Vijay asked on 28 Aug 2014, 06:17 AM

Hi,



I am using below source code the grid is working very slow. But the data from DB is fetching very fast less then a sec.



Please suggest for a fix! Thanks













<%@ Page Language="VB" MasterPageFile="~/Views/Common/PTRMasterPage.master" AutoEventWireup="false"

CodeFile="ActivityMaster.aspx.vb" Inherits="Views_Masters_ActivityMaster" Title="Activity Master"

StylesheetTheme="PetrofacSkin" %>

<%@ Register Namespace="PTRCustomClasses" TagPrefix="custom" %>

<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">

<script src="../../JScript/jquery-1.7.2.min.js" type="text/javascript"></script>

<script src="../../JScript/jquery-ui-1.8.19.custom.min.js" type="text/javascript"></script>

<script src="../../JScript/jquery.history.js" type="text/javascript"></script>

<script src="../../JScript/jquery.tooltip.js" type="text/javascript"></script>

<script src="../../JScript/scriptbreaker-multiple-accordion.js" type="text/javascript"></script>

<telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">

<script language="javascript" type="text/javascript">

function onRequestStart(sender, args) {

//debugger;

if ((args.get_eventTarget().indexOf("ExportToExcel") > 0))

args.set_enableAjax(false);

}

</script>

<style type="text/css">

.AjaxLoading

{

background-repeat: no-repeat;

background-position: center;

}

</style>

</telerik:RadCodeBlock>

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

<AjaxSettings>

<telerik:AjaxSetting AjaxControlID="ddlMethodology">

<UpdatedControls>

<telerik:AjaxUpdatedControl ControlID="RadGrid1" LoadingPanelID="RadAjaxLoadingPanel1" />

<telerik:AjaxUpdatedControl ControlID="PanelStatusLabel" />

</UpdatedControls>

</telerik:AjaxSetting>

</AjaxSettings>

</telerik:RadAjaxManager>

<telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Height="75px"

Width="75px" Transparency="5">

<img style="margin-top: 350px;" alt="Loading..." src="../../Images/Telerik Images/Ajax/loading7.gif" />

<%-- <asp:Image id="Image1" runat="server" style="margin-top: 350px;" ImageUrl="~/Images/Telerik%20Images/Ajax/loading3.gif" alternatetext ="Loading..." >

ImageUrl="~/Ajax/Img/loading1.gif"

</asp:Image>

--%>

</telerik:RadAjaxLoadingPanel>

<%-- <telerik:RadAjaxLoadingPanel ID="LoadingPanel1" runat="server">

</telerik:RadAjaxLoadingPanel>--%>

<div id="divCont01" style="display: block; width: 99%">

<table cellpadding="0" cellspacing="5">

<tr>

<td width="15%">

<asp:Label ID="Label5" CssClass="labelStyle" Font-Bold="true" Text="Methodology"

runat="server"></asp:Label>

</td>

<td width="75%">

<asp:DropDownList ID="ddlMethodology" runat="server" AppendDataBoundItems="True"

TabIndex="3" CssClass="dropdownStylePTR" AutoPostBack="True">

</asp:DropDownList>

</td>

<%-- <td width="10%">

<asp:Button ID="btnExport2Excel" runat="server" Text="Export Activiites to Excel"

CssClass="buttonStyle" Visible="True" />

<br />

</td>--%>

</tr>

</table>

</div>

<br />

<telerik:RadAjaxPanel ID="radAjaxMainPanel" runat="server" LoadingPanelID="RadAjaxLoadingPanel1"

ClientEvents-OnRequestStart="onRequestStart">

<div id="divCont02" style="display: block; width: 99%">

<table style="width: 100%;">

<tr>

<td style="vertical-align: top; padding-top: 0px; padding-bottom: 0px; padding-left: 0px;

border-top-width: 0px;">

<telerik:RadGrid ID="RadGrid1" runat="server" AllowPaging="True" AllowSorting="True"

Skin="Office2007" AllowFilteringByColumn="True" ShowStatusBar="false" PageSize="12"

Width="95%">

<PagerStyle Mode="NextPrevNumericAndAdvanced" AlwaysVisible="true" />

<MasterTableView BorderWidth="0" DataKeyNames="ACT_ID" EditMode="PopUp" AutoGenerateColumns="False"

CommandItemDisplay="Top" CommandItemSettings-AddNewRecordText="Add New Activity">

<NoRecordsTemplate>

<div style="width: 300px;">

There are no records to display</div>

</NoRecordsTemplate>

<CommandItemTemplate>

<table width="100%">

<tr>

<td style="text-align: left; width: 30%">

<img style="border: 0px" alt="" src="../../Images/Telerik%20Images/AddRecord.gif" />

<asp:LinkButton ID="btnAdd" Text="Add New Activity" CommandName="InitInsert" runat="server">

</asp:LinkButton>

</td>

<td style="text-align: right;">

<asp:LinkButton runat="server" ID="LinkButton1" Text="Clear Filters" CommandName="ClearFilters" />

<img style="border: 0px" alt="" src="../../Images/Telerik%20Images/Refresh.gif" />

<asp:LinkButton ID="btnRefresh" Text="Refresh" CommandName="Rebind" runat="server">

</asp:LinkButton>

<asp:Image ID="Image1" runat="server" AlternateText="Add" ImageUrl="~/Images/Telerik Images/GridExportToExcel.gif" />

<asp:LinkButton ID="lnkBtnExportToExcel" CssClass="lnkMedium" runat="server" Text="Export to Excel"

OnClick="btnExport2Excel_Click"></asp:LinkButton>

</td>

</tr>

</table>

</CommandItemTemplate>

<Columns>

<telerik:GridButtonColumn UniqueName="EditColumn" Text="Edit" CommandName="Edit">

<ItemStyle Wrap="false" Width="42px" />

<HeaderStyle HorizontalAlign="Left" Wrap="false" Font-Size="8pt" Width="42px" />

</telerik:GridButtonColumn>

<telerik:GridButtonColumn UniqueName="DeleteColumn" Text="Delete" CommandName="Delete"

ConfirmText="Are you sure to Delete the Record?'" ConfirmDialogType="RadWindow"

ConfirmTitle="Delete">

<ItemStyle Wrap="false" Width="55px" />

<HeaderStyle HorizontalAlign="Left" Wrap="false" Font-Size="8pt" Width="55px" />

</telerik:GridButtonColumn>

<telerik:GridBoundColumn DataField="ACT_CODE" HeaderText="Act Code" SortExpression="ACT_CODE"

UniqueName="ACT_CODE" FilterListOptions="VaryByDataType" FilterControlWidth="65%">

<ItemStyle Wrap="false" Width="110px" />

<HeaderStyle HorizontalAlign="Left" Wrap="false" Font-Size="8pt" Width="110px" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ACT_DESC" HeaderText="Act Description" SortExpression="ACT_DESC"

UniqueName="ACT_DESC" FilterListOptions="VaryByDataType" FilterControlWidth="90%">

<ItemStyle Wrap="false" Width="350px" />

<HeaderStyle HorizontalAlign="Left" Wrap="false" Font-Size="8pt" Width="350px" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ACT_WF" DataType="System.Decimal" HeaderText="Act Wt.Factor"

SortExpression="ACT_WF" UniqueName="ACT_WF" FilterListOptions="VaryByDataType"

FilterControlWidth="74%">

<ItemStyle Wrap="false" Width="115px" />

<HeaderStyle HorizontalAlign="Left" Wrap="false" Font-Size="8pt" Width="115px" />

</telerik:GridBoundColumn>

<custom:rgCustomCol_Filter_Dropdown HeaderText="Department" DataField="DEPT_DESC"

SortExpression="DEPT_DESC" UniqueName="DEPT_DESC_FILTER" HeaderStyle-HorizontalAlign="Center">

<ItemStyle Wrap="false" Width="142px" />

<HeaderStyle HorizontalAlign="Left" Wrap="false" Font-Size="8pt" Width="142px" />

</custom:rgCustomCol_Filter_Dropdown>

<custom:rgCustomCol_Filter_Dropdown HeaderText="Milestone" DataField="MLSTN_NAME"

SortExpression="MLSTN_NAME" UniqueName="MLSTN_NAME_FILTER">

<ItemStyle Wrap="false" Width="499px" />

<HeaderStyle HorizontalAlign="Left" Wrap="false" Font-Size="8pt" Width="499px" />

</custom:rgCustomCol_Filter_Dropdown>

<telerik:GridDateTimeColumn DataField="ACT_EARLY_START_DT" HeaderText="Early Start Dt"

SortExpression="ACT_EARLY_START_DT" UniqueName="ACT_EARLY_START_DT" FilterControlWidth="75%"

DataFormatString="{0:dd/MM/yyyy}">

<ItemStyle Wrap="false" Width="105px" />

<HeaderStyle HorizontalAlign="Left" Wrap="false" Font-Size="8pt" Width="105px" />

</telerik:GridDateTimeColumn>

<telerik:GridDateTimeColumn DataField="ACT_EARLY_FINISH_DT" DataFormatString="{0:dd/MM/yyyy}"

DataType="System.DateTime" HeaderText="Early Finish Dt" SortExpression="ACT_EARLY_FINISH_DT"

UniqueName="ACT_EARLY_FINISH_DT" FilterListOptions="VaryByDataType" FilterControlWidth="75%"

PickerType="DatePicker">

<ItemStyle Wrap="false" Width="105px" />

<HeaderStyle HorizontalAlign="Left" Wrap="false" Font-Size="8pt" Width="105px" />

</telerik:GridDateTimeColumn>

<telerik:GridBoundColumn DataField="ACT_EARNED_WT" DataType="System.Decimal" HeaderText="Earned Wt"

SortExpression="ACT_EARNED_WT" UniqueName="ACT_EARNED_WT" FilterListOptions="VaryByDataType"

FilterControlWidth="50%">

<ItemStyle Wrap="false" Width="82px" />

<HeaderStyle HorizontalAlign="Left" Wrap="false" Font-Size="8pt" Width="82px" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ACT_PROGRESS_PERC" DataType="System.Decimal"

HeaderText="% Prog." SortExpression="ACT_PROGRESS_PERC" UniqueName="ACT_PROGRESS_PERC"

FilterListOptions="VaryByDataType" FilterControlWidth="50%">

<ItemStyle Wrap="false" Width="65px" />

<HeaderStyle HorizontalAlign="Left" Wrap="false" Font-Size="8pt" Width="65px" />

</telerik:GridBoundColumn>

<telerik:GridDateTimeColumn DataField="Start_DT1" HeaderText="Start DT1" SortExpression="Start_DT1"

UniqueName="Start_DT1" FilterControlWidth="75%" DataFormatString="{0:dd/MM/yyyy}">

<ItemStyle Wrap="false" Width="78px" />

<HeaderStyle HorizontalAlign="Left" Wrap="false" Font-Size="8pt" Width="78px" />

</telerik:GridDateTimeColumn>

<telerik:GridDateTimeColumn DataField="END_DT1" HeaderText="End DT1" SortExpression="END_DT1"

UniqueName="END_DT1" ItemStyle-Wrap="true" FilterControlWidth="75%" DataFormatString="{0:dd/MM/yyyy}">

<ItemStyle Wrap="false" Width="78px" />

<HeaderStyle HorizontalAlign="Left" Wrap="false" Font-Size="8pt" Width="78px" />

</telerik:GridDateTimeColumn>

<telerik:GridDateTimeColumn DataField="Start_DT2" HeaderText="Start DT2" SortExpression="Start_DT2"

UniqueName="Start_DT2" FilterControlWidth="75%" DataFormatString="{0:dd/MM/yyyy}">

<ItemStyle Wrap="false" Width="78px" />

<HeaderStyle HorizontalAlign="Left" Wrap="false" Font-Size="8pt" Width="78px" />

</telerik:GridDateTimeColumn>

<telerik:GridDateTimeColumn DataField="END_DT2" HeaderText="End DT2" SortExpression="END_DT2"

UniqueName="END_DT2" FilterControlWidth="75%" DataFormatString="{0:dd/MM/yyyy}">

<ItemStyle Wrap="false" Width="78px" />

<HeaderStyle HorizontalAlign="Left" Wrap="false" Font-Size="8pt" Width="78px" />

</telerik:GridDateTimeColumn>

<telerik:GridDateTimeColumn DataField="Start_DT3" HeaderText="Start DT3" SortExpression="Start_DT3"

UniqueName="Start_DT3" FilterControlWidth="75%" DataFormatString="{0:dd/MM/yyyy}">

<ItemStyle Wrap="false" Width="78px" />

<HeaderStyle HorizontalAlign="Left" Wrap="false" Font-Size="8pt" Width="78px" />

</telerik:GridDateTimeColumn>

<telerik:GridDateTimeColumn DataField="END_DT3" HeaderText="End DT3" SortExpression="END_DT3"

UniqueName="END_DT3" FilterControlWidth="75%" DataFormatString="{0:dd/MM/yyyy}">

<ItemStyle Wrap="false" Width="78px" />

<HeaderStyle HorizontalAlign="Left" Wrap="false" Font-Size="8pt" Width="78px" />

</telerik:GridDateTimeColumn>

<telerik:GridBoundColumn DataField="WBS_Code" HeaderText="WBS Code" SortExpression="WBS_Code"

UniqueName="WBS_Code" FilterControlWidth="75%">

<ItemStyle Wrap="false" Width="100px" />

<HeaderStyle HorizontalAlign="Left" Wrap="false" Font-Size="8pt" Width="100px" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ServiceMH" HeaderText="ServiceMH" SortExpression="ServiceMH"

UniqueName="ServiceMH" FilterControlWidth="75%">

<ItemStyle Wrap="false" Width="100px" />

<HeaderStyle HorizontalAlign="Left" Wrap="false" Font-Size="8pt" Width="100px" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Budget_Cost" HeaderText="Budget Cost" SortExpression="Budget_Cost"

UniqueName="Budget_Cost" FilterControlWidth="75%">

<ItemStyle Wrap="false" Width="100px" />

<HeaderStyle HorizontalAlign="Left" Wrap="false" Font-Size="8pt" Width="100px" />

</telerik:GridBoundColumn>

</Columns>

<EditFormSettings PopUpSettings-Width="48%" EditFormType="Template" ColumnNumber="2"

CaptionDataField="ACT_CODE" EditColumn-HeaderText="Activity Details:" CaptionFormatString="{0}"

PopUpSettings-Modal="true">

<FormTemplate>

<table id="Table1" width="100%" cellspacing="1" cellpadding="1" border="0">

<tr>

<td>

Activity Code:

</td>

<td>

<asp:TextBox ID="txtActCode" runat="server" Text='<%# Eval("ACT_CODE") %>' MaxLength="20"

Width="80" TabIndex="1" CssClass="textboxStyle">

</asp:TextBox>

<span id="spanrfd1" style="color: red;">*</span>

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

ErrorMessage="Activity Code is required!!" runat="server" Display="Dynamic" Text="*">

</asp:RequiredFieldValidator>

</td>

</tr>

<tr>

<td>

Description:

</td>

<td>

<asp:TextBox ID="txtActDesc" runat="server" Text='<%# Eval("ACT_DESC") %>' TabIndex="2"

MaxLength="255" Width="255" CssClass="multitextboxStyle" TextMode="MultiLine">

</asp:TextBox>

<span id="span1" style="color: red;">*</span>

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

ErrorMessage="Activity Description is required!!" runat="server" Display="Dynamic"

Text="*">

</asp:RequiredFieldValidator>

</td>

</tr>

<tr>

<td>

Weight Factor:

</td>

<td>

<asp:TextBox ID="txtActWf" runat="server" Text='<%# Eval("ACT_WF") %>' MaxLength="9"

Width="60" TabIndex="3" CssClass="textboxStyle">

</asp:TextBox>

<span id="span2" style="color: red;">*</span>

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

ErrorMessage="Activity Weight Factor is required!!" runat="server" Display="Dynamic"

Text="*">

</asp:RequiredFieldValidator>

<asp:CompareValidator runat="server" ID="comvali1" ControlToValidate="txtActWf" Type="Double"

Operator="LessThanEqual" ValueToCompare="999999999" ErrorMessage="Weight Factor Should be a Positive Number & Limited Upto 9 Digits!!"

Text="Invalid!!" Display="Dynamic"></asp:CompareValidator>

<asp:CompareValidator runat="server" ID="comvali2" ControlToValidate="txtActWf" Type="Double"

Operator="GreaterThanEqual" ValueToCompare="0" ErrorMessage="Weight Factor Should be a Positive Number & Limited Upto 9 Digits!!"

Text="Invalid!!" Display="Dynamic"></asp:CompareValidator>

</td>

</tr>

<tr>

<td>

Department:

</td>

<td>

<asp:DropDownList ID="ddlDept" runat="server" Style="z-index: 1;" SelectedValue='<%# Bind("DEPT_ID") %>'

AppendDataBoundItems="True" TabIndex="4" CssClass="dropdownStyle">

<asp:ListItem Selected="True" Text="Select" Value=""></asp:ListItem>

</asp:DropDownList>

<span id="span3" style="color: red;">*</span>

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

ErrorMessage="Department is required!!" runat="server" Display="Dynamic" Text="*">

</asp:RequiredFieldValidator>

</td>

</tr>

<tr>

<td>

MileStone:

</td>

<td>

<asp:DropDownList ID="ddlMileStone" runat="server" SelectedValue='<%# Bind("MLSTN_ID") %>'

AppendDataBoundItems="True" TabIndex="5" CssClass="dropdownStyle">

<asp:ListItem Selected="True" Text="Select" Value=""></asp:ListItem>

</asp:DropDownList>

<span id="span4" style="color: red;">*</span>

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

ErrorMessage="Milestone is required!!" runat="server" Display="Dynamic" Text="*">

</asp:RequiredFieldValidator>

</td>

</tr>

<tr>

<td>

Early Start Date:

</td>

<td>

<%--SelectedDate='<%# IIF (TypeOf Container is GridEditFormInsertItem, Now.Today , Eval("ACT_EARLY_START_DT")) %>'--%>

<telerik:RadDatePicker ID="RdpESdt" runat="server"

SelectedDate='<%# IIf(TypeOf Container Is GridEditFormInsertItem, Now.Today, IIf(IsDBNull(Eval("ACT_EARLY_START_DT")), Nothing, Eval("ACT_EARLY_START_DT"))) %>'>

<DateInput ID="DateInput2" runat="server" TabIndex="6" DateFormat="dd/MM/yyyy">

</DateInput>

</telerik:RadDatePicker>

<%-- <span id="span5" style="color: red;">*</span>

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

ErrorMessage="Early Start Date is required" runat="server" Display="Dynamic"

Text="*">

</asp:RequiredFieldValidator>--%>

</td>

</tr>

<tr>

<td>

Early Finish Date:

</td>

<td>

<telerik:RadDatePicker ID="RdpEFdt" runat="server" TabIndex="7"

SelectedDate='<%# IIf(TypeOf Container Is GridEditFormInsertItem, Now.Today, IIf(IsDBNull(Eval("ACT_EARLY_FINISH_DT")), Nothing, Eval("ACT_EARLY_FINISH_DT"))) %>'>

<DateInput ID="DateInput1" runat="server" DateFormat="dd/MM/yyyy">

</DateInput>

</telerik:RadDatePicker>

<%-- <span id="span6" style="color: red;">*</span>

<asp:RequiredFieldValidator ID="RequiredFieldValidator7" ControlToValidate="RdpEFdt"

ErrorMessage="Early Finish Date is required!!" runat="server" Display="Dynamic"

Text="*">

</asp:RequiredFieldValidator>

<asp:CompareValidator ID="CompareValidator1" runat="server" ErrorMessage="Early Finish Date Should be More than Early Start Date!!"

ControlToCompare="RdpESdt" ControlToValidate="RdpEFdt" Operator="GreaterThan"

Text="Invalid!!" Display="Dynamic"> </asp:CompareValidator>--%>

</td>

</tr>

</table>

<table style="width: 100%">

<tr>

<td style="text-align: center" colspan="2">

<asp:Button ID="Button1" Text='<%# IIF (TypeOf Container is GridEditFormInsertItem, "Insert", "Update") %>'

runat="server" CommandName='<%# Iif (TypeOf Container is GridEditFormInsertItem, "PerformInsert", "Update") %>'

CssClass="gridButtonColStyle"></asp:Button>

<asp:Button ID="Button2" Text="Cancel" runat="server" CausesValidation="False" CommandName="Cancel"

CssClass="gridButtonColStyle"></asp:Button>

</td>

</tr>

</table>

<asp:ValidationSummary ID="ValidationSummary1" runat="server" ShowMessageBox="true"

ShowSummary="false" />

</FormTemplate>

<PopUpSettings Modal="True"></PopUpSettings>

</EditFormSettings>

</MasterTableView>

<HeaderStyle Height="1%" />

<ValidationSettings CommandsToValidate="PerformInsert,Update" />

<StatusBarSettings LoadingText="Loading... Please wait!" ReadyText="Ready.." />

<ExportSettings>

<Pdf FontType="Subset" PaperSize="Letter" />

<Excel Format="ExcelML" FileExtension=".xls" />

<Csv ColumnDelimiter="Colon" RowDelimiter="NewLine" />

</ExportSettings>

<ClientSettings AllowColumnsReorder="True">

<Selecting AllowRowSelect="True" />

<Scrolling AllowScroll="true" SaveScrollPosition="true" UseStaticHeaders="True" ScrollHeight="250px" />

<%-- <Resizing AllowColumnResize="true" />--%>

</ClientSettings>

<FilterMenu EnableTheming="True">

<CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation>

</FilterMenu>

</telerik:RadGrid>

</td>

</tr>

</table>

</div>

</telerik:RadAjaxPanel>

<telerik:RadAjaxPanel ID="PanelStatusLabel" runat="server">

</telerik:RadAjaxPanel>

</asp:Content>

RadGrid Working Slow When Clicked on Edit/Update/Cancel Buttons or Export to Excel

1 Answer, 1 is accepted