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

Update all rows

3 Answers 180 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Marcus
Top achievements
Rank 1
Marcus asked on 06 Apr 2011, 10:44 AM
I need a grid where all rows are in Edit Mode. Then I want  with Update button all rows to updateWhat should I add in code-behind?
<body>
    <form id="form1" runat="server">
    <div>
        <telerik:RadScriptManager ID="RadScriptManager1" runat="server">
        </telerik:RadScriptManager>
        <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
            <AjaxSettings>
                <telerik:AjaxSetting AjaxControlID="RadGrid1">
                    <UpdatedControls>
                        <telerik:AjaxUpdatedControl ControlID="RadGrid1" />
                    </UpdatedControls>
                </telerik:AjaxSetting>
            </AjaxSettings>
        </telerik:RadAjaxManager>
 
 
 
 
<telerik:RadGrid ID="RadGrid1" runat="server" AllowAutomaticUpdates="True"
            CellSpacing="0" DataSourceID="SqlDataSource1" GridLines="None">
<MasterTableView AutoGenerateColumns="False" CommandItemDisplay="Top" DataKeyNames="id"
                DataSourceID="SqlDataSource1">
<CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings>
 
<RowIndicatorColumn FilterControlAltText="Filter RowIndicator column">
<HeaderStyle Width="20px"></HeaderStyle>
</RowIndicatorColumn>
 
<ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column">
<HeaderStyle Width="20px"></HeaderStyle>
</ExpandCollapseColumn>
 
    <Columns>
        <telerik:GridBoundColumn DataField="id" DataType="System.Int32"
            FilterControlAltText="Filter id column" HeaderText="id" ReadOnly="True"
            SortExpression="id" UniqueName="id">
        </telerik:GridBoundColumn>
        <telerik:GridTemplateColumn FilterControlAltText="Filter TemplateColumn column"
            HeaderText="f1" UniqueName="f1">
            <ItemTemplate>
                <telerik:RadTextBox ID="RadTextBox1" Runat="server" Text='<%# Bind("f1") %>'
                    Width="125px">
                </telerik:RadTextBox>
            </ItemTemplate>
        </telerik:GridTemplateColumn>
        <telerik:GridTemplateColumn FilterControlAltText="Filter TemplateColumn1 column"
            HeaderText="f2" UniqueName="f2">
            <ItemTemplate>
                <telerik:RadNumericTextBox ID="RadNumericTextBox1" Runat="server"
                    Culture="de-DE" DbValue='<%# Bind("f2") %>' Width="125px">
                </telerik:RadNumericTextBox>
            </ItemTemplate>
        </telerik:GridTemplateColumn>
    </Columns>
 
<EditFormSettings>
<EditColumn FilterControlAltText="Filter EditCommandColumn column"></EditColumn>
</EditFormSettings>
    <CommandItemTemplate>
         <asp:LinkButton ID="btnUpdateEdited" runat="server" CommandName="UpdateEdited" >Update</asp:LinkButton>
    </CommandItemTemplate>
</MasterTableView>
 
<FilterMenu EnableImageSprites="False"></FilterMenu>
 
<HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default"></HeaderContextMenu>
        </telerik:RadGrid>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server"
            ConnectionString="<%$ ConnectionStrings:webzeus %>"
            SelectCommand="SELECT * FROM [TestTable]"
            UpdateCommand="UPDATE [TestTable] SET [f1] = @f1, [f2] = @f2  WHERE [id] = @original_id ">
            <UpdateParameters>
                <asp:Parameter Name="f1" Type="String" />
                <asp:Parameter Name="f2" Type="Int16" />
                <asp:Parameter Name="original_id" Type="Int16" />
            </UpdateParameters>           
            </asp:SqlDataSource>
    </div>
    </form>
</body>
Thanks, Evgeny

3 Answers, 1 is accepted

Sort by
0
Princy
Top achievements
Rank 2
answered on 06 Apr 2011, 10:52 AM
Hello Marcus,

The following documetation illustrates how to perform batch updates.
Performing batch updates

Thanks,
Princy.
0
Marcus
Top achievements
Rank 1
answered on 06 Apr 2011, 11:23 AM
Thanks Princy,
Unfortunately, my grid is not in Edit mode. So coming not pure in "If" construction.
Protected Sub RadGrid1_ItemDataBound(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridItemEventArgs) Handles RadGrid1.ItemDataBound
    If (TypeOf e.Item Is GridDataItem AndAlso e.Item.IsInEditMode) Then
        Dim dataItem As GridDataItem = CType(e.Item, GridDataItem)
        'Hides the Update button for each edit form
        dataItem("EditCommandColumn").Controls(0).Visible = False
    End If
End Sub
0
Princy
Top achievements
Rank 2
answered on 07 Apr 2011, 09:46 AM
Hello Marcus,

Please take a look at the following documetation to put all the Grid rows in edit mode.
Put all items in edit mode without additional rebind
Default edit mode for grid items on initial load

Thanks,
Princy.
Tags
Grid
Asked by
Marcus
Top achievements
Rank 1
Answers by
Princy
Top achievements
Rank 2
Marcus
Top achievements
Rank 1
Share this question
or