or
Page is taking almost 15 seconds to save data.
<%@ OutputCache Duration="10" VaryByParam="none" %><%@ Page Title="" Language="VB" MasterPageFile="~/MasterPages/AdminMaster.master" EnableEventValidation="false" AutoEventWireup="false" CodeFile="EmployeeDeductions.aspx.vb" Inherits="Admin_EmployeeDeductions" %><%@ Register Src="~/ECZ_FooterMessage.ascx" TagName="FooterMessage" TagPrefix="Ecz" %><asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server"> <asp:UpdatePanel ID="UpdatePanel1" runat="server"> <ContentTemplate> <Ecz:FooterMessage ID="msg" runat="server" /> <table width="378" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="30" align="left" valign="top"> <img src="../images/top_left.jpg" width="30" height="43" /> </td> <td align="left" valign="middle" id="top_bg"> <asp:Label ID="lblHeading" runat="server" Text=" Employee Deductions" CssClass="heading"></asp:Label> </td> <td width="30" align="right" valign="top"> <img src="../images/top_right.jpg" width="30" height="43" /> </td> </tr> <tr> <td align="left" valign="top"> </td> <td align="left" valign="top"> <img src="../images/top_shadow.jpg" width="322" height="16" /> </td> <td align="right" valign="top"> </td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="right"> Date: </td> <td> <telerik:RadDatePicker ID="radDate_cr" runat="server"> </telerik:RadDatePicker> <asp:Button ID="btnSearch" runat="server" Text="Search" /> </td> <td> <asp:Button ID="btnPost" runat="server" Text="Post" /> </td> </tr> <tr> <td> </td> <td align="center"> <br /> <br /> </td> </tr> </table> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td> <telerik:RadGrid ID="grdEmployeeDeductions" AllowSorting="True" runat="server" AllowFilteringByColumn="True" ShowStatusBar="True" GridLines="None" AutoGenerateColumns="False" Visible="false" Width="100%"> <MasterTableView DataKeyNames="E_EmployeeContract_ID_PK" ClientDataKeyNames="E_EmployeeContract_ID_PK"> <Columns> <telerik:GridTemplateColumn DataField="E_EmployeeContract_ID_FK" HeaderText="Employee"> <ItemTemplate> <asp:Label ID="lblE_EmployeeContract_ID_FK" runat="server" Text='<%# Eval("E_EmployeeContract_ID_PK") %>' Visible="false"></asp:Label> <asp:Label ID="lblEmployeeName" runat="server" Text='<%# Eval("E_EmployeeName") %>'></asp:Label> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn DataField="Company" HeaderText="Company"> <ItemTemplate> <asp:Label ID="lblCompanyID" runat="server" Text='<%# Eval("E_Company_ID_FK") %>' Visible="false"></asp:Label> <asp:Label ID="lblCompany" runat="server" Text='<%# Eval("CompanyName") %>'></asp:Label> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn DataField="Department" HeaderText="Department" UniqueName="Department"> <ItemTemplate> <asp:Label ID="lblDepartmentID" runat="server" Text='<%# Eval("E_Department_ID_FK") %>' Visible="false"></asp:Label> <asp:Label ID="lblDepartment" runat="server" Text='<%# Eval("DepartmentName") %>'></asp:Label> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn DataField="GOSI" HeaderText="GOSI" UniqueName="GOSI" FilterControlWidth="50px"> <ItemTemplate> <asp:TextBox ID="txtGOSI" runat="server" Text='<%# Eval("gosi") %>' Width="50px"></asp:TextBox> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="GOSI Account"> <ItemTemplate> <telerik:RadComboBox ID="cmbGOSIAccount" runat="server" OnDataBound="CmbAccountDataBound1" Filter="Contains"> </telerik:RadComboBox> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn DataField="Social" HeaderText="Social" FilterControlWidth="50px"> <ItemTemplate> <asp:TextBox ID="txtSocial_Deduction" runat="server" Width="50px" Text='<%# Eval("Social_deduction") %>'></asp:TextBox> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="Social Account"> <ItemTemplate> <telerik:RadComboBox ID="cmbSocialAccount" runat="server" OnDataBound="CmbAccountDataBound1" Filter="Contains"> </telerik:RadComboBox> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn DataField="Advance" HeaderText="Advance" FilterControlWidth="50px"> <ItemTemplate> <asp:TextBox ID="txtAdvance" runat="server" Width="50px" Text='<%# Eval("Advance") %>'></asp:TextBox> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="advance account"> <ItemTemplate> <telerik:RadComboBox ID="RadComboAdv" runat="server" OnDataBound="CmbAccountDataBound1"> </telerik:RadComboBox> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn DataField="Absent" HeaderText="Absent" FilterControlWidth="50px"> <ItemTemplate> <asp:TextBox ID="txtAbsent" runat="server" Width="50px" Text='<%# Eval("Absent") %>'></asp:TextBox> </ItemTemplate> </telerik:GridTemplateColumn> <telerik:GridTemplateColumn HeaderText="absent account"> <ItemTemplate> <telerik:RadComboBox ID="RadComboBoxAbsnt" runat="server" OnDataBound="CmbAccountDataBound1"> </telerik:RadComboBox> </ItemTemplate> </telerik:GridTemplateColumn> </Columns> </MasterTableView> </telerik:RadGrid> </td> </tr> <tr> <td> <br> </td> </tr> <tr> <td align="center"> <asp:Button ID="btnSave" runat="server" Text="Save" Visible="false"/> <%--<asp:Button ID="btnSave" runat="server" Text="Save" Visible="False" OnClientClick="return verify_form('form',0)" /> --%> </td> </tr> <tr> <td> <asp:UpdateProgress ID="UpdateProgress1" runat="server"> <ProgressTemplate> <img src="../images/wait.gif" alt="dd" /> </ProgressTemplate> </asp:UpdateProgress> </td> </tr> </table> </ContentTemplate> </asp:UpdatePanel></asp:Content>protected void rdbtnYes_Click(object sender, EventArgs e) { foreach (GridDataItem item in RadGrid2.MasterTableView.Items) { if (item.IsInEditMode && item is GridEditableItem) { if (item.OwnerTableView.IsItemInserted) { item.Edit = true; } } //item.Edit = true; } RadGrid2.Rebind(); rdwmdw1.Windows[0].VisibleOnPageLoad = false; }protected void RadGrid2_ItemDataBound(object sender, GridItemEventArgs e) { int iPagecount = RadGrid2.MasterTableView.CurrentPageIndex; if (e.Item is GridDataItem) { if (iPagecount == 0) { if (e.Item.ItemIndex != 0) { GridDataItem item = (GridDataItem)e.Item; ImageButton imageButton = (ImageButton)item["imgEdit"].Controls[0]; imageButton.Visible = false; //imageButton.ImageUrl = "images/MailOk.png"; } else { GridDataItem item = (GridDataItem)e.Item; ImageButton imageButton = (ImageButton)item["imgEdit"].Controls[0]; imageButton.Visible = true; } } else { GridDataItem item = (GridDataItem)e.Item; ImageButton imageButton = (ImageButton)item["imgEdit"].Controls[0]; imageButton.Visible = false; } } if (e.Item is GridEditableItem && e.Item.IsInEditMode) { GridEditableItem item = e.Item as GridEditableItem; mlocal_strStoredProcName = StoredProcNames.Gender_uspGenderGetList; oEmployeePersonalData.Select(out mlocal_ds, mlocal_strStoredProcName); Label lblStatus = (Label)item.FindControl("lblApprovalStatus1"); if (lblStatus.Text == "Y") { if (!e.Item.OwnerTableView.IsItemInserted) { Label LBL1 = (Label)item.FindControl("lblMaritalStatus"); RadComboBox rdcmbGender = (RadComboBox)item.FindControl("rdcbGender"); rdcmbGender.DataSource = mlocal_ds; rdcmbGender.DataTextField = TablesAndColumns.tblGender_GenderDesc; rdcmbGender.DataValueField = TablesAndColumns.tblGender_GenderTypeID; rdcmbGender.SelectedValue = (string)DataBinder.Eval(e.Item.DataItem, "MaritalTypeID").ToString(); //rdcmbGender.SelectedValue = LBL1.Text; rdcmbGender.DataBind(); mlocal_strStoredProcName = USADAO.StoredProcNames.PayFrequency_uspPayFrequencySelect; oEmployee.FedTaxID = Session["FedTaxID"].ToString(); oEmployee.Select(out mlocal_ds, mlocal_strStoredProcName); RadComboBox ddlPayFrequencytype = (RadComboBox)item.FindControl("rdcbPayFrequency"); ddlPayFrequencytype.DataSource = mlocal_ds; ddlPayFrequencytype.DataTextField = "PayFrequencyDesc"; ddlPayFrequencytype.DataValueField = "PayFrequencyType"; ddlPayFrequencytype.DataBind(); ddlPayFrequencytype.Enabled = false; mlocal_ds.Clear(); RadDatePicker radDtStartDate = item.FindControl("radDtStartDate") as RadDatePicker; RadDatePicker radDtEndDate = item.FindControl("radDtEndDate") as RadDatePicker; strDate = radDtStartDate.SelectedDate.Value; EndDt = radDtEndDate.SelectedDate.Value; } } else { e.Item.Edit = false; rdwmdw1.Windows[0].VisibleOnPageLoad = true; } } }