Save Radgrid all at one time.

[Stefan]

Hi,

I have a needatasource radgrid that allows inline vb.net edits.  What I want to do is let the user make any edits to the grid values and then dump the grid to the DB by a Save Button.  I can't save each edit one at a time because the table needs to be dumped and resaved because of an ordering issue and I won't know the correct order until the person is done making all the edits...  Is this possible?

[Princy]

Hi Stefan,

Please have a look at this DEMO and this Code Library for your solution.Hope this helps.

Thanks,
Princy

[Stefan]

I have a problem with Batch updates.  How can I get the changed value with VB.net code behind using advanced data binding.

I can retrieve all the old values but not the new values.  I will delete my table then save the grid as a new table using i as my new seq number.  But all I get is the old values when I loop through the grid?

    Protected Sub btnSaveGrid_Click(sender As Object, e As EventArgs) Handles btnSaveGrid.Click

        Dim test As String = String.Empty

        For Each row As GridDataItem In dgGrid.Items
            test = row("ID").Text
            test = row("Seq").Text
            test = row("Value").Text
            test = row("BonusPct").Text
        Next

    End Sub

thanks again.

[Stefan]

Wanted to add I need to save the entire grid, which includes new values and values that were not updated.  Is this even possible in vb code behind?

[Kostadin]

Hi Stefan,

I would recommend you to examine the Batch editing documentation where is described how to get the old an new values.

Regards,
Kostadin
Telerik