C# Client/Server Application

[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

 

[Joe Mayo [C# MVP]]

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

 

[Nicholas Paldino [.NET/C# MVP]]

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.

 

[Salina]

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