Question How to call a stored procedure in a method to get the result in an array list?

[somayehsol]

I need to call a stored procedure in one method to get the data and display it in one column of html table. the rest of columns are displayed by another methods and actionresults. (it's a mvc repository application). right now I can show the result of stored procedure in grideview, each column is a part of select statement. Could you please help me to show the result of a stored procedure (just one column in select statement) to be return in a get method ?
Thanks.

 

[BitLost]

Select column from table