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

Update Mutiple Rows

1 Answer 67 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Layo
Top achievements
Rank 1
Layo asked on 20 Sep 2012, 02:28 PM
I have a question, of how to save multiple rows in a RadGrid.
Example.
This loops through the entire RadGrid editable mode and assigned to all fields.

foreach (GridDataItem item in RadGrid1.Items)
        {
            item.Edit = true;
        }
        RadGrid1.MasterTableView.Rebind();  

I want to achieve something similar but obviously making a save in the datatable I give it as source.


Thanks

1 Answer, 1 is accepted

Sort by
0
Jayesh Goyani
Top achievements
Rank 2
answered on 20 Sep 2012, 06:00 PM
Hello,

Performing Batch Updates

OR
<MasterTableView CommandItemDisplay="Top" DataKeyNames="ID" Name="Parent">
                <Columns>
                    <telerik:GridBoundColumn DataField="ID" UniqueName="ID" HeaderText="ID">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="Name" UniqueName="Name" HeaderText="Name">
                    </telerik:GridBoundColumn>
                    <telerik:GridTemplateColumn>
                        <ItemTemplate>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
                        </EditItemTemplate>
                    </telerik:GridTemplateColumn>
                    <telerik:GridEditCommandColumn>
                    </telerik:GridEditCommandColumn>
                </Columns>
            </MasterTableView>
 </telerik:RadGrid>
.........
..........
 <asp:Button ID="Button1" runat="server" Text="Set in Edit mode" OnClick="Button1_Click" />
        <asp:Button ID="Button2" runat="server" Text="Save edit rows" OnClick="Button2_Click" />
protected void Button1_Click(object sender, EventArgs e)
      {
          foreach (GridDataItem item in RadGrid1.Items)
          {
              item.Edit = true;
          }
          RadGrid1.MasterTableView.Rebind();
      }
 
      protected void Button2_Click(object sender, EventArgs e)
      {
          foreach (GridDataItem item in RadGrid1.EditItems)
          {
              //Access datakey
              string steId = item.GetDataKeyValue("ID").ToString();
              // Acccess boundcolumn's control
              string strName = (item.EditFormItem["Name"].Controls[0] as TextBox).Text;
              // Access templatecolumn's control
              string strTxt = (item.EditFormItem.FindControl("TextBox1") as TextBox).Text;
                                      // Perform Your Update logic here
              item.Edit = false;
          }
          RadGrid1.MasterTableView.Rebind();
      }


Thanks,
Jayesh Goyani
Tags
Grid
Asked by
Layo
Top achievements
Rank 1
Answers by
Jayesh Goyani
Top achievements
Rank 2
Share this question
or