CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. March 16th, 2001, 09:00 AM #1
    StephanM1
    StephanM1 is offline Junior Member
    Join Date
    Feb 2001
    Posts
    19

    Grid Refresh after delete

    Hi there,
    after I delete a row in my table I want my DataGrit to be refreshed.
    The deleting works fine in db, but the old record is still in the DataGrid:


    DataEnvironment1.Connection1.Execute (sql_string)
    DataEnvironment1.Connection1.Execute ("commit")

    DataEnvironment1.rsCommand1.Requery
    DataGrid1.Refresh


    What is the mistage ???

    regards
    Stephan

    Reply With Quote Reply With Quote
  2. March 16th, 2001, 11:25 AM #2
    anniel
    anniel is offline Junior Member
    Join Date
    Mar 2001
    Posts
    3

    Re: Grid Refresh after delete

    What kind of recordset you use?
    I think though your db has updated, but because you use connection to do the update, recordset has not be updated. And your grid is related to recordset, so...

    Reply With Quote Reply With Quote
  3. March 19th, 2001, 03:45 AM #3
    StephanM1
    StephanM1 is offline Junior Member
    Join Date
    Feb 2001
    Posts
    19

    Re: Grid Refresh after delete

    I used:
    DataEnvironment1.rsCommand1.Requery

    to refresh my recordset

    regards
    Stephan

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules




Click Here to Expand Forum to Full Width

Featured