This topic is locked

Stored Procedure & IF statement

11/24/2021 11:31:29 AM
ASPRunner.NET General questions
M
Mansour author

Hi

i want to know how i c

Sergey Kornilov admin 11/24/2021

Your question is incomplete

M
Mansour author 11/25/2021

Sorry it is happend by mistake

i need help in calling stored procedure, how it can using stored procedure in asprunner.net
also in calculation feild
i have to calculate salary as below

if A = 1 then salary = w + g +h * 10
else salary = w + g +h

i need to read w, g, h from data base and the result show in text field on screen and store in database.

any body can help me please.

Sergey Kornilov admin 11/25/2021

Check Calling stored procedures article in ASPRunner.NET manual.

M
Mansour author 11/25/2021

Thank you for quick response but this is for PHP not ASP
can you help me how to use it in ASPRUNNER.NET

i have table test with A,bc,d,x,y fields

my stored procuder

CREATE PROCEDURE [dbo].[test_proc]
AS
BEGIN

SELECT a,b, a + b AS X from test
END

when i make project the feild show in the list page is as query in below picture

img alt

and result same the query does not same to stored procedure also i dont know where i have to put stored procedure