Windows Forms

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);
}

OdbcCommand cmd = new OdbcCommand();
            try
            {
                // cn.Open();
                cmd.Connection = cn;
                cmd.CommandText = "use userdb";
                cmd.ExecuteNonQuery();
                cmd.CommandText = "DROP PROCEDURE IF EXISTS add_emp";
                cmd.ExecuteNonQuery();
                
                cmd.CommandText = "CREATE TABLE emp (empno INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, first_name VARCHAR(20), last_name VARCHAR(20), birthdate DATE)";
                cmd.ExecuteNonQuery();

                cmd.CommandText = "CREATE PROCEDURE add_emp(" +
                                  "IN fname VARCHAR(20), IN lname VARCHAR(20), IN bday DATETIME)" +
                                  "BEGIN INSERT INTO emp(first_name, last_name, birthdate) " +
                                  "VALUES(fname, lname, DATE(bday));  END";

                cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
            cn.Close();
            Console.WriteLine("Connection closed.");
            try
            {
                Console.WriteLine("Connecting to MySQL...");
                cn.Open();
                cmd.Connection = cn;

                cmd.CommandText = "add_emp;";
                cmd.CommandType = CommandType.StoredProcedure;

                cmd.Parameters.AddWithValue("?lname", "Jones");
                cmd.Parameters["?lname"].Direction = ParameterDirection.Input;

                cmd.Parameters.AddWithValue("?fname", "Tom");
                cmd.Parameters["?fname"].Direction = ParameterDirection.Input;

                cmd.Parameters.AddWithValue("?bday", "1940-06-07");
                cmd.Parameters["?bday"].Direction = ParameterDirection.Input;

                //cmd.Parameters.AddWithValue("@empno", MySqlDbType.Int32);
                //cmd.Parameters["@empno"].Direction = ParameterDirection.Output;

                cmd.ExecuteNonQuery();

                            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
           
            cn.Close();
            Console.WriteLine("Done.");
        }

System.Data.Odbc.OdbcException: 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' at line 1