Issues Scrolling to selected record

[KawaUser]

I am executing the code below following a refresh from the database.  What I'm trying to make happen is that after a process completes to update one of the rows, the data is refreshed and the previously selected record is still selected for the user and scrolled into view.  When I execute this code following an update routine the grid is scrolled completely to the bottom, and both the record I selected and the visible row within the grid (even though it is now a different row) is selected.  If I execute it from a command button, the first record is selected and the grid is scrolled completely to the top.  What am I doing wrong?

datagridview1.DataSource = Nothing

datagridview1.DataSource = Log_Table

If Log_Table.Rows.Count > 0 Then

    ' Log_Rec = Log_Table.First

    Dim Row As Telerik.WinControls.UI.GridViewRowInfo

    For Each Row In datagridview1.Rows

 

        If Row.Cells("Rec_ID").Value = RecID Then

            Row.IsSelected = True

        Else

            Row.IsSelected
= False

        End If

    Next

 

    For Each Row In datagridview1.Rows

        If Row.IsSelected Then

  Row.EnsureVisible()

        End If

    Next

End If

[Ivan Petrov]

Hi Derrik,

Thank you for writing.

There are better ways to update RadGridView after a row has been edited in the database. You can simply invalidate the row where the change happened or if your data item implements the INotifyPropertyChanged the grid will detect these changes for you and will update automatically. I would kindly ask you to send me a more detailed explanation of your setup so I can help you find a suitable solution for your scenario. I would need to know how you have set up the grid, how you get your data from the database, how you populate the grid and anything else you think might be useful. 

Looking forward to your reply.

Regards,
Ivan Petrov
Telerik

[KawaUser]

To answer some of your questions, I use stored procedures to update, add, delete from my database.  I load the table as seen below.  I either load a datatable with a table adapter or load the grid directly from the table adapter using a getdata method.   I'm completely unfamilar with the INotifyPropertyChanged or the invalidate methods you mentioned so I would appreciate knowing more if you could point me in the right direction.

That being said, I still would like to scroll to a disgnated record afterward my refresh, so for that purpose am I doing something wrong below?

[Ivan Petrov]

Hi Derrick,

Thank you for writing back.

You can read more on the INotifyPropertyChanged and INotifyCollectionChanged in the respective sections of MSDN. There are many many articles written on this matter so you should be able to find plenty of information online.

On your question I tested your code and made a slight adjustment. Here is the code that worked on my machine:

datagridview1.DataSource = Nothing
datagridview1.DataSource = Log_Table
If Log_Table.Rows.Count > 0 Then
    ' Log_Rec = Log_Table.First
    Dim Row As Telerik.WinControls.UI.GridViewRowInfo
    For Each Row In datagridview1.Rows

        If Row.Cells("Rec_ID").Value = RecID Then
            Row.IsSelected = True
            Row.IsCurrent = True
        Else
            Row.IsSelected = False
        End If
    Next
End If

This code will also invoke the ensure visible logic and will scroll the selected row into view.

I hope this will be useful. Should you have further questions, I would be glad to help.

Regards,
Ivan Petrov
Telerik