C# Client/Server Application

  • Thread starter Thread starter Salina
  • Start date Start date
S

Salina

I am new in C#.Net and going to write a window
client/server application.
my database is mysql and the data will update every min.
what i need to do is push the up-to-date data to clients
from server directly. Clients just need to read the data,
not neccessary for modification.
Can anyone recommend me what method I should use? DataSet
or Threading or anything else? Any samples?

Please help
 
Hi Salina,

It sounds like a data reader would work well because it obtains data as a
read-only fast-forward stream. Because you have multiple clients, make sure
you close the connection and reader when done reading so you get better
scalability and performance from your database. Rather than a database
push, I'd put a Timer component on the client that pulled the data on the
interval you need.

Joe
 
I actually wouldn't do this. I would take a look into SQL Notification
Services. It would allow the clients to be updated when a change is made,
which would lessen the amount of work the client has to do to determine if
there was a change.

This assumes you are running on SQL 2000 or above. If you are not, then
Joe's suggestion is the only option you have.

Hope this helps.
 
Thanks Joe, But can you give me some hints or instruction
how to do this? I really have no idea about it... I found
that there is a method call SOAP, can I use it? is it
suitable for my case?

Please help, Thanks
Salina
 
Back
Top