How to use store procedure in asp classic page

Amit

I have created store procedure to retrieve data from data base .I have one drop down list.when I select item from drop down list that time related data display on asp page.help me how to display data on asp classic page and how to use store procedure in asp classic page

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramesh Barik9y ago
Accepted answer
After gettting the DB data in reord set you need to iterate the data in while loop and create dynamica trable, tr and td to show the result.

As per the presious code you can get the data in record set.
.
.
.
set oRsRecordSet =cmdCommand.execute()

While NOT oRsRecordSet.EOF

Colm1 Colm2 Colm3
oRsRecordSet("DBColumn1") oRsRecordSet("DBColumn2") oRsRecordSet("DBColumn3")

oRsRecordSet.MoveNext
wend

Check this it may help you.
Amit9y ago
I want code in asp classic page to display data when I select perticuler member from drop down list.i want to display data. In asp.net use data gridview to display data but in asp classic page how to display data.pls share code
Ramesh Barik9y ago
Function MethodName()

Set oConn = Server.CreateObject("ADODB.Connection")

oConn.ConnectionString="YourConnacctionString"
oConn.Open
dim oRsRecordSet
oRsRecordSet = server.CreateObject("ADODB.RECORDSET")
set cmdCommand = server.CreateObject("ADODB.Command")
set cmdCommand.ActiveConnection = oConn
cmdCommand.CommandType = 4
cmdCommand.CommandText = "YourProcName"
cmdCommand.Parameters.Refresh
WITH cmdCommand
.Parameters("@Param1).Value = ParamValue1
.Parameters("@Param2").Value = ParamValue2
.Parameters("@Param3").Value = ParamValue3
END WITH
set oRsRecordSet =cmdCommand.execute()
If Not oRsRecordSet.EOF And Not oRsRecordSet.BOF Then
strReturnValue=oRsRecordSet("ProcedeureReturnID")
End If
End Function

This proccedure return you a record set.
Check this it ay help you.


Colm1	Colm2	Colm3
oRsRecordSet("DBColumn1")	oRsRecordSet("DBColumn2")	oRsRecordSet("DBColumn3")