Stored Procedures - David Anderson - com.mysql.lists.dotnet

2 messages in com.mysql.lists.dotnetStored Procedures

From	Sent On	Attachments
David Anderson	23 Dec 2005 12:12
Jesse	26 Dec 2005 11:55

Subject:	Stored Procedures
From:	David Anderson (dav...@dmaassociates.co.uk)
Date:	12/23/2005 12:12:01 PM
List:	com.mysql.lists.dotnet

Hello All,

I am trying to get my head around stored procedures.

I have an SP as follows: DELIMITER $$;

DROP PROCEDURE IF EXISTS `pnetinno`.`GetLast`$$

CREATE PROCEDURE `GetLast`(OUT maxid INT) BEGIN select maxid = max(id)from rawreviews; END$$

DELIMITER ;$$

How do I write the code (in VB or C#) to get the value of maxid?