Bug #29098 TableAdapter Wisard closed wher adding one new (stored procedure)
Submitted: 14 Jun 2007 6:09 Modified: 15 Jun 2007 8:37
Reporter: Psy After Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / NET Severity:S2 (Serious)
Version:5.1.2 OS:Microsoft Windows (xp sp2 .net 1.1, 2.0, 3.0)
Assigned to: CPU Architecture:Any

[14 Jun 2007 6:09] Psy After
Description:
When i try to add new TableAdapter based on stored procedure, so wisard closed without any error

How to repeat:
Add new dataset
go to designer
rigth click-> Add -> TableAdapter 
select connection (or add new)->next
check "Use  existing stored procedure" -> next
select stored procedure from list
after selecting - wizard closed
[14 Jun 2007 13:13] Tonci Grgin
Hi Psy and thanks for another report. Verified as described with MySQL server 5.0.44BK on WinXP Pro SP2 localhost using c/NET 5.1.2 and .NET fw 2.0

If I might add quotation from change log:
  - Fixed problem preventing use of stored procedures for insert, update, and
    delete statements in a table adapter.
Truly, only SELECT causes this behavior. INSERT, UPDATE and DELETE work as expected for me.
[14 Jun 2007 13:28] Psy After
yes, but I need exactly SELECT comand. And SELECT not work
its close wizard:(
all meaning in using SELECT (wizard build tableAdapter bystored procedure)
and INSERT, UPDATE and DELETE I implement by Query(not work too)
[14 Jun 2007 16:36] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/28784
[14 Jun 2007 16:37] Reggie Burnett
Fixed in 5.1.3
[15 Jun 2007 8:37] MC Brown
A note has been added to the 5.1.3 changelog.