Editing an existing Table Adapter
Posted: 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
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