Returning Values from a Stored Procedure

kadjw · September 13th, 2006, 11:02 AM

Hi

I was wondering whether someone could provide a little assistance. I am pretty familiar with SQL and ASP.NET2 and how to return columns from a stored procedure to my ASP.NET2 pages.

But how would I return values produced from functions such as COUNT() within a stored procedure? e.g.

Code:

SELECT COUNT(DISTINCT store_name)
FROM Store_Information

Many thanks

Kadj

dparsons · September 13th, 2006, 12:08 PM

if you run the stored procedure through query analyzer you will notice that a column is returned from the Count function.

What you would do is populate a datatable with the results of the stored procedure, and to access the value in your example you would do:

datatable.rows(0).item(0)

Alternatively you can also use Output parameters in a stored procedure which is a little less cumbersome.

"The one language all programmers understand is profanity."