All of the other WebDataGrids on my site work correctly, with deferred update and Autocrud = False.
The WebDataGrid below correctly updates the database value by calling "WebDataGrid1_RowUpdating" in the code behind. But it's incorrectly causing a Postback whenever I move from the changed cell to another cell with the arrow key. I don't want it to postback until I click the save button, like all of my other WebDataGrid pages.
I clicked on the top cell in the format column, it went into edit mode, I typed "a" ... <Enter> ... <Down Arrow> and it posted back. What caused that Postback, and how can I stop it? I have 4 different autopostback properties set = false below, but that didn't help.
Thanks
<%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="DataPoint.aspx.cs" Inherits="Grids_DataPoint" %> <%@ Register assembly="Infragistics4.Web.v10.3, Version=10.3.20103.1013, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb" namespace="Infragistics.Web.UI.GridControls" tagprefix="ig" %> <%@ Register assembly="Infragistics4.WebUI.WebDataInput.v10.3, Version=10.3.20103.1013, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb" namespace="Infragistics.WebUI.WebDataInput" tagprefix="igtxt" %> <%@ Register assembly="Infragistics4.WebUI.WebResizingExtender.v10.3, Version=10.3.20103.1013, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb" namespace="Infragistics.WebUI" tagprefix="igui" %> <asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server"> </asp:Content> <asp:Content ID="Content2" ContentPlaceHolderID="MainContent" Runat="Server"> <igui:WebResizingExtender ID="WebDataGrid1_WebResizingExtender" runat="server" TargetControlID="Panel2" MinimumHeight=250 MinimumWidth=800 /> <asp:Panel ID="Panel2" runat="server" Height=100% Width=100% HorizontalAlign=Right> <asp:UpdatePanel ID="UpdatePanel1" runat="server"> <ContentTemplate> <igtxt:WebImageButton Width=88px AutoSubmit=true Text="Save" AccessKey="s" UnderlineAccessKey=true ID="WebImageButton1" runat="server"> </igtxt:WebImageButton> </ContentTemplate> </asp:UpdatePanel> <ig:WebDataGrid ID="WebDataGrid1" runat="server" AutoGenerateColumns="False" DataKeyFields="DataPointID" DefaultColumnWidth="55px" EnableAjax="False" Height="444px" Width="100%" onrowadding="WebDataGrid1_RowAdding" onrowsdeleting="WebDataGrid1_RowsDeleting" onrowupdating="WebDataGrid1_RowUpdating"> <EditorProviders> <ig:TextBoxProvider ID="Provider_TextBox"> </ig:TextBoxProvider> <ig:TextEditorProvider ID="Provider_TextEditor"> </ig:TextEditorProvider> <ig:DropDownProvider ID="Provider_DropDown_Boolean"> <EditorControl ID="EditorControl1" runat="server" DisplayMode="DropDownList" DataSourceID="dSrc_TrueFalseNull" TextField="Name" ValueField="Value" Font-Size="8pt"> <DropDownItemBinding TextField="Name" ValueField="Value"></DropDownItemBinding> </EditorControl> </ig:DropDownProvider> <ig:DropDownProvider ID="Provider_DropDown_Category_SubCategory"> <EditorControl ID="EditorControl2" runat="server" DisplayMode="DropDownList" DataSourceID="dSrc_Category_SubCategory" TextField="Category_SubCategory" ValueField="SubCategoryID" Font-Size="8pt"> <DropDownItemBinding TextField="Category_SubCategory" ValueField="SubCategoryID"> </DropDownItemBinding> </EditorControl> </ig:DropDownProvider> <ig:NumericEditorProvider ID="Provider_Numeric_Editor" /> <ig:DatePickerProvider ID="Provider_Date_Picker" /> <ig:MaskEditorProvider EditorControl-DataMode="AllText" EditorControl-InputMask="(###) ###-####" ID="Provider_Phone_Input"> <EditorControl InputMask="(###) ###-####" DataMode="AllText"> </EditorControl> </ig:MaskEditorProvider> <ig:DropDownProvider ID="Provider_DropDown_Alias"> <EditorControl DataKeyFields="Name" DataSourceID="dSrc_Alias" DisplayMode="DropDownList" DropDownContainerMaxHeight="200px" EnableAnimations="False" EnableDropDownAsChild="False" TextField="Name" ValueField="Value"> <DropDownItemBinding KeyField="Name" TextField="Name" ValueField="Value" /> </EditorControl> </ig:DropDownProvider> </EditorProviders> <Columns> <ig:BoundDataField DataFieldName="DataPointID" Key="DataPointID" Width="66px" DataType="System.Int32"> <Header Text="DataPoint ID" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="Name" Key="Name"> <Header Text="Name" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="IsOnReport" Key="IsOnReport" Width="66px" DataType="System.Boolean"> <Header Text="Is On Report" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="SubCategoryID" Key="SubCategoryID" Width="84px" DataType="System.Int32"> <Header Text="Community" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="Description" Key="Description" Width="84px"> <Header Text="Description" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="Question" Key="Question" Width="84px"> <Header Text="Question" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="Name_Access" Key="Name_Access" Width="99px"> <Header Text="Access Name" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="Name_Excel" Key="Name_Excel" Width="66px"> <Header Text="Excel Name" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="Name_IT_CIO_Survey" Key="Name_IT_CIO_Survey" Width="84px" Hidden="true"> <Header Text="Name (IT CIO Survey)" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="Name_Web_Survey" Key="Name_Web_Survey" Width="84px"> <Header Text="Web Survey Name" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="Format" Key="Format" Width="66px"> <Header Text="Format" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="OrderPrint" Key="OrderPrint" Width="66px" DataType="System.Decimal"> <Header Text="Print Order" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="QID1" Key="QID1" Hidden="true"> <Header Text="QID1" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="QID2" Key="QID2" Hidden="true"> <Header Text="QID2" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="OrderSort" Key="OrderSort" Width="66px" DataType="System.Decimal"> <Header Text="Sort Order" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="IsUsedByRatioFormula" Key="IsUsedByRatioFormula" DataType="System.Boolean" Width="57px"> <Header Text="Is Used By a Ratio Formula" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="IsNumeric" Key="IsNumeric" DataType="System.Boolean" Width="57px"> <Header Text="Is Numeric" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="IsPercent" Key="IsPercent" DataType="System.Boolean" Width="57px"> <Header Text="Is Percent" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="IsMoney" Key="IsMoney" DataType="System.Boolean" Width="57px"> <Header Text="Is Money" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="IsBoolean" Key="IsBoolean" DataType="System.Boolean" Width="57px"> <Header Text="Is Boolean" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="IsDate" Key="IsDate" DataType="System.Boolean" Width="57px"> <Header Text="Is Date" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="IsMedian" Key="IsMedian" DataType="System.Boolean" Width="57px"> <Header Text="Is Median" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="IsProse" Key="IsProse" DataType="System.Boolean" Width="57px"> <Header Text="Is Prose" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="IsBank" Key="IsBank" DataType="System.Boolean" Width="57px"> <Header Text="Is Bank" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="IsCreditUnion" Key="IsCreditUnion" DataType="System.Boolean" Width="57px"> <Header Text="Is Credit Union" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="IsClient" Key="IsClient" DataType="System.Boolean" Width="57px"> <Header Text="Is Client" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="IsParticipant" Key="IsParticipant" DataType="System.Boolean" Width="57px"> <Header Text="Is Participant" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="IsNullable" Key="IsNullable" DataType="System.Boolean" Width="57px"> <Header Text="Is Nullable" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="IsSubZeroForNull" Key="IsSubZeroForNull" DataType="System.Boolean" Width="57px"> <Header Text="Is Sub Zero For Null" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="IsSummedFromOtherDatapoints" Key="IsSummedFromOtherDatapoints" DataType="System.Boolean" Width="57px"> <Header Text="Is Summed From Other Datapoints" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="IsPickOne" Key="IsPickOne" DataType="System.Boolean" Width="57px"> <Header Text="Is Pick One" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="IsPickOneOrMore" Key="IsPickOneOrMore" DataType="System.Boolean" Width="57px"> <Header Text="Is Pick One or More" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="IsLookup" Key="IsLookup" DataType="System.Boolean" Hidden="true"> <Header Text="Is Money" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="IsBetterGreater" Key="IsBetterGreater" DataType="System.Boolean" Width="57px"> <Header Text="Is Better When Greater" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="IsBetterLesser" Key="IsBetterLesser" DataType="System.Boolean" Width="57px"> <Header Text="Is Better When Lesser" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="Webchoice1" Key="Webchoice1" Hidden="true"> <Header Text="Webchoice1" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="Webchoice2" Key="Webchoice2" Hidden="true"> <Header Text="Webchoice2" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="Webchoice3" Key="Webchoice3" Hidden="true"> <Header Text="Webchoice3" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="Webchoice4" Key="Webchoice4" Hidden="true"> <Header Text="Webchoice4" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="Webchoice5" Key="Webchoice5" Hidden="true"> <Header Text="Webchoice5" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="Webchoice6" Key="Webchoice6" Hidden="true"> <Header Text="Webchoice6" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="Webchoice7" Key="Webchoice7" Hidden="true"> <Header Text="Webchoice7" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="Webchoice8" Key="Webchoice8" Hidden="true"> <Header Text="Webchoice8" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="Webchoice9" Key="Webchoice9" Hidden="true"> <Header Text="Webchoice9" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="dtInserted" Key="dtInserted" DataFormatString="{0:d} {0:t}" Hidden="true" DataType="System.DateTime"> <Header Text="Inserted Date" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="strInserted" Key="strInserted" Hidden="true"> <Header Text="Inserted By" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="dtUpdated" Key="dtUpdated" DataFormatString="{0:d} {0:t}" Width="57px" DataType="System.DateTime"> <Header Text="Updated Date" /> </ig:BoundDataField> <ig:BoundDataField DataFieldName="strUpdated" Key="strUpdated" Width="57px"> <Header Text="Updated By" /> </ig:BoundDataField> </Columns> <Behaviors> <ig:EditingCore AutoCRUD="False"> <Behaviors> <ig:CellEditing> <ColumnSettings> <ig:EditingColumnSetting ColumnKey="IsNumeric" EditorID="Provider_DropDown_Boolean" /> <ig:EditingColumnSetting ColumnKey="IsProse" EditorID="Provider_DropDown_Boolean" /> <ig:EditingColumnSetting ColumnKey="IsMedian" EditorID="Provider_DropDown_Boolean" /> <ig:EditingColumnSetting ColumnKey="IsBank" EditorID="Provider_DropDown_Boolean" /> <ig:EditingColumnSetting ColumnKey="IsCreditUnion" EditorID="Provider_DropDown_Boolean" /> <ig:EditingColumnSetting ColumnKey="IsOnReport" EditorID="Provider_DropDown_Boolean" /> <ig:EditingColumnSetting ColumnKey="IsDate" EditorID="Provider_DropDown_Boolean" /> <ig:EditingColumnSetting ColumnKey="IsBoolean" EditorID="Provider_DropDown_Boolean" /> <ig:EditingColumnSetting ColumnKey="IsClient" EditorID="Provider_DropDown_Boolean" /> <ig:EditingColumnSetting ColumnKey="IsNullable" EditorID="Provider_DropDown_Boolean" /> <ig:EditingColumnSetting ColumnKey="IsParticipant" EditorID="Provider_DropDown_Boolean" /> <ig:EditingColumnSetting ColumnKey="IsSubZeroForNull" EditorID="Provider_DropDown_Boolean" /> <ig:EditingColumnSetting ColumnKey="IsSummedFromOtherDatapoints" EditorID="Provider_DropDown_Boolean" /> <ig:EditingColumnSetting ColumnKey="IsPickOne" EditorID="Provider_DropDown_Boolean" /> <ig:EditingColumnSetting ColumnKey="IsPickOneOrMore" EditorID="Provider_DropDown_Boolean" /> <ig:EditingColumnSetting ColumnKey="IsLookup" EditorID="Provider_DropDown_Boolean" /> <ig:EditingColumnSetting ColumnKey="IsPercent" EditorID="Provider_DropDown_Boolean" /> <ig:EditingColumnSetting ColumnKey="IsMoney" EditorID="Provider_DropDown_Boolean" /> <ig:EditingColumnSetting ColumnKey="IsSummedFromOtherDatapoints" EditorID="Provider_DropDown_Boolean" /> <ig:EditingColumnSetting ColumnKey="IsUsedByRatioFormula" EditorID="Provider_DropDown_Boolean" /> <ig:EditingColumnSetting ColumnKey="IsBetterLesser" EditorID="Provider_DropDown_Boolean" /> <ig:EditingColumnSetting ColumnKey="IsBetterGreater" EditorID="Provider_DropDown_Boolean" /> <ig:EditingColumnSetting ColumnKey="SubCategoryID" EditorID="Provider_DropDown_Category_SubCategory" /> <ig:EditingColumnSetting ColumnKey="OrderSort" EditorID="Provider_Numeric_Editor" /> <ig:EditingColumnSetting ColumnKey="OrderPrint" EditorID="Provider_Numeric_Picker" /> <ig:EditingColumnSetting ColumnKey="Name" EditorID="Provider_TextBox_Picker" /> <ig:EditingColumnSetting ColumnKey="Name_Access" EditorID="Provider_TextBox_Picker" /> <ig:EditingColumnSetting ColumnKey="dtInserted" ReadOnly="True" /> <ig:EditingColumnSetting ColumnKey="dtUpdated" ReadOnly="True" /> <ig:EditingColumnSetting ColumnKey="strInserted" ReadOnly="True" /> <ig:EditingColumnSetting ColumnKey="strUpdated" ReadOnly="True" /> <ig:EditingColumnSetting ColumnKey="DataPointID" ReadOnly="True" /> <ig:EditingColumnSetting ColumnKey="Name_Excel" ReadOnly="True" /> <ig:EditingColumnSetting ColumnKey="Name_Web_Survey" EditorID="Provider_DropDown_Alias" /> </ColumnSettings> <EditModeActions MouseClick="Single" /> </ig:CellEditing> <ig:RowAdding> <ColumnSettings> <ig:RowAddingColumnSetting ColumnKey="IsNumeric" EditorID="Provider_DropDown_Boolean" /> <ig:RowAddingColumnSetting ColumnKey="IsProse" EditorID="Provider_DropDown_Boolean" /> <ig:RowAddingColumnSetting ColumnKey="IsMedian" EditorID="Provider_DropDown_Boolean" /> <ig:RowAddingColumnSetting ColumnKey="IsBank" EditorID="Provider_DropDown_Boolean" /> <ig:RowAddingColumnSetting ColumnKey="IsCreditUnion" EditorID="Provider_DropDown_Boolean" /> <ig:RowAddingColumnSetting ColumnKey="IsOnReport" EditorID="Provider_DropDown_Boolean" /> <ig:RowAddingColumnSetting ColumnKey="IsDate" EditorID="Provider_DropDown_Boolean" /> <ig:RowAddingColumnSetting ColumnKey="IsBoolean" EditorID="Provider_DropDown_Boolean" /> <ig:RowAddingColumnSetting ColumnKey="IsClient" EditorID="Provider_DropDown_Boolean" /> <ig:RowAddingColumnSetting ColumnKey="IsNullable" EditorID="Provider_DropDown_Boolean" /> <ig:RowAddingColumnSetting ColumnKey="IsParticipant" EditorID="Provider_DropDown_Boolean" /> <ig:RowAddingColumnSetting ColumnKey="IsSubZeroForNull" EditorID="Provider_DropDown_Boolean" /> <ig:RowAddingColumnSetting ColumnKey="IsSummedFromOtherDatapoints" EditorID="Provider_DropDown_Boolean" /> <ig:RowAddingColumnSetting ColumnKey="IsPickOne" EditorID="Provider_DropDown_Boolean" /> <ig:RowAddingColumnSetting ColumnKey="IsPickOneOrMore" EditorID="Provider_DropDown_Boolean" /> <ig:RowAddingColumnSetting ColumnKey="IsLookup" EditorID="Provider_DropDown_Boolean" /> <ig:RowAddingColumnSetting ColumnKey="IsPercent" EditorID="Provider_DropDown_Boolean" /> <ig:RowAddingColumnSetting ColumnKey="IsMoney" EditorID="Provider_DropDown_Boolean" /> <ig:RowAddingColumnSetting ColumnKey="IsSummedFromOtherDatapoints" EditorID="Provider_DropDown_Boolean" /> <ig:RowAddingColumnSetting ColumnKey="IsUsedByRatioFormula" EditorID="Provider_DropDown_Boolean" /> <ig:RowAddingColumnSetting ColumnKey="IsBetterLesser" EditorID="Provider_DropDown_Boolean" /> <ig:RowAddingColumnSetting ColumnKey="IsBetterGreater" EditorID="Provider_DropDown_Boolean" /> <ig:RowAddingColumnSetting ColumnKey="SubCategoryID" EditorID="Provider_DropDown_Category_SubCategory" /> <ig:RowAddingColumnSetting ColumnKey="OrderSort" EditorID="Provider_Numeric_Editor" /> <ig:RowAddingColumnSetting ColumnKey="OrderPrint" EditorID="Provider_Numeric_Picker" /> <ig:RowAddingColumnSetting ColumnKey="Name" EditorID="Provider_TextBox_Picker" /> <ig:RowAddingColumnSetting ColumnKey="Name_Access" EditorID="Provider_TextBox_Picker" /> <ig:RowAddingColumnSetting ColumnKey="dtInserted" ReadOnly="True" /> <ig:RowAddingColumnSetting ColumnKey="dtUpdated" ReadOnly="True" /> <ig:RowAddingColumnSetting ColumnKey="strInserted" ReadOnly="True" /> <ig:RowAddingColumnSetting ColumnKey="strUpdated" ReadOnly="True" /> <ig:RowAddingColumnSetting ColumnKey="DataPointID" ReadOnly="True" /> <ig:RowAddingColumnSetting ColumnKey="Name_Excel" ReadOnly="True" /> <ig:RowAddingColumnSetting ColumnKey="Name_Web_Survey" EditorID="Provider_DropDown_Alias" /> </ColumnSettings> <EditModeActions MouseClick="Single" /> </ig:RowAdding> </Behaviors> </ig:EditingCore> <ig:Selection> <AutoPostBackFlags CellSelectionChanged="False" ColumnSelectionChanged="False" RowSelectionChanged="False" /> </ig:Selection> <ig:Activation> <AutoPostBackFlags ActiveCellChanged="False" /> </ig:Activation> <ig:Filtering> <EditModeActions MouseClick="Single" /> </ig:Filtering> <ig:ColumnResizing> </ig:ColumnResizing> <ig:Sorting> </ig:Sorting> <ig:VirtualScrolling></ig:VirtualScrolling> </Behaviors> </ig:WebDataGrid> </asp:Panel> <asp:ObjectDataSource ID="ods_Grid" runat="server" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" TypeName="DataPoint2TableAdapters.dTblAdap_DataPoint" DeleteMethod="Delete" InsertMethod="Insert" UpdateMethod="Update"> <DeleteParameters> <asp:Parameter Name="Original_DataPointID" Type="Int32" /> </DeleteParameters> <InsertParameters> <asp:Parameter Name="SubCategoryID" Type="Int32" /> <asp:Parameter Name="Name" Type="String" /> <asp:Parameter Name="Description" Type="String" /> <asp:Parameter Name="Question" Type="String" /> <asp:Parameter Name="Name_Access" Type="String" /> <asp:Parameter Name="Name_Excel" Type="String" /> <asp:Parameter Name="Name_IT_CIO_Survey" Type="String" /> <asp:Parameter Name="Name_Web_Survey" Type="String" /> <asp:Parameter Name="Format" Type="String" /> <asp:Parameter Name="Order" Type="String" /> <asp:Parameter Name="QID1" Type="String" /> <asp:Parameter Name="QID2" Type="String" /> <asp:Parameter Name="SortOrder" Type="Single" /> <asp:Parameter Name="OrderSort" Type="Single" /> <asp:Parameter Name="OrderPrint" Type="Single" /> <asp:Parameter Name="IsNumeric" Type="Boolean" /> <asp:Parameter Name="IsProse" Type="Boolean" /> <asp:Parameter Name="IsBank" Type="Boolean" /> <asp:Parameter Name="IsCreditUnion" Type="Boolean" /> <asp:Parameter Name="IsClient" Type="Boolean" /> <asp:Parameter Name="IsParticipant" Type="Boolean" /> <asp:Parameter Name="IsNullable" Type="Boolean" /> <asp:Parameter Name="IsSubZeroForNull" Type="Boolean" /> <asp:Parameter Name="IsSummedFromOtherDatapoints" Type="Boolean" /> <asp:Parameter Name="IsBoolean" Type="Boolean" /> <asp:Parameter Name="IsDate" Type="Boolean" /> <asp:Parameter Name="IsPickOne" Type="Boolean" /> <asp:Parameter Name="IsPickOneOrMore" Type="Boolean" /> <asp:Parameter Name="IsLookup" Type="Boolean" /> <asp:Parameter Name="IsPercent" Type="Boolean" /> <asp:Parameter Name="IsMoney" Type="Boolean" /> <asp:Parameter Name="IsOnReport" Type="Boolean" /> <asp:Parameter Name="IsBetterGreater" Type="Boolean" /> <asp:Parameter Name="IsBetterLesser" Type="Boolean" /> <asp:Parameter Name="IsUsedByRatioFormula" Type="Boolean" /> <asp:Parameter Name="IsMedian" Type="Boolean" /> <asp:Parameter Name="Webchoice1" Type="String" /> <asp:Parameter Name="Webchoice2" Type="String" /> <asp:Parameter Name="Webchoice3" Type="String" /> <asp:Parameter Name="Webchoice4" Type="String" /> <asp:Parameter Name="Webchoice5" Type="String" /> <asp:Parameter Name="Webchoice6" Type="String" /> <asp:Parameter Name="Webchoice7" Type="String" /> <asp:Parameter Name="Webchoice8" Type="String" /> <asp:Parameter Name="Webchoice9" Type="String" /> <asp:Parameter Name="dtInserted" Type="DateTime" /> <asp:Parameter Name="strInserted" Type="String" /> <asp:Parameter Name="dtUpdated" Type="DateTime" /> <asp:Parameter Name="strUpdated" Type="String" /> </InsertParameters> <UpdateParameters> <asp:Parameter Name="SubCategoryID" Type="Int32" /> <asp:Parameter Name="Name" Type="String" /> <asp:Parameter Name="Description" Type="String" /> <asp:Parameter Name="Question" Type="String" /> <asp:Parameter Name="Name_Access" Type="String" /> <asp:Parameter Name="Name_Excel" Type="String" /> <asp:Parameter Name="Name_IT_CIO_Survey" Type="String" /> <asp:Parameter Name="Name_Web_Survey" Type="String" /> <asp:Parameter Name="Format" Type="String" /> <asp:Parameter Name="Order" Type="String" /> <asp:Parameter Name="QID1" Type="String" /> <asp:Parameter Name="QID2" Type="String" /> <asp:Parameter Name="SortOrder" Type="Single" /> <asp:Parameter Name="OrderSort" Type="Single" /> <asp:Parameter Name="OrderPrint" Type="Single" /> <asp:Parameter Name="IsNumeric" Type="Boolean" /> <asp:Parameter Name="IsProse" Type="Boolean" /> <asp:Parameter Name="IsBank" Type="Boolean" /> <asp:Parameter Name="IsCreditUnion" Type="Boolean" /> <asp:Parameter Name="IsClient" Type="Boolean" /> <asp:Parameter Name="IsParticipant" Type="Boolean" /> <asp:Parameter Name="IsNullable" Type="Boolean" /> <asp:Parameter Name="IsSubZeroForNull" Type="Boolean" /> <asp:Parameter Name="IsSummedFromOtherDatapoints" Type="Boolean" /> <asp:Parameter Name="IsBoolean" Type="Boolean" /> <asp:Parameter Name="IsDate" Type="Boolean" /> <asp:Parameter Name="IsPickOne" Type="Boolean" /> <asp:Parameter Name="IsPickOneOrMore" Type="Boolean" /> <asp:Parameter Name="IsLookup" Type="Boolean" /> <asp:Parameter Name="IsPercent" Type="Boolean" /> <asp:Parameter Name="IsMoney" Type="Boolean" /> <asp:Parameter Name="IsOnReport" Type="Boolean" /> <asp:Parameter Name="IsBetterGreater" Type="Boolean" /> <asp:Parameter Name="IsBetterLesser" Type="Boolean" /> <asp:Parameter Name="IsUsedByRatioFormula" Type="Boolean" /> <asp:Parameter Name="IsMedian" Type="Boolean" /> <asp:Parameter Name="Webchoice1" Type="String" /> <asp:Parameter Name="Webchoice2" Type="String" /> <asp:Parameter Name="Webchoice3" Type="String" /> <asp:Parameter Name="Webchoice4" Type="String" /> <asp:Parameter Name="Webchoice5" Type="String" /> <asp:Parameter Name="Webchoice6" Type="String" /> <asp:Parameter Name="Webchoice7" Type="String" /> <asp:Parameter Name="Webchoice8" Type="String" /> <asp:Parameter Name="Webchoice9" Type="String" /> <asp:Parameter Name="dtInserted" Type="DateTime" /> <asp:Parameter Name="strInserted" Type="String" /> <asp:Parameter Name="dtUpdated" Type="DateTime" /> <asp:Parameter Name="strUpdated" Type="String" /> <asp:Parameter Name="Original_DataPointID" Type="Int32" /> </UpdateParameters> </asp:ObjectDataSource> <asp:SqlDataSource ID="dSrc_TrueFalseNull" runat="server" ConnectionString="<%mce_markernbsp;ConnectionStrings:dbExcelConnectionString %>" DataSourceMode="DataSet" SelectCommand="usp_Select_List_True_False" SelectCommandType="StoredProcedure"> </asp:SqlDataSource> <asp:SqlDataSource ID="dSrc_Category_SubCategory" runat="server" ConnectionString="<%mce_markernbsp;ConnectionStrings:dbExcelConnectionString %>" DataSourceMode="DataSet" SelectCommand="usp_Select_Category_SubCategory" SelectCommandType="StoredProcedure"> </asp:SqlDataSource> <asp:SqlDataSource ID="dSrc_Alias" runat="server" ConnectionString="<%mce_markernbsp;ConnectionStrings:dbExcelConnectionString %>" SelectCommand="usp_Select_Survey_Item_Subitem_Alias" SelectCommandType="StoredProcedure"> </asp:SqlDataSource> </asp:Content>
Hi,
Maybe you should take out the activation behavior all together. Look at this post:
https://www.infragistics.com/community/forums/f/ultimate-ui-for-asp-net/35865/batch-update-insert-delete-with-webdatagrid
Ed
Thanks. Disabling the Activation behavior gave me the desired results as described in the article you cited, and also in the "Cell Editing" topic in the documentation:
"To enable data editing in WebHierarchicalDataGrid™, add the CellEditing behavior to the Behaviors collection. The EditModeActions property of the CellEditing behavior lets you determine what actions will cause a cell to enter edit mode.
If you have handled the RowUpdating event, changes will commit immediately to your data source as you lose focus on the edited row. For a row to obtain or lose focus, you must have the Activation behavior enabled. For more information on the Activation behavior, see the Activation topic.
Note: You must have a supported data source for this type of automatic update to occur. If your data source cannot be automatically updated by WebHierarchicalDataGrid, you must handle the update events and update the data manually."