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

Update all rows

3 Answers 183 Views

Grid

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

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 update. What 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

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