[RESOLVED] c# stored procedures and datasets

[DARTHTAMPON]

these are the lines I am using to acces my stored procedure.


mdfData.declareSqlCommand("myStoredProcedure");
mdfData.addParam("thisor", thisor);
mdfData.addParam("orthat", orthat);
mdfData.ExecuteSQL();


It should return a list of records that contain recordId and a different count.


mdfData.ExecuteSQL(); returns the relevent information but how do I get it from there into a dataset.

[Ubik]

response.write "<ol>"
While not mdfData.eof and not mdfData.bof
response.write "<li>" & mdfData.Fields("thisor") & "</li>"
wend
response.write "</ol>"

[DARTHTAMPON]

Thanks for your help