Editing an existing Table Adapter

Editing an existing Table Adapter

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


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?

Posts: 390
Joined: Sat 09 Dec 2006 12:20

Postby Alexey » Mon 21 May 2007 09:23

What version of MySQLDirect .NET do you use?
Could you send me a test project?
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Return to dotConnect for MySQL