How to use store procedure in asp classic page

Question

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

Ramesh Barik · 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() Colm1 Colm2 Colm3 While NOT oRsRecordSet.EOF oRsRecordSet("DBColumn1") oRsRecordSet("DBColumn2") oRsRecordSet("DBColumn3") oRsRecordSet.MoveNext wend Check this it may help you.

amol · Answer

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 Barik · Answer

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.