Devart Forums

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

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.

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

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.