472,342 Members | 2,553 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,342 software developers and data experts.

Sending data to a web database from Windows forms application

Hi All

I need to learn how to update a SQl server or Access database located on a
web server from my windows forms application, via the internet

I have a customer who wants to run several windows forms applications in
different shop locations but all have to update a Web based database with
products sold etc

Is Web services the way to go? or are there better options

Any links to code examples appreciated

Mar 4 '07 #1
2 2915
"steve" <ga*****@newsgroups.nospamwrote in news:ucByubiXHHA.4440
Is Web services the way to go? or are there better options
Web services would be ideal for this sort of thing.

Remoting may work too ... if you need access to .NET data types/
Mar 4 '07 #2
Hello Steve,

As you mentioned that the application communcation is over internet, so the
database server should be be directly accessible via other remote
clients(due to security and network restriction). I also think that
webservice should be a reasonable approach as it is designed for loose
coupled distributed environment.

Using webservice, the most important thing is defining class types that
will be transfered over internet(over webservice http protocol). Normally,
for data accessing application, you need to define class types that
represent those database table, record and fields. The .net dataset is a
built-in data component class that can be transferred over XML
serialization based protocol. You can also define your custom class that
can be corretly serialized as XML and transfer over http.

For example, you can directly transfer the data base query/update command
to server-side for execution or transfer DataSet (or custom class
collection and command objects) to server-side and let the server-side
webmethod do the actucal data accessing to backend database:

#How To Update Server Data Through a Web Service by Using ADO.NET and
Visual C# .NET

#Querying and Updating a Database Using Web Services in InfoPath and ASP.NET

#Toward a Generic Data Access WebService

For more information about webservice, you can visit the MSDN websevice dev

#Web Services and Other Distributed Technologies

Hope this helps.


Steven Cheng

Microsoft MSDN Online Support Lead


Get notification to my posts through email? Please refer to

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at


This posting is provided "AS IS" with no warranties, and confers no rights.

Mar 5 '07 #3

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

Similar topics

by: Hamed | last post by:
Hello I have employed as a developer in a software company that its team uses FoxPro / VB 6.0 / VC++ 6.0 as the developing tools and newly is...
by: rogsonl | last post by:
My computer was moved last week, and the company changed the network groups we work on. As a result, one of the main benefits from Whidbey...
by: Doug Bell | last post by:
Hi, I have an application that has a "Data Access Class" and "User Interface Class". It is for receiving Purchase Order data from one system and...
by: Wesley Peace | last post by:
I hate to cross post, but I've gotten no answer yet on a problem I'm having with visual studio 2008. I've created a series of forms with controls...
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
by: teenabhardwaj | last post by:
How would one discover a valid source for learning news, comfort, and help for engineering designs? Covering through piles of books takes a lot of...
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
by: Matthew3360 | last post by:
Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. ...
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
by: Matthew3360 | last post by:
Hi, I have been trying to connect to a local host using php curl. But I am finding it hard to do this. I am doing the curl get request from my web...

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.