Re: View updated data in recordset

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


"Ella" <ellakayeekwan@xxxxxxxxx> wrote in message
news:1142372468.196001.258600@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

I have a grid that has the datasource bind to a recordset.

grid1.DataSource = goRs

When I use the goRs add a new record, I can see the record immediated
shown in the table.

When user click on the grid, a dialog pops up for updating the value on
that row. However, I don't know which record the user selected on the
table. Is there a way to find out which record the users selected?

The best way I know of is to use a clone of the recordset that's bound to
the grid. You can then use the grid's bookmark property to position the
clone.


-Mark


Or I am trying to use an alternative way. I created another recordset
using the unique ID for updating. However, the updated data does not
shown on the grid even I call goRs.Update and re-set grid1.DataSource =
goRs. What command I should use to let the goRs pick up the latest
update?

I think the first solution is proper. If I know which record to update
then the new information must be refreshed on the grid... I think.
However, I have to know which record to update... Please help. I have
been stucked on this problem for a while.

For some reason, I cannot close the recordset.

Thanks,
Ella



.

Relevant Pages

  • View updated data in recordset
    ... I have a grid that has the datasource bind to a recordset. ... When I use the goRs add a new record, I can see the record immediated ... When user click on the grid, a dialog pops up for updating the value on ...
    (microsoft.public.vb.controls)
  • Logical Delete in Recordset
    ... Also explained in my other question, I binded a grid to a recordset by ... if I use goRS for ... Filter method, but don't quite understand. ...
    (microsoft.public.vb.controls)
  • Re: VB6 - Delete From DataGrid - Deletes the Wrong Record
    ... I have a datagrid that is bound to a recordset in a SQL 2000 database. ... If you want to do it yourself anyway, you'll need to keep or create a clone ... the clone to the bookmark property of the grid, and then act on the clone. ... Set rsClone = ADODC1.recordset.Clone ...
    (microsoft.public.vb.database.ado)
  • Re: APP behaves differently in IDE vs EXE
    ... The app is using the dbgrid32 control as an unbound grid. ... Since I've added the line to set the bookmark property to ... scrolling issue, I'd appreciate hearing them. ...
    (microsoft.public.vb.general.discussion)
  • Re: Local dataset show parts in two grids
    ... How about using clone of original ADODataSet with properly assined filter ... for each grid. ... > other in a second DBGrid depending on the value in one of the fields. ...
    (borland.public.delphi.database.ado)