passing stored procedure

shoakat · July 15th, 2004, 09:14 AM

Hi, I want to pass store procedure employeeID, the output in the asp page should be Employeefull Name, orderNumber, customerName, orderdate,unitprice

happygv · July 15th, 2004, 09:20 AM

Hi There,

Create procedure in your SQL server as follows.

Code:

Create procedure Procedure_Name(@EmpId Int)
as
Select Emp_Name, ThisColumn, ThatColumn, AnyColumn from AnyTable where EmpId = @EmpId
return

In your ASP page

Code:

'Your connection object code
'Your Recordset object Code
RecordSetObj.Open "Execute Procedure_Name @EmpId = 100"
If not RecordSetObj.EOF then
Response.write RecordSetObj("EmpName")
Response.write RecordSetObj("ThisColumn")...

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection