Call Procedure from asp.net MVC

2 Replies

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

Nilesh Shah8y ago
Accepted answer
in the SP you need two output parameters
create or alter procedure  select_profile_data

@id int,
@count1 int OUTPUT,
@count2 int OUTPUT

as

begin

select @count1 = COUNT(*) from Table1 where U_ID=@id,

select @count2 = COUNT(*) from Table2 where U_ID=@id

end;
I suggest you create a seperate project for dealing with data, not directly from controller.
In your C# code, when you call the SP, get the value of output parameter like:
SqlParameter outputVal = new SqlParameter("@count1", SqlDbType.Int);
                    outputVal.Direction = ParameterDirection.Output;
                    command.Parameters.Add(outputVal);
note: above is just a sample code, use your own code here.

once you have values, use it like any normal variable to show in view.
+2
8y ago
https://stackoverflow.com/questions/39587606/how-to-call-and-execute-stored-procedures-in-asp-net-mvcc
-1