Error creating dataset from stored procedure with temp table
Hi,
Could you post your code, which calls SP?
--
Val Mazur
Microsoft MVP
Quote:
> Already did that. The problem isn't that I get an empty
> dataset...the problem is an error that is thrown by
> ADO .NET when I try to fill the dataset.
> >-----Original Message-----
> >Hi,
> >Try to add SET NOCOUNT ON as a very first statement in
> your stored
> >procedure. It should help
> >--
> >Val Mazur
> >Microsoft MVP
> >> I am creating a dataset using the VS.NET IDE. When I try
> >> to create a dataset from a stored procedure that selects
> >> data from a temp table, I get the following error:
> >> "Retrieving the schema for SQLDataAdapter1 failed.
> >> Invalid Object name '#temptable' "
> >> I am new to ADO.NET and still trying to figure it out.
> >> This is sorta perplexing :-). The stored procedure works
> >> fine and returns a valid cursor. Does anybody know whats
> >> going on here? Is this a bug in ADO.NET or something?
> >.
