Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DataGrid Row Refresh
- Thread starter bbrendan
- Start date
If you use ADO to connect to the database, then:
_______________________________________
There are three different kinds of people:
Those who can count, and those who cannot.
Eman_2005
Technical Communicator
Code:
yourRecordset.updatebatch adAffectCurrent should do that._______________________________________
There are three different kinds of people:
Those who can count, and those who cannot.
Eman_2005
Technical Communicator
- Thread starter
- #3
The grid only shows what the recordset contains.
If the affected change is updated for that record only in the recordset, then a refresh to the datagrid will only reflect that. So you do not need a single row refresh to the grid itself. Right?
_______________________________________
There are three different kinds of people:
Those who can count, and those who cannot.
Eman_2005
Technical Communicator
If the affected change is updated for that record only in the recordset, then a refresh to the datagrid will only reflect that. So you do not need a single row refresh to the grid itself. Right?
_______________________________________
There are three different kinds of people:
Those who can count, and those who cannot.
Eman_2005
Technical Communicator
- Thread starter
- #5
Yeah I suppose your right!
but lets say I have 5000 records in a grid and im at position 4100.
I update this record, then to see this update for this row I have to rebind/refresh the datagrid. This will rest the grid an my position back to row 1. So i have to scroll back to row 4100.
Is there a way to automatically go back to the last record row i updated once i refresh/rebind the grid??
cheers
but lets say I have 5000 records in a grid and im at position 4100.
I update this record, then to see this update for this row I have to rebind/refresh the datagrid. This will rest the grid an my position back to row 1. So i have to scroll back to row 4100.
Is there a way to automatically go back to the last record row i updated once i refresh/rebind the grid??
cheers
AHA!!
That's a different matter.
This you can do using bookmarks.
I am sure if you search this forum for datagrid bookmarks, you will find answers from people who know these things better than me.
One example is this (see by the end of the thread)
That is Thread222-821754
Hope that helps
_______________________________________
There are three different kinds of people:
Those who can count, and those who cannot.
Eman_2005
Technical Communicator
That's a different matter.
This you can do using bookmarks.
I am sure if you search this forum for datagrid bookmarks, you will find answers from people who know these things better than me.
One example is this (see by the end of the thread)
That is Thread222-821754
Hope that helps
_______________________________________
There are three different kinds of people:
Those who can count, and those who cannot.
Eman_2005
Technical Communicator
- Status
Similar threads
- Locked
- Question
- Locked
- Question