Hallo everybody,

I wrote a stored procedure that executes on the MS-SQL Server.

I would like to store the returned set of attributes in a variable that I can retrieve in my C# application. The procedure code looks like this:

CREATE PROCEDURE Select_InnerJoin_Memo
AS
SELECT Memo.Title, Memo.Body, Status.Status, Users.UserName AS
Author FROM Memo INNER JOIN Users ON Memo.MadeBy = Users.Id INNER JOIN Status ON Memo.Status = Status.Id
GO
EXECUTE Select_InnerJoin_Memo

The procedure returns the required results on the server but now I would like to get the returning attributes into a table variable so I can later use it in C# and fill a DataGridView. I allready declared a table variable like:

DECLARE @ResultSet TABLE
(
Title char(50),
Body char(50),
...
)

and put the '@ResultSet' = after the SELECT keyword but with no success .


Any help?

Thank you

Please check the following tutorials:

Walkthrough: Displaying Data Using a Stored Procedure in the GridView Web Server Control
http://msdn.microsoft.com/en-us/libr...y1(VS.80).aspx

How to display data using the .NET GridView Control, stored procedures, ASP.NET 2.0 and VB.NET
http://www.aspnettutorials.com/tutor...spnet2-vb.aspx

__________________
Om Prakash Pant
Click the "Thanks" button if this post helped you.

That's it !
Thank you very much.