query with procedure

  • Thread starter Thread starter Dean L. Howen
  • Start date Start date
D

Dean L. Howen

I try to get the result of the procedure in C#, it seems too many results
that a procedure can return.

Example:
----------------------------------------------------------

USE Northwind
GO

CREATE PROCEDURE OrderSummary @MaxQuantity INT OUTPUT AS

SELECT Ord.EmployeeID, SummSales = SUM(OrDet.UnitPrice * OrDet.Quantity)
FROM Orders AS Ord
JOIN [Order Details] AS OrDet ON (Ord.OrderID = OrDet.OrderID)
GROUP BY Ord.EmployeeID
ORDER BY Ord.EmployeeID

SELECT @MaxQuantity = MAX(Quantity) FROM [Order Details]
RETURN (SELECT SUM(Quantity) FROM [Order Details])
GO
----------------------------------------------------

I don't know if some one could tell me, how to retrieve all the result of
this stored procedure?

Thanks
 
hi
here is the code

cnn.Open();
SqlDataAdapter cmd=new SqlDataAdapter("OrderSummary",cnn);
cmd.SelectCommand.CommandType =CommandType.StoredProcedure;
SqlParameter param=new SqlParameter ("@MaxQuantity",SqlDbType.Int,8);
SqlParameter param2=new SqlParameter ("@ret",SqlDbType.Int,8);
param2.Direction =ParameterDirection.ReturnValue ;

param.Direction =ParameterDirection.Output ;
param.Value =-1;
cmd.SelectCommand.Parameters.Add(param) ;
cmd.SelectCommand.Parameters.Add(param2) ;
DataSet ds=new DataSet ();
cmd.Fill(ds);
MessageBox.Show(param.Value.ToString ());
MessageBox.Show(param2.Value.ToString ());
MessageBox.Show(ds.Tables[0].Rows[0][1].ToString ());

regards
ansil
 
Back
Top