Select Dbgrid Line and Stringgrid recognize the line NUMBER

Question

Would you know to tell me if there’s a possibility when I select a line from the DBGrid, my StringGrid just recognize which line I selected?

I’m not doing functions: I’m just doing this kind of thing for user information, that is, my DBGrid has 2000 records found, and my StringGrid also, however, in DBGrid has the database records, and the StringGrid of another file. All I need is that at the time I select the record, on the respective line the StringGrid recognize which line I selected and go to it, without me having to search.

To be more clear, I want at some event, according to the execution of the system, when I select a certain line of the DBGrid, the StringGrid recognize and go to the respective line of DBGrid.

How to do?

Answer 1

First set the following option in your Dbgrid:

dgrowselect := True;

Then his DBGrid has a DataSource and this is linked to a Dataset (be this one Query, ClientDataset, whatever). This has an index.

In the case below the index is dbgOFD.DataSource.DataSet.RecNo

With this index you change the following code snippet:

StringGrid1.Col :=0;
StringGrid1.Row :=1; //dbgOFD.DataSource.DataSet.RecNo - 1
StringGrid1.Selection:=TGridRect(Rect(0,1 ,MaxInt ,1));
StringGrid1.SetFocus;

Note: Note that the StringGrid must have at least the same amount of lines DBGrid. If not, you will have to treat the exception.