problem calling parametrized stored proc mysql
Posted: Fri 10 Oct 2008 23:31
Can someone please explain why the following code does not work. I'm trying to call a parametrized stored procedure to mysql. This is the error I get: Table 'instruments.insert_usequity_easy_to_borrow' doesn't exist. It thinks it's a table, not a stored proc:(
Appreciate any help.
Thanks,
Vlad
cmd = new MySqlCommand("insert_usequity_easy_to_borrow");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("symbol", MySqlType.VarChar, 10, "symbol");
cmd.Parameters.Add("isEasyToBorrow", MySqlType.Bit, 1, "isEasyToBorrow");
cmd.Connection = conn;
MySqlDataAdapter adapter = new MySqlDataAdapter();
adapter.UpdateCommand = cmd;
adapter.InsertCommand = cmd;
adapter.Update(_ds, "USEquityEasyToBorrow");
Appreciate any help.
Thanks,
Vlad
cmd = new MySqlCommand("insert_usequity_easy_to_borrow");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("symbol", MySqlType.VarChar, 10, "symbol");
cmd.Parameters.Add("isEasyToBorrow", MySqlType.Bit, 1, "isEasyToBorrow");
cmd.Connection = conn;
MySqlDataAdapter adapter = new MySqlDataAdapter();
adapter.UpdateCommand = cmd;
adapter.InsertCommand = cmd;
adapter.Update(_ds, "USEquityEasyToBorrow");