Results 1 to 3 of 3

Thread: DataGrid Question

  1. #1

    Thread Starter
    Registered User Virus00110's Avatar
    Join Date
    Jul 2002
    Location
    Williamsport, PA
    Posts
    290

    Question DataGrid Question



    Is there a way to update the datagrid that is bound to a dataenvironment table after that table has had a batch update done to it.

    I've done a rs.ReQuery and a DataGrid1.ReFresh but it doesn't refresh or display the new records after the batch update, I can get the new record count but that is it. Any help would be appreciated.

  2. #2
    Fanatic Member
    Join Date
    Aug 2001
    Location
    Connecticut
    Posts
    855
    rs.requery works when there is no dataenvironment.
    try a manual refresh:
    If DataEnvironment1.rsCommand1.State = adStateOpen Then DataEnvironment1.rsCommand1.Close
    'reopen the command
    DataEnvironment1.Command1
    'assumes datagrid's datamember is already set.
    Set DataGrid1.DataSource = DataEnvironment1
    VB 6.0, Access, Sql server, Asp

  3. #3

    Thread Starter
    Registered User Virus00110's Avatar
    Join Date
    Jul 2002
    Location
    Williamsport, PA
    Posts
    290
    Thanks I was just started to doing that. At least someone else was thinking like me


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