For the stored proc problem, googling reveals a similar issue that
might be of some help:
http://forums.mysql.com/read.php?98,197394,197394#msg-197394
For the binding problem, have you debugged to see if the data itself
has more than one record? Your post doesn't specify whether it's a
data problem or a control problem. Once you know which is the issue,
it should be easier for you to figure out. Also, you're setting the
data source to the DataSet object itself - don't know if this is a
problem or not, since I haven't used DataSets in a long time, but
since a DataSet is really a collection of tables, your data source
should really be the specific table where the data is, not the
collection of tables. Try using MySQLDataGrid.DataSource =
myDataSet.Tables("table1").
On Jan 20, 2:35 am, Helvin <[email protected]> wrote:
> I have tried stored procedures, but met another problemo. > <
> programming is like solving problem after problem...
> I am using MySQL, and using MySQL administrator as a GUI. When trying
> to create a stored procedure, like the one following, I often meet
> error 1607, when I hit the 'Execute SQL' button.
>
> [code]
> CREATE procedure sp_search_part_no()
> BEGIN
> SELECT customer FROM table1;
> END
> [/code]
>
> The error says" Error while executing query.
> MySQL Query number 1607.
> Cannot create stored routine 'sp_search_part_no'; Check Warnings.
>
> But I don know where I can go to check warnings.
> Does anyone know what's wrong? =/
