473,474 Members | 1,592 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Best way to update data

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.
Nov 30 '07 #1
3 1355
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" <kmahoney@nospam_fireacademy.orgschreef in bericht
news:ea********************************@4ax.com...
>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.
Dec 1 '07 #2
I'm new to web services, but I'll check it out. Thanks.
On Sat, 1 Dec 2007 14:24:03 +0100, "Cor Ligthert[MVP]" <no************@planet.nlwrote:
>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" <kmahoney@nospam_fireacademy.orgschreef in bericht
news:ea********************************@4ax.com.. .
>>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.
Dec 1 '07 #3

"Kevin" <ke****@cfl.rr.comwrote in message
news:p8********************************@4ax.com...
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.

>

On Sat, 1 Dec 2007 14:24:03 +0100, "Cor Ligthert[MVP]"
<no************@planet.nlwrote:
>>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" <kmahoney@nospam_fireacademy.orgschreef in bericht
news:ea********************************@4ax.com. ..
>>>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.
Dec 2 '07 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

16
by: D Witherspoon | last post by:
I am developing a Windows Forms application in VB.NET that will use .NET remoting to access the data tier classes. A very simple way I have come up with is by creating typed (.xsd) datasets. For...
2
by: Mike Button | last post by:
Hello all, I am really really desperate on what I should do, and I am asking for help from anyone in this newsgroup, here's the situation: I am creating a form that is being run on a server...
1
by: Mok | last post by:
Hello, I want to pull information from a table in sql server, bind it to a grid and update those values. I would like to know the best way to do it. I used the configure data adapter wizard and it...
12
by: Aaron Smith | last post by:
What is the best way to handle data in a multiple user environment? We have forms that will allow users to add edit and delete data from a table on SQL server. The data could be edited on multiple...
6
by: Nate | last post by:
I am in a slight predicament trying to determine the most efficient and effective way to connect/disconnect from a database within a business object (c# dll). I'm also keeping in mind the concept...
5
by: Rob | last post by:
I have a form where the user may see a matrix of data in a grid (populated via a dataset). If the user wishes to add a new row of data, they click a button and a new form opens where the user may...
2
by: Fred Flintstone | last post by:
What's the difference between these two methods? 1 - Parameterrized SQL queries: Dim CommandObject As New Data.SqlClient.SqlCommand With CommandObject .Connection = myConnection...
4
by: MicroMoth | last post by:
Hi, I'm trying to write a update method, in which when the user clicks the update button the update method is passed 10 form fields. Then a update SQL is run to update the database. My question...
1
by: sufferthefools | last post by:
i have been taught always to use the data module and place all the necesary components on it and refer to it when i need something. but is this the best programming practise?? i get a lot of...
4
by: trullock | last post by:
Hi, Can anyone suggest the best way to go about the following... I'm tracking clicks (mouse down x,y coordinates) on a web page by using some javascript to create an XHR which sends the...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
1
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.