Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > .NET Web Services
|
.NET Web Services Discussions about .NET XML Web Service technologies including ASMX files, WSDL and SOAP.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the .NET Web Services section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 18th, 2005, 08:32 AM
Friend of Wrox
 
Join Date: Oct 2004
Posts: 109
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to anubhav.kumar
Default Updation of Online Data

Hi to all

I have created a web method in my web service which updates the online data base from the offline database. My method is recieving the data which i am sending from another application [ i dwelled around my code to verify this] but my data adapter is not updating the database. the code goes like this,
================================================== ==================
 <WebMethod()> Public Function UpdateOnlineData(ByVal newDS As DataSet) As String
        Dim msg As String

        'MyOnlineDS is a datset containing the schema of the table to be updated
        Dim OnlineDS As DataSet = New MyOnlineDS()

        Try

            OnlineDS.Merge(newDS)
            OnlineDS.AcceptChanges()
            MyDa.Update(OnlineDS)
            msg = "Successfull Update of " & OnlineDS.Tables(0).Rows.Count & "Rows"
            'The message is returning the total rows which has been sent to the web service and being merged in the online dataset

        Catch ex As Exception
            msg = "Error:" & vbCrLf & ex.Message
        End Try

        Return msg
    End Function
================================================== ===================

Can any one suggest any conceptual error in the code or some other way to achieve this?

Anubhav Kumar
__________________
Anubhav Kumar
http://anubhavtimepass.blogspot.com/





Similar Threads
Thread Thread Starter Forum Replies Last Post
help in updation sanjeev jha Classic ASP Basics 0 November 12th, 2007 04:17 AM
how to execute the cursor for online data entries madhuri.sirsat SQL Server 2000 2 April 13th, 2005 11:03 PM
Online Updation qazi_nomi Classic ASP Basics 12 September 24th, 2004 07:26 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.