[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Web Service to update SQL Server table

Posted on 2009-03-29
3
Medium Priority
?
553 Views
Last Modified: 2012-05-06
I've got a web service written in VB.NET that I use to send datasets to an application and receive data back as a dataset after the user has modified the data within the application.  The biggest drawback to this method is that it could be a large dataset and sometimes the people work over a slow connection.  I've been looking for a way to send back and update an SQL table everytime they modify a record.  The code on the application isn't a problem, but I haven't found a good example of a web service that will update the SQL Server.  I only need to update two fields (a date the record was updated and who it was update by).
0
Comment
Question by:TomCoon
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 96

Expert Comment

by:Bob Learned
ID: 24017392
What kind of "example" are you looking for.  If you are only looking for a way to pass in a primary key value, and any field values, I wouldn't think that would be too difficult.
0
 

Author Comment

by:TomCoon
ID: 24018399
Want to pass primary key and two field values to be updated, one a date field (smalldatetime) and the other text (nvarchar(10)).  Passing it back to the web service isn't a problem, but the code to get the web service to update the SQL Server table is what I'm looking for.
0
 
LVL 96

Accepted Solution

by:
Bob Learned earned 2000 total points
ID: 24018516
Are you looking for SqlCommand.ExecuteNonQuery to insert data?

Example:

http://www.startvbdotnet.com/ado/sqlserver1.aspx
0

Featured Post

Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Online collaboration is quickly becoming embedded in the workplace, and its benefits are tangible. See what the current landscape looks like and what the future holds for collaboration tools and the future of work.
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
The purpose of this video is to demonstrate how to set up the WordPress backend so that each page automatically generates a Mailchimp signup form in the sidebar. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome…
This video teaches users how to migrate an existing Wordpress website to a new domain.

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question