Returning Results from a Stored Procedure to a Recordset

[HARLEY12]

How is this done in VB.Net? I have the following code but it is not working:

rsGetNotes.Open("GetNotes"), CN, ADODB.CursorTypeEnum.adOpenStatic)

I would have thought that the results of this recordset would now be located in rsGetNotes.Fields(0).value, but the recordset never even opens. What am I doing wrong?

Thanks!

 

[SQLBill]

You need to post in the appropriate forum. This is for Microsoft SQL Server. Please post your query in a VB.Net forum.

-SQLBill

Posting advice: FAQ481-4875