DataSet / DataLink & Parameter

Zero-G. · 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 · 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. · 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 · 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.