how do i call a sql function from my asp.net project?

Question

This is my function:

create function fn_Inventory(@qty int, @item_ID int)  
returns int
as begin
    declare @result int

    set @result = (SELECT Quantity - @qty from Items where @item_ID = item_ID)
    return @result
end

And I want to execute this function from my asp.net code; how to do it?

like [this](http://forums.asp.net/t/1612546.aspx?How+to+Call+SQL+function+from+ASP+net+application+) — Grundy, Dec 10 '14 at 07:26
duplicate of http://stackoverflow.com/questions/17047057/calling-sql-defined-function-in-c-sharp — Saravana Kumar, Dec 10 '14 at 07:29

score 0 · Accepted Answer · answered Dec 10 '14 at 07:32

public int TotalCupom(int qty,int item_ID)
    { 
        int result;           
        SqlDataAdapter da2 = new SqlDataAdapter();
        if (conex1.State == ConnectionState.Closed)
        { conex1.Open();}
        SqlCommand Totalf = new SqlCommand("SELECT dbo.fn_Inventory(@qty,@item_ID)", qty,item_ID);
        SqlParameter _qty= new SqlParameter("@qty", SqlDbType.Int);
        SqlParameter _item_ID= new SqlParameter("@item_ID", SqlDbType.Int);
        _qty.Value = qty;
        _item_ID.Value = item_ID;
        result= Totalf.ExecuteScalar();


        return result;
    }

how do i call a sql function from my asp.net project?

1 Answers1