Originariamente inviato da giando877
guarda non l'ho neanche provata ma a naso io farei così

SelectCommand="SELECT * FROM tbl_1 WHERE 1 AND siglaunita like '%' + ? + '%'"

dico scempiaggini?
Grazie mille, ma va in errore:


SelectCommand="SELECT * FROM tbl_1 WHERE 1 AND siglaunita like '%' + ? + '%'"

Server Error in '/' Application.
--------------------------------------------------------------------------------

ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.0.45-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+ 'XQ00' + '%'' at line 1
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.Odbc.OdbcException: ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.0.45-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+ 'XQ00' + '%'' at line 1