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

RadGrid insert/update extremely slow

7 Answers 111 Views

Grid

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

7 Answers, 1 is accepted

answered on 26 May 2011, 12:20 AM

<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="VertigoProductions.aspx.cs" Inherits="Sales_Order_VertigoProductions" %>

<%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %>

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

<telerik:RadScriptBlock runat="server">

<script type="text/javascript">

function SelectGrdComputerRow(index) {

var grid = $find('<%= grdComputers.ClientID %>');

var MasterTable = grid.get_masterTableView();

for (var i = 0; i < MasterTable.get_dataItems().length; i++)

{

MasterTable.get_dataItems()[i].set_selected(false);

}

MasterTable.get_dataItems()[index].set_selected(true);

}

function txtMajorVersion_ValueChanged(sender, args) {

var txtMinorVersion = $find(sender._clientID.replace("txtMajorVersion", "txtMinorVersion"));

if (args._newValue > 4) {

txtMinorVersion.set_maxValue(999);

txtMinorVersion.set_minValue(0);

}

else {

txtMinorVersion.set_maxValue(7);

txtMinorVersion.set_minValue(7);

txtMinorVersion.set_value(7);

}

</script>

</telerik:RadScriptBlock>

<telerik:RadAjaxLoadingPanel id="RadAjaxLoadingPanel1" Runat="server" HorizontalAlign="Center"></telerik:RadAjaxLoadingPanel>

<telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" LoadingPanelID="RadAjaxLoadingPanel1" HorizontalAlign="Center" Width="100%">

<div class="pagetitle">Vertigo Production Key Manager</div>

<asp:CustomValidator ID="CustomValidator1" runat="server" ErrorMessage="" Visible="false" ValidationGroup="ComputerValidation"></asp:CustomValidator>

<asp:CustomValidator ID="CustomValidator2" runat="server" ErrorMessage="" Visible="false" ValidationGroup="FeatureValidation"></asp:CustomValidator>

<asp:ValidationSummary ID="ValidationSummary1" runat="server" Width="100%" ValidationGroup="ComputerValidation" ForeColor="" />

<telerik:RadGrid ID="grdComputers" runat="server"

AllowFilteringByColumn="True" AllowSorting="True"

DataSourceID="ObjectDataSourceVertigoComputers" GridLines="None"

EnableTheming="False" AllowAutomaticDeletes="True" AllowAutomaticInserts="True"

AllowAutomaticUpdates="True" AutoGenerateColumns="False"

DataKeyNames="ComputerID, DongleRequired, Comment" Height="700px" Width="100%"

onitemcommand="grdComputers_ItemCommand" OnItemCreated="grdComputers_ItemCreated" OnItemDataBound="grdComputers_ItemDataBound"

PageSize="25" AllowPaging="True">

<PagerStyle Mode="NumericPages" />

<MasterTableView DataKeyNames="ComputerID,ComputerName,CustomerName" autogeneratecolumns="false" CommandItemDisplay="Top" DataSourceID="ObjectDataSourceVertigoComputers" ExpandCollapseColumn-HeaderStyle-Width="40px" ExpandCollapseColumn-HeaderText="Features">

<NoRecordsTemplate>No Rows</NoRecordsTemplate>

<CommandItemTemplate>

<telerik:RadToolBar ID="RadToolBar1" runat="server" Width="100%" AutoPostBack="true">

<Items>

<telerik:RadToolBarButton Text="Add new record" CommandName="InitInsert" ImageUrl="~/images/grid/Add.gif"></telerik:RadToolBarButton>

<telerik:RadToolBarButton Text="Refresh" CommandName="RebindGrid" ImageUrl="~/images/grid/Refresh.gif"></telerik:RadToolBarButton>

</Items>

</telerik:RadToolBar>

</CommandItemTemplate>

<Columns>

<telerik:GridBoundColumn DataField="ComputerID" HeaderText="Computer ID" Visible="false"></telerik:GridBoundColumn>

<telerik:GridEditCommandColumn ButtonType="ImageButton" InsertImageUrl="~/images/icons/icon_edit.png">

<HeaderStyle Width="15px" />

</telerik:GridEditCommandColumn>

<telerik:GridButtonColumn ButtonType="ImageButton" CommandName="Delete" UniqueName="DeleteColumn"

ImageUrl="~/images/icons/icon_delete.png" Text="Delete" >

<HeaderStyle Width="15px" />

</telerik:GridButtonColumn>

<telerik:GridBoundColumn DataField="CustomerName" FilterControlWidth="30%" HeaderText="Customer Name" SortExpression="CustomerName">

<HeaderStyle Width="30%" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ComputerName" FilterControlWidth="30%" HeaderText="Computer Description" SortExpression="ComputerName">

<HeaderStyle Width="30%" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="DongleID" FilterControlWidth="30%" HeaderText="Machine or Dongle ID" SortExpression="DongleID">

<HeaderStyle Width="30%" />

</telerik:GridBoundColumn>

</Columns>

<EditFormSettings EditFormType="Template" >

<EditColumn UniqueName="EditColumn">

</EditColumn>

<FormTemplate>

<asp:Panel ID="Panel2" runat="server">

<table ID="Table2" border="0" cellpadding="1" cellspacing="2">

<tr>

<td>

Customer Name :</td>

<td>

<asp:DropDownList ID="cmbCustomerName" runat="server" OnDataBinding="cmbCustomerName_DataBinding"

SelectedValue='<%# Bind("CustomerName") == System.DBNull.Value ? String.Empty : Bind("CustomerName") %>' Width="250px">

<asp:ListItem Value="">--- Select ---</asp:ListItem>

</asp:DropDownList>

<asp:RequiredFieldValidator runat="server" ErrorMessage="Field Required."

ControlToValidate="cmbCustomerName" Display="Dynamic" />

</td>

</tr>

<tr>

<td>

Computer Description :</td>

<td>

<asp:TextBox ID="txtComputerName" runat="server"

Text='<%# Bind("ComputerName") %>' Width="250px"></asp:TextBox>

<asp:RequiredFieldValidator runat="server" ErrorMessage="Field Required."

ControlToValidate="txtComputerName" Display="Dynamic" />

</td>

</tr>

<tr>

<td>

Machine or Dongle ID :</td>

<td>

<asp:TextBox ID="txtDongleID" runat="server"

Text='<%# Bind("DongleID") %>' Width="250px"></asp:TextBox>

<asp:RequiredFieldValidator runat="server" ErrorMessage="Field Required."

ControlToValidate="txtDongleID" Display="Dynamic" />

</td>

</tr>

<tr>

<td>

Major Version :</td>

<td>

<telerik:RadNumericTextBox ID="txtMajorVersion" runat="server" OnDataBinding="txtMajorVersion_DataBinding"

DataType="System.Int32" DbValue='<%# Bind("MajorVersion") %>'

IncrementSettings-InterceptArrowKeys="true"

IncrementSettings-InterceptMouseWheel="true" MinValue="4"

ShowSpinButtons="true" Width="100px">

<ClientEvents OnValueChanged="txtMajorVersion_ValueChanged" />

<NumberFormat DecimalDigits="0" />

</telerik:RadNumericTextBox>

<asp:RequiredFieldValidator runat="server" ErrorMessage="Field Required."

ControlToValidate="txtMajorVersion" Display="Dynamic" />

<asp:Label runat="server" Font-Italic="true" ForeColor="red">Productions can only be generated for versions 4.7 and above</asp:Label>

</td>

</tr>

<tr>

<td>

Minor Version :</td>

<td>

<telerik:RadNumericTextBox ID="txtMinorVersion" runat="server" OnDataBinding="txtMinorVersion_DataBinding"

DataType="System.Int32" DbValue='<%# Bind("MinorVersion") %>'

IncrementSettings-InterceptArrowKeys="true" MinValue="7" MaxValue="7"

IncrementSettings-InterceptMouseWheel="true" Label="" ShowSpinButtons="true"

Width="100px">

<NumberFormat DecimalDigits="0" />

</telerik:RadNumericTextBox>

<asp:RequiredFieldValidator runat="server" ErrorMessage="Field Required."

ControlToValidate="txtMinorVersion" Display="Dynamic" />

</td>

</tr>

<tr>

<td>

Comment :</td>

<td>

<asp:TextBox ID="txtComment" runat="server" Rows="5"

TextMode="MultiLine" Width="250px" OnDataBinding="txtComment_DataBinding" Text='<%# Bind("Comment")%>'></asp:TextBox>

</td>

</tr>

<tr>

<td align="right" colspan="2">

<asp:LinkButton ID="btnUpdate" runat="server" CausesValidation="True"

CommandName='<%# (Container is GridEditFormInsertItem) ? "PerformInsert" : "Update" %>'

Width="100px"><span><img

style="border:0px;vertical-align:middle;" alt=""

src="../../images/icons/icon_save.png" /> <%# (Container is GridEditFormInsertItem) ? "Insert" : "Update" %></span></asp:LinkButton>

<asp:LinkButton ID="btnCancel" runat="server" CausesValidation="False"

CommandName="Cancel" Width="100px"><span><img

style="border:0px;vertical-align:middle;" alt=""

src="../../images/icons/icon_cancel.png" /> Cancel</span></asp:LinkButton>

</td>

</tr>

</table>

</asp:Panel>

</FormTemplate>

</EditFormSettings>

<NestedViewTemplate>

<asp:Panel runat="server" ID="InnerContainer" Visible="false">

<telerik:RadTabStrip runat="server" ID="TabStip1" MultiPageID="Multipage1" SelectedIndex="0">

<Tabs>

<telerik:RadTab runat="server" Text="Features" PageViewID="PageView1" ImageUrl="~/images/icons/icon_key.gif"></telerik:RadTab>

<telerik:RadTab runat="server" Text="Computer History" PageViewID="PageView2" ImageUrl="~/images/icons/icon_history.png"></telerik:RadTab>

</Tabs>

</telerik:RadTabStrip>

<asp:ValidationSummary ID="ValidationSummary2" runat="server" Width="100%" ValidationGroup="FeatureValidation" ForeColor="Red" />

<telerik:RadMultiPage runat="server" ID="Multipage1" SelectedIndex="0" RenderSelectedPageOnly="false" >

<telerik:RadPageView runat="server" ID="PageView1">

<telerik:RadGrid ID="grdProductions" runat="server" AllowAutomaticDeletes="True" Height="500px"

AllowAutomaticInserts="True" AllowAutomaticUpdates="True"

AutoGenerateColumns="false" CommandItemDisplay="Top" DataKeyNames="FeatureID" OnDataBound="grdProductions_DataBound"

DataSourceID="ObjectDataSourceProductions" OnItemCommand="grdProductions_ItemCommand" OnItemDataBound="grdProductions_ItemDataBound">

<PagerStyle Mode="NumericPages" />

<MasterTableView DataKeyNames="FeatureID" autogeneratecolumns="false" CommandItemDisplay="Top" DataSourceID="ObjectDataSourceProductions" ExpandCollapseColumn-HeaderStyle-Width="40px" ExpandCollapseColumn-HeaderText="History">

<NoRecordsTemplate>No Rows</NoRecordsTemplate>

<CommandItemTemplate>

<telerik:RadToolBar ID="RadToolBar1" runat="server" Width="100%" AutoPostBack="true">

<Items>

<telerik:RadToolBarButton Text="Add new record" CommandName="InitInsert" ImageUrl="~/images/grid/Add.gif"></telerik:RadToolBarButton>

<telerik:RadToolBarButton Text="Generate Keys" CommandName="Generate" ImageUrl="~/images/icons/icon_key.gif"></telerik:RadToolBarButton>

<telerik:RadToolBarButton Text="Refresh" CommandName="RebindGrid" ImageUrl="~/images/grid/Refresh.gif"></telerik:RadToolBarButton>

</Items>

</telerik:RadToolBar>

</CommandItemTemplate>

<Columns>

<telerik:GridBoundColumn DataField="FeatureID" HeaderText="Feature ID" Visible="false" SortExpression="FeatureID"></telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ComputerID" HeaderText="Computer ID" Visible="false" SortExpression="ComputerID"></telerik:GridBoundColumn>

<telerik:GridTemplateColumn DataField="IsReassign" HeaderText="Re-Assign">

<HeaderStyle Width="60px" />

<ItemStyle HorizontalAlign="Center" />

<ItemTemplate>

<asp:CheckBox ID="cbIsReassign" Checked="false" runat="server" />

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridEditCommandColumn ButtonType="ImageButton" InsertImageUrl="~/images/icons/icon_edit.png">

<HeaderStyle Width="15px" />

</telerik:GridEditCommandColumn>

<telerik:GridButtonColumn ButtonType="ImageButton" CommandName="Delete" ImageUrl="~/images/icons/icon_delete.png"

Text="Delete" UniqueName="DeleteColumn">

<HeaderStyle Width="15px" />

</telerik:GridButtonColumn>

<telerik:GridBoundColumn DataField="FeatureName" HeaderText="Feature" ReadOnly="false" SortExpression="FeatureID">

<HeaderStyle Width="70px" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ProductionType" HeaderText="Production Type" ReadOnly="True" SortExpression="ProductionType">

<HeaderStyle Width="75px" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ProductionCount" HeaderText="Production Count" ReadOnly="True" SortExpression="ProductionCount">

<HeaderStyle Width="75px" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ExpiryDate" DataFormatString="{0:yyyy-MM-dd}" DataType="System.DateTime" HeaderText="Expiry Date" ReadOnly="True" SortExpression="ExpiryDate">

<HeaderStyle Width="70px" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="UserID" HeaderText="User" ReadOnly="True" SortExpression="UserID">

<HeaderStyle Width="130px" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ModifiedDate" HeaderText="Modified Date" ReadOnly="True" SortExpression="ModifiedDate">

<HeaderStyle Width="120px" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Comment" HeaderText="Comment" ReadOnly="True" SortExpression="Comment">

</telerik:GridBoundColumn>

</Columns>

<EditFormSettings EditFormType="Template">

<EditColumn UniqueName="EditColumn">

</EditColumn>

<FormTemplate>

<asp:Panel ID="Panel2" runat="server">

<asp:HiddenField ID="hidComputerID" runat="server" Value='<%# Bind("ComputerID") %>' OnDataBinding="hidComputerID_DataBinding" />

<table ID="Table2" border="0" cellpadding="1" cellspacing="2">

<tr>

<td>

Feature :</td>

<td>

<asp:DropDownList ID="cmbFeatureID" runat="server" OnDataBinding="cmbFeatureID_DataBinding"

SelectedValue='<%# Bind("FeatureName") == System.DBNull.Value ? String.Empty : Bind("FeatureName") %>'

Width="250px">

<asp:ListItem Value="">--- Select ---</asp:ListItem>

</asp:DropDownList>

<asp:RequiredFieldValidator runat="server" ErrorMessage="Field Required."

ControlToValidate="cmbFeatureID" Display="Dynamic" />

</td>

</tr>

<tr>

<td>

Production Type :</td>

<td>

<asp:DropDownList ID="cmbProductionType" runat="server" OnDataBinding="cmbProductionType_DataBinding"

SelectedValue='<%# Bind("ProductionType") == System.DBNull.Value ? String.Empty : Bind("ProductionType") %>' Width="250px">

<asp:ListItem Value="">--- Select ---</asp:ListItem>

<asp:ListItem Value="Fixed">Fixed</asp:ListItem>

<asp:ListItem Value="Float">Float</asp:ListItem>

</asp:DropDownList>

<asp:RequiredFieldValidator runat="server" ErrorMessage="Field Required."

ControlToValidate="cmbProductionType" Display="Dynamic" />

</td>

</tr>

<tr>

<td>

Production Count :</td>

<td>

<telerik:RadNumericTextBox ID="txtProductionCount" runat="server" OnDataBinding="txtProductionCount_DataBinding"

DataType="System.Int32" DbValue='<%# Bind("ProductionCount") %>'

IncrementSettings-InterceptArrowKeys="true"

IncrementSettings-InterceptMouseWheel="true" Label="" ShowSpinButtons="true"

Width="100px" MinValue="1">

<NumberFormat DecimalDigits="0" />

</telerik:RadNumericTextBox>

<asp:RequiredFieldValidator runat="server" ErrorMessage="Field Required."

ControlToValidate="txtProductionCount" Display="Dynamic" />

</td>

</tr>

<tr>

<td>Expiry Date :</td>

<td>

<telerik:RadDatePicker ID="rdpMinDate" runat="server" Width="140px" DateInput-EmptyMessage="No Expiry" DbSelectedDate='<%# Bind("ExpiryDate") %>'>

</telerik:RadDatePicker>

</td>

</tr>

<tr>

<td valign="top">

Comment :</td>

<td>

<asp:TextBox ID="txtCommentFeature" OnDataBinding="txtCommentFeature_DataBinding" runat="server" Rows="5"

Text='<%# Bind("Comment") %>' TextMode="MultiLine" Width="250px"></asp:TextBox>

</td>

</tr>

<tr>

<td align="right" colspan="2">

<asp:LinkButton ID="btnUpdate" runat="server" CausesValidation="True"

CommandName='<%# (Container is GridEditFormInsertItem) ? "PerformInsert" : "Update" %>'

Width="100px"><span><img

style="border:0px;vertical-align:middle;" alt=""

src="../../images/icons/icon_save.png" /> <%# (Container is GridEditFormInsertItem) ? "Insert" : "Update" %></span></asp:LinkButton>

<asp:LinkButton ID="btnCancel" runat="server" CausesValidation="False"

CommandName="Cancel" Width="100px"><span><img

style="border:0px;vertical-align:middle;" alt=""

src="../../images/icons/icon_cancel.png" /> Cancel</span></asp:LinkButton>

</td>

</tr>

</table>

</asp:Panel>

</FormTemplate>

</EditFormSettings>

<DetailTables>

<telerik:GridTableView Name="FeatureHistory" runat="server" DataSourceID="ObjectDataSourceFeatureHistory"

AutoGenerateColumns="false" ItemStyle-BackColor="LightYellow" AlternatingItemStyle-BackColor="LightYellow">

<PagerStyle Mode="NumericPages"></PagerStyle>

<ParentTableRelation>

<telerik:GridRelationFields DetailKeyField="FeatureID" MasterKeyField="FeatureID" />

</ParentTableRelation>

<Columns>

<telerik:GridTemplateColumn>

<HeaderStyle Width="203px" />

<ItemStyle BackColor="#C5DAF2" />

<ItemTemplate>

</ItemTemplate>

</telerik:GridTemplateColumn>

<telerik:GridBoundColumn DataField="ProductionType" HeaderText="Production Type" ReadOnly="True" SortExpression="ProductionType">

<HeaderStyle Width="75px" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ProductionCount" HeaderText="Production Count" ReadOnly="True" SortExpression="ProductionCount">

<HeaderStyle Width="75px" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ExpiryDate" DataFormatString="{0:yyyy-MM-dd}" DataType="System.DateTime" HeaderText="Expiry Date" ReadOnly="True" SortExpression="ExpiryDate">

<HeaderStyle Width="70px" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="UserID" HeaderText="User" ReadOnly="True" SortExpression="UserID">

<HeaderStyle Width="130px" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ModifiedDate" HeaderText="Modified Date" ReadOnly="True" SortExpression="ModifiedDate">

<HeaderStyle Width="120px" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Comment" HeaderText="Comment" ReadOnly="True" SortExpression="Comment">

</telerik:GridBoundColumn>

</Columns>

</telerik:GridTableView >

</DetailTables>

</MasterTableView>

<ClientSettings EnableRowHoverStyle="false" EnablePostBackOnRowClick="false">

<Resizing AllowColumnResize="true" EnableRealTimeResize="true" />

<Selecting AllowRowSelect="true" />

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

</ClientSettings>

<GroupingSettings ShowUnGroupButton="true" CaseSensitive="false" />

</telerik:RadGrid>

</telerik:RadPageView>

<telerik:RadPageView runat="server" ID="RadPageView2">

<telerik:RadGrid ID="grdHistory" runat="server" AllowAutomaticDeletes="True" Height="500px"

AllowAutomaticInserts="True" AllowAutomaticUpdates="True"

AutoGenerateColumns="false" DataKeyNames="ComputerID"

DataSourceID="ObjectDataSourceHistory">

<PagerStyle Mode="NumericPages" />

<MasterTableView DataKeyNames="ComputerID" autogeneratecolumns="false" DataSourceID="ObjectDataSourceHistory">

<Columns>

<telerik:GridBoundColumn DataField="ComputerName" FilterControlWidth="230px" HeaderText="Computer Description" SortExpression="ComputerName">

<HeaderStyle Width="10%" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="DongleID" FilterControlWidth="230px" HeaderText="Machine or Dongle ID" SortExpression="DongleID">

<HeaderStyle Width="10%" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="MajorVersion" HeaderText="Major Version" ReadOnly="True" SortExpression="MajorVersion">

<HeaderStyle Width="5%" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="MinorVersion " HeaderText="Minor Version" ReadOnly="True" SortExpression="MinorVersion">

<HeaderStyle Width="5%" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="UserID" HeaderText="User" ReadOnly="True" SortExpression="UserID">

<HeaderStyle Width="10%" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="ModifiedDate" HeaderText="Modified Date" ReadOnly="True" SortExpression="ModifiedDate">

<HeaderStyle Width="10%" />

</telerik:GridBoundColumn>

<telerik:GridBoundColumn DataField="Comment" HeaderText="Comment" ReadOnly="True" SortExpression="Comment">

<HeaderStyle Width="10%" />

</telerik:GridBoundColumn>

</Columns>

</MasterTableView>

<ClientSettings EnableRowHoverStyle="false" EnablePostBackOnRowClick="true">

<Selecting AllowRowSelect="true" />

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

</ClientSettings>

<GroupingSettings ShowUnGroupButton="true" CaseSensitive="false" />

</telerik:RadGrid>

</telerik:RadPageView>

</telerik:RadMultiPage>

</asp:Panel>

</NestedViewTemplate>

</MasterTableView>

<ClientSettings EnableRowHoverStyle="false" EnablePostBackOnRowClick="false">

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

<Selecting AllowRowSelect="true" />

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

</ClientSettings>

<GroupingSettings ShowUnGroupButton="true" CaseSensitive="false" />

</telerik:RadGrid>

<telerik:RadWindowManager ID="RadWindowManager1" runat="server" />

</telerik:RadAjaxPanel>

<asp:ObjectDataSource ID="ObjectDataSourceVertigoComputers" runat="server"

SelectMethod="FindAllVertigoComputers"

InsertMethod="InsertVertigoComputer"

UpdateMethod="UpdateVertigoComputer"

DeleteMethod="DeleteVertigoComputer"

TypeName="BLL.Order.VertigoProductionBLL"

DataObjectTypeName="Entities.VertigoComputer">

</asp:ObjectDataSource>

<asp:ObjectDataSource ID="ObjectDataSourceHistory" runat="server"

SelectMethod="FindVertigoComputerHistoryByFK"

TypeName="BLL.Order.VertigoProductionBLL"

DataObjectTypeName="Entities.VertigoComputer">

<SelectParameters>

<asp:ControlParameter ControlID="grdComputers" DefaultValue="-1" Name="ComputerID" PropertyName="SelectedValue" Type="String" />

</SelectParameters>

</asp:ObjectDataSource>

<asp:ObjectDataSource ID="ObjectDataSourceProductions" runat="server"

SelectMethod="FindVertigoComputerFeaturesByFK"

InsertMethod="InsertVertigoComputerFeature"

UpdateMethod="UpdateVertigoComputerFeature"

DeleteMethod="DeleteVertigoComputerFeature"

TypeName="BLL.Order.VertigoProductionBLL"

DataObjectTypeName="Entities.VertigoFeature">

<SelectParameters>

<asp:ControlParameter ControlID="grdComputers" DefaultValue="-1" Name="ComputerID" PropertyName="SelectedValue" Type="String" />

</SelectParameters>

</asp:ObjectDataSource>

<asp:ObjectDataSource ID="ObjectDataSourceFeatureHistory" runat="server"

SelectMethod="FindVertigoComputerFeatureHistoryByFK"

TypeName="BLL.Order.VertigoProductionBLL"

DataObjectTypeName="Entities.VertigoFeature">

<SelectParameters>

<asp:Parameter Name="FeatureID" Type="String" />

</SelectParameters>

</asp:ObjectDataSource>

</asp:Content>

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting & Mocking

Automated Testing

CMS

UI/UX Tools

Debugging

Free Tools

Support and Learning

Productivity and Design Tools

RadGrid insert/update extremely slow

7 Answers, 1 is accepted