Vb6 selected row in dbgrid

snakeruru

Get the row where dbgrid selects, it can't be obtained using the row attribute, I don't know what's going on ...

Please heroes advice, thank you!

snakeruru

Or get the value of the column in the current row,
First time using dbgrid, not very likely ...

sniawpr

The value in dbgrid is the display of the recordset. The selected row ado1.recordset.fields (0) .value can return the value of the specific column.

zfight

Set DataGrid2.DataSource = Rs
DataGrid2.Row = 3
I tested it, so it works. At this time, DataGrid2 points to the fourth row, (the row number starts from 0)

zfight

Set DataGrid2.DataSource = tblnameRs
    DataGrid2.Row = 3
    MsgBox DataGrid2.Row
This is feasible, I tried

snakeruru

Do I have to recordset to find the corresponding value?
Can it be obtained from the properties of dbgrid? If something like mshflexgrid's text.

zfight

set datagrid1.DataSource = rs
datagrid1.row = 3
msgbox datagrid1.row 'value is 3

方天涯

The datagrid property can only get the current row of the datagrid table, not the recordset.
If your datagrid can only display 10 records at a time,
When you click the last row of datagrid, the value returned by datagrid.row will always only be 10.
It doesn't matter how many records your record is in the table.
It's hard to say, you know what's going on.

Private Sub DataGrid1_RowColChange (LastRow As Variant, ByVal LastCol As Integer)
Text1.Text = datagrid.Row
End Sub

The following is the value obtained using the Bookmark property of the Recordset

Private Sub DataGrid1_RowColChange (LastRow As Variant, ByVal LastCol As Integer)
Text1.Text = Adodc1.Recordset.Bookmark
End Sub

jolin1981330

Agree upstairs

snakeruru

Note that datagrid is not equal to dbgrid. Different controls ...