Results 1 to 2 of 2

Thread: [RESOLVED] Update in DataGrid not reflected immediately in database?

  1. #1

    Thread Starter
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Candon City, Ilocos Sur, Phils.
    Posts
    11,044

    Resolved [RESOLVED] Update in DataGrid not reflected immediately in database?

    My I.T. Manager got problem with the DataGrid, supposedly when he had updated a record in the DataGrid he wants it that the changes would immediately be reflected to the database without moving to the next record, I have discovered that Resync is able to to that but when I try to automate it with...

    VB Code:
    1. Private Sub adoDeeU_FieldChangeComplete(ByVal cFields As Long, ByVal Fields As Variant, ByVal pError As ADODB.Error, adStatus As ADODB.EventStatusEnum, ByVal pRecordset As ADODB.Recordset)
    2.     adoDeeU.Resync
    3. End Sub

    I am encountering this error...

    Code:
    Consumer's event handler called a non-reentrant method in the provider.
    Anyone who could provide me a workaround for this?

    Thanks!
    Regards,


    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system

  2. #2

    Thread Starter
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Candon City, Ilocos Sur, Phils.
    Posts
    11,044

    Re: Update in DataGrid not reflected immediately in database?

    The ff. is a workaround though I'm still open to other solutions...

    VB Code:
    1. Private Sub DataGrid1_AfterColUpdate(ByVal ColIndex As Integer)
    2.     adoDeeU.Resync adAffectCurrent, adResyncUnderlyingValues
    3. End Sub
    Regards,


    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width