Best way to update data

[Kevin]

I have a Windows Forms app with a form that displays/updates student data. When it activates I fill a DataTable with just the names of the students
from a table of about 10,000 names. I have Previous/Next buttons to scroll through students on the form. I fill another DataTable from a SELECT
statement and load the screen with the results. The user can change any of the data and press the SAVE button.

I need to keep a log file of the changes made. And when the record is changed in the database, I refresh the first DataTable with just the names in
case they added someone new (or another user does).

This program is going to be run over a VPN connection to our network and SQL Server 2005 running on our server. I need to know the fastest way to
save/update records across the internet.

 

[Cor Ligthert[MVP]]

Kevin,

In your case I would add a webservices solution.

If you select that at startup you have already an outcommented Hello World"
solution. To change that for your purpose is in my idea a piece of cake.

Cor

 

[Kevin]

I'm new to web services, but I'll check it out. Thanks.

 

[Mr. Arnold]

I'm new to web services, but I'll check it out. Thanks.

You can also use .Net Remoting with client software at the workstation and
server software sitting on a server. The server side software would handle
data persistence (the log file and the sending/receiving of data).

Whatever solution you use, you don't want 10,000 records of any size sent
over the TCP/IP wire like that. You want to give the perception of speed be
only sending a subset of the 10,000.