WebService DataSet
From: Strider (Strider_at_discussions.microsoft.com)
Date: 09/27/04
- Next message: Bill Wanschura: "RE: Multiple Access database connections"
- Previous message: Strider: "Copy DataTable to Another DataSet"
- Next in thread: Val Mazur: "Re: WebService DataSet"
- Reply: Val Mazur: "Re: WebService DataSet"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 27 Sep 2004 04:49:12 -0700
In my WebService i return a DataSet. However when i try an add a table from
this dataset into the database it does not work. It is very frustrating. Here
is what im trying to do. I create a seperate dataset so i can update each
table in the database serperately.
Dim webserv As New pmlDBService
Dim myds As New DataSet
Dim mydt As New DataTable
myds = webserv.GetFullTables()
mydt = myds.Tables("Routes").Copy
ds1.Tables.Add(mydt)
Dim da2 As New SqlDataAdapter("SELECT * FROM Routes", conn2)
Dim x As SqlCommandBuilder = New SqlCommandBuilder(da2)
da2.Update(ds1, "Routes")
- Next message: Bill Wanschura: "RE: Multiple Access database connections"
- Previous message: Strider: "Copy DataTable to Another DataSet"
- Next in thread: Val Mazur: "Re: WebService DataSet"
- Reply: Val Mazur: "Re: WebService DataSet"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
