Configuring SqlDataAdapter using stored procedure

  • Thread starter Thread starter hlam
  • Start date Start date
H

hlam

I am configuring an SqlDataAdapter using a stored
procedure (which uses UNIONS and a Temporary Table) in
Visual Studio.Net

My stored procedure consists of:

SELECT ... INTO #tbltemporary FROM... WHERE...
UNION ALL
SELECT ... FROM ... tblnormal... WHERE...
UNION ALL
SELECT ... FROM... WHERE...

SELECT #tbltemporary.colEmployeeid,
tblnormal.colthree, etc.


The data adapter configuration wizard allows me to select
the stored procedure (for the SELECT Operation), but none
of the parameters show up in the box, so that I can choose
the procedure parameters. If I go ahead and click the
NEXT button, it gives me the message: Invalid Object
Name #tbltemporary

(When I run this procedure in the Server Explorer, it runs
perfectly, returning all of the values in my last Select
statement)

Is there a way to get this working?
 
Hi "hlam"

There is also a newsgroup microsoft.public.dotnet.framework.adonet. And I
did not direct see that you had placed this question also in that newsgroup.

There are there VB language related things also but also a lot of the
questions like yours.

If I was you I would place your question too in that newsgroup.
The change that you get your answer there faster is very high.

I hope this helps you,

Cor
 
Back
Top