Real time database information

[Xray]

Im trying to make a car reservation program where many clients can make a reservation. So they have to see the actual list of reservations.

Someone has any recommended way of getting data from
an Sql database displayed in real time in some sort of grid?
I tried to do this with a timer thats every 2 sec. clear and refill the dataset and also refresh the datagrid. It's work but my problem is that every time im selected a datagrid row (for showing the detail information),
the datagrid selection is lost when the dataset is refill.

or someone have seen a example in vb.net with realtime database ?

Thanks.

Xray

 

[kulrom]

Hi, can you send some code?
btw, i'm not sure that datagrid is happiest solution for your purpose ... maybe you should use ListView control ... Anyway let me see some code ... i hope we'll find solution for you
Kind regards