Read data from dataset and update 3 different databases

S

shyamspandey

Hi there!

I'm a newbie in this area and have assigned, appears to be, tough task.
Please help me out.

I have to update 3 different database server(Sybase / MYSQL / MS SQL)
using a client webservice.Client has one tool that can push the new
records(Products) time to time and webservice(at client end) will keep
the records in the cache.Please let me know how to read the dataset
from cache and how to store the records in a xml file at disk or how to
update the databases that has totally different structure then the
generated xml file.Please advice.

FYI:

Public Function WinUploadFile(ByVal UserID As String, ByVal Password As
String, ByVal DS As DataSet, ByVal Rebuild As Boolean) As Boolean
Try
If CheckUserIDandPassword(UserID, Password) Then
Dim cs As New ClientSpecific(UserID, Password)
cs.SubmitInventoryUploadDS(DS, Rebuild)
Else 'bad credentials
Return False
End If
End Try
End Function

Would highly appreciate prompt response!

With Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top