Page 1 of 1
MySqlDataSource SelectParameter
Posted: Thu 25 Dec 2008 18:45
by dooh
Hi,
How can i conver and Parameter to a ControlParameter, i mean tha value it will be set from a control.
Now i can do that but with: ObjectDataSource.
It is possible with MySqlDataSource?
Thanks
Posted: Fri 26 Dec 2008 12:13
by Shalex
Yes, this functionality is available in dotConnect for MySQL.
You can find the example of using the SqlDataSource component with ControlParameter here:
http://msdn.microsoft.com/en-us/library ... meter.aspx . The usage of MySqlDataSource is similar. The only difference is the necessity of adding the following line in your *.aspx file to register our assembly:
In this case you can use MySqlDataSource in the following way:
Code: Select all
"
selectcommand="SELECT * from dept WHERE deptno = :Title">
Fore more samples, please go to Start Menu | All Programs | Devart dotConnect for MySQL | Samples | Web. As an alternative, you can find our samples in the installation folder of our product.
Posted: Fri 26 Dec 2008 16:40
by dooh
Ok Alex,
But these steps we have to completly manually.
Is possible to do that in design time?
Posted: Sat 27 Dec 2008 10:00
by Shalex
Registering our assembly occurs automatically when you drag and drop MySQLDataSource from Toolbox in design time. But you need to make settings with ControlParameter manually as you work with Microsoft's SQLDataSource.