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
--
Joe Mayo, Author/Instructor
Need C#/.NET training?
visit www.mayosoftware.com
C# Tutorial - www.csharp-station.com

"Salina" <an*******@discussions.microsoft.com> wrote in message
news:b0****************************@phx.gbl...

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

[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.

--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Joe Mayo [C# MVP]" <jm***@nospamAtCSharpDashStation.com> wrote in message
news:OA***************@TK2MSFTNGP10.phx.gbl...

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
--
Joe Mayo, Author/Instructor
Need C#/.NET training?
visit www.mayosoftware.com
C# Tutorial - www.csharp-station.com

"Salina" <an*******@discussions.microsoft.com> wrote in message
news:b0****************************@phx.gbl...

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

[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

-----Original Message-----
Hi Salina,

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

Joe
--
Joe Mayo, Author/Instructor
Need C#/.NET training?
visit www.mayosoftware.com
C# Tutorial - www.csharp-station.com

"Salina" <an*******@discussions.microsoft.com> wrote in messagenews:b0****************************@phx.gbl...

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

.