navneet77
asked on
Dynamic data display
Hi,
I am making a multi user application with a central database server. i am displaying some data on a visual basic form, now if another user updates some data on the database i want the changes to immediately show on the vb form. I was trying to do this using dynamic recordset, and i see that if someone insert a new row it is reflected in the recordset but there is no event in recordset which will tell me the someone has inserted new data or changed data.
How can i know in my application that someone have inserted or updated some data in the database so that i can refresh my VB form.
I am making a multi user application with a central database server. i am displaying some data on a visual basic form, now if another user updates some data on the database i want the changes to immediately show on the vb form. I was trying to do this using dynamic recordset, and i see that if someone insert a new row it is reflected in the recordset but there is no event in recordset which will tell me the someone has inserted new data or changed data.
How can i know in my application that someone have inserted or updated some data in the database so that i can refresh my VB form.
ASKER
ya but i do not want to use timer, firstly the refresh will not be immediate and it will waste network resource.
use a 1 min. standard timer to refreshes every 60 secs.
and a refresh button.
and a refresh button.
ASKER
ya but i do not want to use timer, firstly the refresh will not be immediate and it will waste network resource.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
hi redfordb
thanks for the reply.. i have some question
how will the program on the server communicate with the clients.
what do you mean by the connection number
and how will it signal off to each connection.
thanks for the reply.. i have some question
how will the program on the server communicate with the clients.
what do you mean by the connection number
and how will it signal off to each connection.
Look at the "Using the Winsock Control" in HELP.
Basically all you need to do is extend there example so that the server can accept multiple connections. Then when the data changes send some data to all the clients that are currently connected to the server. On the client side when the data arrives it triggers off an event. All you do is put the refresh routine in this event.
You dont even need to insert the connection number into a table. just make an array on the server side, scan through the array and sen the signal to each connection that appears in the array.
Basically all you need to do is extend there example so that the server can accept multiple connections. Then when the data changes send some data to all the clients that are currently connected to the server. On the client side when the data arrives it triggers off an event. All you do is put the refresh routine in this event.
You dont even need to insert the connection number into a table. just make an array on the server side, scan through the array and sen the signal to each connection that appears in the array.
ASKER
Thanks for the help
You can try a timer if you want.