DataSet / DataLink & Parameter

DataSet / DataLink & Parameter

Postby 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
Zero-G.
 
Posts: 390
Joined: Sat 09 Dec 2006 12:20

Postby 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.
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Postby 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
Zero-G.
 
Posts: 390
Joined: Sat 09 Dec 2006 12:20

Postby 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.
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24


Return to dotConnect for MySQL