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
|