DataSet / DataLink & Parameter

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

DataSet / DataLink & Parameter

Post by Zero-G. » Wed 23 Jan 2008 14:16

Hey

I use your latest building & played around with VB.NET 2005

I've created a DataSet with the DataSet Designer. - Using providerspecific DataSet = True.

I use 3 Tables
Master Table -> Kundenstamm
Child Table -> AuftragA
Child Table -> AuftragB

The Child Tables have a relation to the Master Table. - This way works fine.
Now I change the Childtables Select Statement and added a parameter.

How can I access this parameter, so that the DataSet is filled correctly!?

THX

Alexey.mdr
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Post by Alexey.mdr » Thu 24 Jan 2008 10:21

To fill a provider-specific DataSet with method that differs from standard, you need to create a new MySqlDataAdapter.

After that insert a proper SELECT statement with parameters into the adapter. Now you can fill MyDirect .NET DataSet with this adapter.

Zero-G.
Posts: 390
Joined: Sat 09 Dec 2006 12:20

Post by Zero-G. » Thu 24 Jan 2008 11:56

Hey

THX for this information. - When I try it out, I found a tricky situation in the DataSet Designer.

I have used a Select Concat Statement at design time (because no updates where needed) - This is something, the designer can't solve.
So, how should I work with things like that!?

THX

Alexey.mdr
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Post by Alexey.mdr » Fri 25 Jan 2008 12:15

We couldn't reproduce the error. There is no known issues with “SELECT CONCAT” statement.

Please send me a small test project to reproduce the problem.
It is desirable to use 'test' schema objects, otherwise include the
definition of your own database objects.
Do not use third party components.
If it is impossible for you to create the test project, send us a piece of
your code where the error occurs.

Post Reply