please tell me the concept of delegates. I have seen from it from book but didnt get it properly.. what i read is it is a type safe object that can point to another method or multiple method in the application which can be invoked at later time.

Can't create table '.\userdb\od.frm' (errno: 150). Getting this error while creating following table in mysql... create table od(no. int,foreign key(no.) references emp(empno));

Sir I have corrected that...thanks...:)

Sir I have tried all the suggestions...and as u said i have posted in mysql but there was no reply..so i posted here...

I have a button in my form and on click of that button I am writing this code.... OdbcCommand cmd ; cmd = new OdbcCommand(abc, cn); cmd.CommandType = CommandType.StoredProcedure; cmd.ExecuteNonQuery(); I have made a procedure named abc in database which is returning only one row from login table..So i am just checking that on click of that button my procedure should run but while debugging when i come to cmd.ExecuteQuery() it throws following error.. ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.0.77-community-nt]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 'abc()' at line 1. So plz tell me what would be the problem..

I have a button in my form and on click of that button I am writing this code.... OdbcCommand cmd ; cmd = new OdbcCommand(abc, cn); cmd.CommandType = CommandType.StoredProcedure; cmd.ExecuteNonQuery(); I have made a procedure named abc in database which is returning only one row from login table..So i am just checking that on click of that button my procedure should run but while debugging when i come to cmd.ExecuteQuery() it throws following error.. ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.0.77-community-nt]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 abc() at line 1. So plz tell me what should be the problem.

I have a button in my form and on click of that button I am writing this code....
<pre>
OdbcCommand cmd ;
cmd = new OdbcCommand("abc", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();

I have made a procedure named abc in database which is returning only one row from login table..So i am just checking that on click of that button my procedure should run but while debugging when i come to cmd.ExecuteQuery() it throws following error.. ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.0.77-community-nt]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 'abc()' at line 1. So plz tell me what should be the problem.

Sir I had already posted all the things in my post....

I had seen that from original mysql query browser...but as u said i deleted that ' ' from procedure name and then tried but found the same error...

This is my procedure abc..

DELIMITER $$

DROP PROCEDURE IF EXISTS `userdb`.`abc`$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `abc`()
BEGIN
select * from login;
END$$

DELIMITER ;

Sir there is no problem with my stored procedure..It is working fine in database..when i call through c# it throws error...

OdbcCommand cmd;
cmd = new OdbcCommand("abc", cn);
cmd.CommandType = CommandType.StoredProcedure;
OdbcDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
string s = dr.GetString(0);
}

after doing this I am getting the same error after line cmd.commandtype=cmd.executereader... now what should i do..it says odbcexception was unhandled..

ya i know....but till that point code should run correctly....I am just checking...

I have a button in my form and on click of that button I am writing this code....

OdbcCommand cmd ;
cmd = new OdbcCommand("abc", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();

I have made a procedure named abc in database which is returning only one row from login table..So i am just checking that on click of that button my procedure should run but while debugging when i come to cmd.ExecuteQuery() it throws following error..

ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.0.77-community-nt]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 'abc()' at line 1.

So plz sort out the problem as soon as possible...

I have deleted the bday option but again same issue.....and con.open() is not an issue.... and i have checked sp for its existence....no issue....

ya I have done this....bt nothing happened...same error shows.... ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.0.77-community-nt]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 'add_emp(@fname, @lname, @bday)' at line 1

thanks...somehow i managed with other logic.....:)

private void rtb_leave(object sender, EventArgs e)
{
Class1.query = rtb.Text;
}

private void InitializeComponent()
{
this.rtb = new System.Windows.Forms.RichTextBox();
this.rtb.Leave += new System.EventHandler(this.rtb_leave);
}

I have done this coding...But leave event is not working..what is the problem??

Actually the thing is I am testing it...I am developing mysql query browser. so when i am calling sp at run time then also i m getting same error...so i have searched on net c# code for calling sp..and i have got this code but when i implemented this then it throws the same error.....

I have corrected it but it didnt solve my problem..