create or alter procedure select_profile_data @id int as begin select COUNT (*) from Table1 where U_ID=@id, select COUNT (*) from Table2 where U_ID=@id end ; I want to use the data individually from both of these select statements. So, how can I call this procedure from my ASP MVC action and how to implement the data that return from the procedure?

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.

https://stackoverflow.com/questions/39587606/how-to-call-and-execute-stored-procedures-in-asp-net-mvcc

Answers

Call Procedure from asp.net MVC

Amit Kumar

602

create or alter procedure select_profile_data
@id int
as
begin
select COUNT(*) from Table1 where U_ID=@id,
select COUNT(*) from Table2 where U_ID=@id
end;

I want to use the data individually from both of these select statements.

So, how can I call this procedure from my ASP MVC action and how to implement the data that return from the procedure?

Answers (2)

Next Recommended Forum

using MS word in Asp.net webapplications

Event does not wire up in aspx page

Leaderboard

View all

Tuhin Paul

John Godel

Dashrath Hapani

View all

Yesterday's leader

Tuhin Paul

India

302.2k

29.1k

100

Member of the month

Shafaet Hossain

C#, .NET, ASP.NET, Blazor

Dhaka (Bangladesh)

706

10.1k

1.3k

Speaker of the month

Shubhankar Banerjee

Blockchain, Solidity, Polygon, C#, NodeJS, HTML, C Language, C++, JavaScript, CSS, ReactJS, MySQL

Kanpur (India)

158

118.1k

11.9k

500

Upcoming events

View all

Suggested for you

View all

Shiv Gupta

Vipul Kumar

Saksham Gupta

Gayatri Joshi

Rajashekar Syereddy

Forum Statistics

Please welcome our newest member Jonathan Forrider.
3,078,601 users have contributed to 147,418 threads and 483,404
In the past 24 hours, we have 11 new threads, 29 new posts, and 64 new users.
In last week, the most popular thread is 'Get 24 months rollover value from database'.