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!

 

[Korach]

What exactly would you like to do? I work a lot with stored procedures but not like you wrote.
Look at the DataAdapter and OledbCommand classes.

 

[ThatRickGuy]

Korach, that looks like the VB6/ADO way of getting a recordset(rsGetNotes) from a stored procedure(GetNotes).

Harley, This might point you in the right direction

Dim ocmd As OleDb.OleDbCommand
ocmd.CommandType = CommandType.StoredProcedure
ocmd.CommandText = "GetNotes"
Dim dataReader As OleDb.OleDbDataReader = ocmd.ExecuteReader

-Rick

----------------------

http://www.ringdev.com

 

[HARLEY12]

Thanks guys! Yes I needed to use commandtext to get it to work correctly.