Re: DataSet to Database help

From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 09/27/04 

Date: Mon, 27 Sep 2004 11:40:54 -0700

I expect you're going to have to generate INSERT statements for the inbound
data to add rows to the local DBMS. 

-- 
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Strider" <Strider@discussions.microsoft.com> wrote in message 
news:9B38652D-14DC-4474-8BB7-EAC135C415DB@microsoft.com...
> Hey guys,
> i need some advice on the best way to go about doing something.
>
> Through my web service i return a DataSet to my handheld application.
> The DataSet contains several tables of data.
> I want to append this data to the tables in database i have on the 
> handheld.
>
> Im unsure as the best way about implementing such a situation.
>
> One idea i has was to extract each table individually out of the returned
> dataset and put it in its own dataset and update each table using the code
> below:
>
>    quote:
>
>
> conn2 = New
> SqlConnection("server=(local);Trusted_Connection=yes;database=Testy")
> conn2.Open()
> Dim da2 As New SqlDataAdapter("SELECT * FROM Routes", conn2)
> Dim x As SqlCommandBuilder = New SqlCommandBuilder(da2)
>
> da2.Update(ds1, "Routes")
>
>
> Is this a good idea, or would it work correctly.
>
> Cheers for any help
>

Relevant Pages