Ok you were right Sancler, I did try something too fast.
What actually works is it doesnt stop the sort ... but the data arent updated..
OK so I need your help. I will write again what I want and maybe work that togheter:
1) I got a timer Interval : 6 seconds.
2) OnLoad: fillRooms()
Public Sub fillRooms()
dtRooms = oData.selectTable.Tables(0)
dgRooms.DataSource = dtRooms
dgRooms.Columns(0).Visible = False
3) On timer_Tick, I need to get again the data from my SQL table (I got a SELECT statement on a class)
4) The new data needs to be "commited" on the DataGrid, but I want to keep the sort if it has been sorted and I want to keep the selectedRow of course.
5) that's all.