"Failed to get schema for this stored proceure"

[DC Gringo]

I'm trying to configure an SqlDataAdapter to a stored procedure that has no
recordsets, but rather a handful of output parameters. VS.Studio gives me
"Failed to get schema for this stored procedure"

 

[William \(Bill\) Vaughn]

I just dragged a fairly complex SP with mostly output parameters from the
server explorer to the form and the IDE built a correct Command object for
it.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

 

[DC Gringo]

Bill,

Ok, I tried the same thing but to no avail. Do I need a data adapter if
there are no recordsets and only parameters? All I got was a connection and
a command object.

_____
DC G

 

[William \(Bill\) Vaughn]

The only reason to use a DataAdapter is to populate the DataSet with the
rowsets from SELECT statements.
That's all you need--a Command object and its associated connection.


--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________