how to call stored procedure with parameters

public readonly static string FREIGHTHEAD = "SELECT SR.ApprovalNumber ,SR.Remarks SRRemarks," +
" P.Description PDescription,SP.Description SPDescription,U.FirstName UFirstName, L.Description LDescriptionFrom, " +
" LO.Description LODescriptionTo,cn.OriginalContainerNumber ContainerNumber FROM SeaFreightApprovalRateDetails SR INNER JOIN SeaFreightApproval S ON " +
" SR.SeaFreightApprovalId=S.Id LEFT JOIN Party P ON SR.PartyId=P.Id LEFT JOIN Shipments SP ON S.ShipmentId=SP.Id " +
" LEFT JOIN Users U ON SR.ApprovedById=U.Id LEFT JOIN Locations L ON S.FromLocationId=L.Id LEFT JOIN Locations LO ON" +
" S.ToLocationId=LO.Id INNER JOIN Containers cn ON S.ContainerId=cn.Id WHERE S.ContainerId=@_ContainerId";

previously am using a query like this by passing parameter

Now i want to call stored procedure how to pass the parameters to that stored procedure

public readonly static string GETINVOICEHEADERREPORT = "EXEC SP_GetInvoiceHeaderReport"

1 Reply

Know the answer? Post it — somebody with the same question will find it here.