By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,939 Members | 1,623 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,939 IT Pros & Developers. It's quick & easy.

Configuring SqlDataAdapter using stored procedure

P: n/a
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?


Nov 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Cor
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
Nov 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.