Data Access Page and call stored procedure

[Guest]

I'm have created several Data Access Pages which are connecting to MS SQL
data sources, as tables and views. I'm very happy to apply this for creating
easy, fast and easy deployable webpages.

Next step I want to do is starting a stored procedure at MS SQL Server
having some parameters that will be based on a selection.

I know that I can use a stored procedure at DAP, but this is more for using
the result (table) in a datasection. This stored procedure is having logic as
deleting data and inserting new data based on a table.

Please help me. Thanks in advance

 

[Tim Ferguson]

is there nobody who can help me how to call a stored procedure via ADP
which is only executing some DELETE and INSERT statements. The result
is no recordset or neither parameters.

ADP or DAP?-- your original post referred to data access pages.

In an ADP you use the ADO library to run procedures. You can simply use the
..Execute method with the adCmdText parameter. For more control you create a
Command object, which has a Parameters collection for passing parameters
and pass it to a Recorset object to return your results.

It's all in the help files and copious tutorials on using ADO.

Hope that helps


Tim F

 

[Tim Ferguson]

I did mean DAP instead of ADP...

Have you got a solution for this?

Sorry: never used one or, frankly, understood the need for them... <g>

B Wishes


Tim F