Re: Stored procedures

[shalmi patel]

myConnection.Open();

MySqlDA.SelectCommand= new MySqlCommand("spGetCustomer ",myConnection);
MySqlDA.SelectCommand.CommandType = CommandType.StoredProcedure;

MySqlDA.SelectCommand.Parameters.Add(new MySqlParameter("?custname",MySqlDbType.VarChar,50));
MySqlDA.SelectCommand.Parameters["?custname"].Value = txtUserName.Text.ToString();
MySqlDA.SelectCommand.Parameters.Add(new MySqlParameter("?custpassword",MySqlDbType.VarChar,50));
MySqlDA.SelectCommand.Parameters["?custpassword"].Value = txtPassword.Text.ToString();
MySqlDA.SelectCommand.Prepare();

MySqlDA.Fill(objds,"CustomerMaster");

getting error
"#42000
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'spGetCustomer' at line 1
"

and my stored procedure in mysql 5.0 is:

CREATE PROCEDURE spGetCustomer(custname varchar(100),custpassword varchar(20))
begin
select CustomerID,CustomerName,ContactID,CustomerEmailID
from customerMaster
where CustomerName=custname and CustomerPassword = custpassword;
end

its working properly with mysql client command.

but giving error when i m calling it from my asp.net application.

any solution ?????