ASP‎ > ‎

Create a recordset from sql server stored procedure

If you have a sql server stored procedure that returns a recordset (i.e. returns a select statement), here is how you use it in an ASP page:

Dim adoCon         
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "Provider=SQLOLEDB.1;Persist Security Info=True;User ID=sa;Password=password;Initial Catalog=Database;Data Source=sqlserver"

Dim rs99
Set rs99 = Server.CreateObject("ADODB.Recordset")
set rs99 = adocon.execute("exec spGetPriceList '" & customerfeed & "'")  
Do while not rs99.eof

 

rs99.movenext
Loop
rs99.close
Set rs99=Nothing

Comments