Editing an existing Table Adapter

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Zero-G.
Posts: 398
Joined: Sat 09 Dec 2006 12:20

Editing an existing Table Adapter

Post by Zero-G. » Sat 19 May 2007 09:24

Hey

I have a Table Adapter, created by the DataSet Wizzard.
The query goes over two tables with a relation. In the item Box of the Form (vb2005) I see the following:
1 DataSet (dtsBrille)
2 TableAdapters (TableAdapterKunden, TableAdapterAerzte)
2 BindingSources (BindingSourceKunden, BindingSourceAerzte)

Now, I want to edit the SQL of the child Table(Aerzte). - When I click on to Tools->mySQL->DataSet Wizzard, and choose the DataSet (dtsBrille), I get an error, that I have to delete the relation first.
Then I wen to the DataSet Wizzar(Microsoft) and deleted the relation. - After that, I tried again, but it also did not work.

How to solve this?

THX

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Mon 21 May 2007 09:23

What version of MySQLDirect .NET do you use?
Could you send me a test project?

Post Reply