How to get select from mysql
Posted by: alon736 alonalon
Date: December 13, 2006 11:44AM

Hi all,

I'm new to Mysql and i have basic question.

i have a simple SP:
****************************************************************
DELIMITER $$

DROP PROCEDURE IF EXISTS `bdb`.`sp_GetGenderType` $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_GetGenderType`(genderType VARCHAR(255))
BEGIN
select * from tbl_Gender where tbl_Gender.GenderType=genderType;
END $$

DELIMITER ;
****************************************************************
this SP works just fine!
my problem is that i don't know how to call it from .net.
i've already created the connection from .net to mysql.
can someone write me a simple c# that gives to this sp one VARCHAR parameter and
gets a select as an output?
is this SP returns the select correctly?
10x,

Me

Options: ReplyQuote


Subject
Written By
Posted
How to get select from mysql
December 13, 2006 11:44AM
December 14, 2006 12:52AM
December 27, 2006 03:41PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.