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

Radgridview does not update until row move!

17 Answers 676 Views

GridView

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

17 Answers, 1 is accepted

answered on 02 Dec 2010, 05:00 AM

I currently use this code:

Dim cmd As System.Data.Odbc.OdbcCommand

Dim adp As System.Data.Odbc.OdbcDataAdapter

Dim ds As New DataSet

'

Private Sub FormLoader() Handles MyBase.Load

cn.Open()

cmd = New System.Data.Odbc.OdbcCommand("SELECT * FROM TABLE", cn)

adp = New System.Data.Odbc.OdbcDataAdapter(cmd)

adp.Fill(ds, "TABLE")

'

Me.RadGridView1.AutoGenerateColumns = True

Me.RadGridView1.DataSource = ds

Me.RadGridView1.DataMember = "TABLE"

End Sub

Private Sub RadButton1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadButton1.Click

Dim cmdbuilder As New System.Data.Odbc.OdbcCommandBuilder(adp)

Dim i As Integer

i = adp.Update(ds, "TABLE")

MsgBox("Records Updated= " & i)

End Sub

Witch works fine for me. Expect that i always need to change a row before it updates.
I'm used to working with the VB.NET Datagridview, where this code always did the job like i wanted it to be.

Thank you for your help.

answered on 02 Dec 2010, 01:03 PM

Hello.

This is my designer file

<Global.Microsoft.VisualBasic.CompilerServices.DesignerGenerated()> _

Partial Class frm_goederen



* Client requests privacy about his code.

End Class

And here is my code:

Public Class frm_goederen

*Client requests privacy about his code

End Class

There is a DataSet3 included, but is not used at all.

When i try the same thing with a REGULAR DataGridView, i use this code:

Private Sub RadButton1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles RadButton1.Click

DataGridView1.EndEdit()

UpdateGrid()

End Sub

Private Sub UpdateGrid()

Dim cmdbuilder As New System.Data.Odbc.OdbcCommandBuilder(adp2)

Dim i As Integer

Try

i = adp2.Update(ds2, "TABLE")

MsgBox("Aantal wijzigingen doorgevoerd: " & i, MsgBoxStyle.Information + MsgBoxStyle.OkOnly, "Success")

Catch ex As Exception

MsgBox(ex.Message, MsgBoxStyle.Critical + MsgBoxStyle.OkOnly, "Oeps...")

End Try

End Sub

And it's working the way it should be working.

So i cant figure it out at all...

Thank you for your time

answered on 07 Dec 2010, 02:01 PM

Hi steve,

In this scenario the edit operation depends on the bound object that in your case is DataTable/DataSet. DataRow/DataRowView objects implement IEditableObject and when some data in RadGridView is changed, the internal CurrencyManager calls EndEdit of current item after the current position is changed to another row.

If you want to apply your changes immediately, you can use following code snippet:

Dim editableObject As IEditableObject = TryCast(Me.radGridView1.CurrentRow.DataBoundItem, IEditableObject)

If editableObject IsNot Nothing Then

editableObject.EndEdit()

End If

I hope this helps.

Greetings,
Julian Benkov
the Telerik team

Get started with RadControls for WinForms with numerous videos and detailed documentation.

answered on 20 Feb 2017, 11:00 AM

Hi Drago,

Thank you for writing.

We have a documentation article providing examples how the database can be updated handling various scenarios: https://feedback.telerik.com/Project/154/Feedback/Details/203285-fix-radgridview-the-last-row-is-not-updated-when-the-grid-is-bound-to-ieditabl.

In case you are using an older version of the controls you can check the following feedback item. The issue was resolved in the R3 2016 SP1 version of the suite.

I hope this helps. Should you have further questions please do not hesitate to write back.

Regards,
Hristo
Telerik by Progress

Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting

Testing & Mocking

CMS

UI/UX Tools

Debugging

Free Tools

Support and Learning

Productivity and Design Tools

Radgridview does not update until row move!

17 Answers, 1 is accepted