SQL server Stored procedure is returning multiple values of same column without output parameter specified. How would I receive and show these columns in C#.
for ex , I cannot specify like this
//cmd.Parameters.Add("@manufacturer_name", SqlDbType.VarChar, 200);
//cmd.Parameters["@manufacturer_name"].Direction = ParameterDirection.Output;
if you like to see stored procedure
ALTER PROCEDURE [dbo].[getFavoriteList]
as
begin
SET NOCOUNT ON
select manufacturer_name from dbo.Favorite_list
return
endcan I able to call table valued function in output parameter or any other suggestion please?
Go to the complete details ...