[RESOLVED] Process data from bookmarked row of datagrid to text box

[ptrifonov]

Hello everyone,

I've got a DataEnviornment with two commands in a master-detail hierarchy.

The commands are SELECT statements to two database tables:

dbo.A_Folders
FolderID (PK), col2, col3 ....

dbo.A_Documents
DocumentID (PK), FolderID (FK), col3, col4...

The parent command is named gridFolders and the child command is named gridDocuments, the relation definition field is FolderID. And I display the data from them in two datagrids placed in different tabs of SSTab control, so when you click on a data row from gridFolders it shows the second tab and respectively the second data grid which shows the documents that the selected parent folder contains, so far, so good.

My problem is that I want to make so that when a user double clicks on a record from gridDocuments a third tab is being showed and in it there are text boxes to edit the particular record. I bind the text boxes to DataSource, DataMember and DataField to gridDocuments, but they always display the first document (data row from gridDocuments command) contained into a folder.

How can I save the last selected data row from my child recordset and display the information of it into text boxes in order to allow user to edit the information?

Thank you in advance!

Regards,

Plamen