Multiple stored procs for dataadapter

[AKJTR]

i'm trying to save on calls back to the db by combining stored procs in one
dataadapter. I know they work alone but when i combine the i get an error

" Could not find stored procedure
'usp_wp_BuildingAmenities;usp_wp_BuildingPrimaryDe tails'

for this line

Dim mydataadapter8 As New SqlDataAdapter("usp_wp_BuildingAmenities;" +
"usp_wp_BuildingPrimaryDetails;", dbconn)

I think i have tried every way of combining them and have googled every word
i thought that lead me to a solution. Can anybody help. TIA

akjtr

[Karl Seguin]

Not sure, but try adding a GO statement after each one. Also, why not just
create 1 stored procedure which calls all other stored procedure and have
your DA call that?

create procedure BuildingDetails AS

us_wp_BuildingAmeni...
Go
Us.wp_building

Also, consider making use of SqlCommands with your dataadapters..

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"AKJTR" <AK***@discussions.microsoft.com> wrote in message
news:EF**********************************@microsof t.com...

i'm trying to save on calls back to the db by combining stored procs in one dataadapter. I know they work alone but when i combine the i get an error

" Could not find stored procedure
'usp_wp_BuildingAmenities;usp_wp_BuildingPrimaryDe tails'

for this line

Dim mydataadapter8 As New SqlDataAdapter("usp_wp_BuildingAmenities;" +
"usp_wp_BuildingPrimaryDetails;", dbconn)

I think i have tried every way of combining them and have googled every word i thought that lead me to a solution. Can anybody help. TIA

akjtr