Thread: Problem with MySql Stored Procedure

it works
but can u explain the difference, ie. the above 2 lines of ur post compared to mine??
and that means that i dont have to mention the "input" direction....... thats a relief

Originally Posted by micky

it works
but can u explain the difference, ie. the above 2 lines of ur post compared to mine??

Which bit do you mean? The command definition or the parameter definition.

My guess is that the command definition fixed it. You have to specific Stored Procedure as the command type, as it defaults to CommandText ie "SELECT x FROM y"

i forgot the command definition line!!
i meant these lines

Code:

Dim EmailIDPara As MySqlParameter = Cmd.Parameters.Add("EmailId", MySql.Data.MySqlClient.MySqlDbType.VarChar)
EmailIDPara.Value = Trim(txtEmail.Text)

i have added another parameter now like

Code:

Dim PswdPara As MySqlParameter = Cmd.Parameters.Add("Pswd", MySql.Data.MySqlClient.MySqlDbType.VarChar)
PswdPara.Value = Trim(txtPassword.Text)

changed my SP as

Code:

CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_LoginCheck`(
  IN EmailId varchar(100),
  IN Pswd varchar(20))
BEGIN
  Select First_Name, Last_Name From tblUserMaster Where Email_Id=EmailId and User_Pswd=Pswd;
END

it gived me this error

Code:

Incorrect number of arguments for PROCEDURE synccity.sp_LoginCheck; expected 2, got 1

i chnaged nothing and its now working, ignore the above error