MySqlDataSource SelectParameter

[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

[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:

Code: Select all

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.

[dooh]

Ok Alex,

But these steps we have to completly manually.

Is possible to do that in design time?

[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.