[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 170
  • Last Modified:

Why the value DataGrid.Row is limitted within 10

The DataSource property of this DataGrid is an ADODC. After User change the data, I want the DataGrid focus on the Changed row. The Codes are:

    Dim lngBookID As Long
    'grd2Books is a DataGrid
    lngRePlace = grd2Books.Row 'Get the Current Row
   
    'Modify the Data
     ...............
    'adoBooks is ADODC, the DataSource of DataGrid
     adoBooks.Recordset.Move lngRePlace, adBookmarkFirst
       
But when I select the row after 10th, the value of lngReplace remains 9 for ever.  why??
0
Iaskyou
Asked:
Iaskyou
1 Solution
 
appariCommented:
grd2Books.Row  returns the current row no from visible rows.

for your purpose use grd2Books.Bookmark insted of grd2Books.Row




   Dim lngBookID As Long
   'grd2Books is a DataGrid
   'lngRePlace = grd2Books.Row 'Get the Current Row
   lngRePlace = grd2Books.Bookmark
   'Modify the Data
    ...............
   'adoBooks is ADODC, the DataSource of DataGrid
    adoBooks.Recordset.Move lngRePlace, adBookmarkFirst


hope this helps
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now