I'm using SQL server 2000 and have

[automicgina]

I'm using SQL server 2000 and have the following stored proc:

CREATE PROCEDURE sp_get_info
( @getID smallint,
@getContent varchar(500) OUTPUT) AS

DECLARE @rc Int

SELECT @getContent = tableB.contentDescription
FROM tableA, tableB
WHERE tableA.pageID = @getID
AND tableA.typeID = tableB.typeID
ORDER BY tableB.typeID
Go

This stored proc returns a set of data. How do I show all the data in DataGrid? I tried to use list box instead but was having trouble passing the parameter for @getID.

Thanks!!

 

[SemperFiDownUnda]

SELECT @getContent = tableB.contentDescription
FROM tableA, tableB
WHERE tableA.pageID = @getID
AND tableA.typeID = tableB.typeID
ORDER BY tableB.typeID

Remove the "@getContent = " from the statement. That is redirecting your output to that variable.