Datagridview sorting and Database.

[Johnkokk]

I have a datagridview which is bound to a ms access database, through a dataset. The user can click one record on the DGV, and open another window with all the data of the record, so that he can edit them,etc. If he tries to sort the DGV by a column, let's say the date field and then tries to load a record the thing gets messed up. It seems that whilst the DGV is sorted, the dataset is not equally "sorted". That means that the user can try to load a specific record but instead he gets a completely different one. Is there a solution to that ?

[Ashfield]

You need to either use a unique key to load the record into the new window, or sort your underlying dataset in the same way as the DGV when the column header is clicked.

Bob Ashfield Consultants Ltd

[Johnkokk]

You need to either use a unique key to load the record into the new window, or sort your underlying dataset in the same way as the DGV when the column header is clicked. There is already an ID field which is unique. How do i sort the dataset ? That's the question in the first place. :)

[Johnkokk]

Anyone guys ? Any ideas ?