I was using SQL Express but I have to convert all the things into MySQL now, and I get all kind of Syntax errors

 <asp:SqlDataSource ID="YazarSoyadinaGore" runat="server" 
ConnectionString="<%$ ConnectionStrings:HalamKutuphane %>"

        SelectCommand="SELECT[ID], [TasnifNo], [DemirbasNo], [YazarAdi],
 [YazarSoyadi], [KitapAdi], [TamamlayiciAdi], [Ceviren], [BasimKaydi], 
[BasimTarihi], [BasimYeri], [YayinEvi], [SayfaNo] FROM [Kitaplar] 
WHERE ([YazarSoyadi] LIKE '%' + @YazarSoyadi + '%')">

        <SelectParameters>

            <asp:ControlParameter ControlID="TextBoxYazarSoyadi" 
Name="YazarSoyadi" PropertyName="Text"

                Type="String" />

        </SelectParameters>

    </asp:SqlDataSource>

This is the working version with SQLExpress but I could only find that in MySQL column names should not be in brackets

 <asp:SqlDataSource ID="YazarAdinaGore" runat="server" 
ConnectionString="<%$ ConnectionStrings:testKutuphaneMySQL %>" 
        ProviderName="<%$ ConnectionStrings:testKutuphaneMySQL.ProviderName %>"
        
SelectCommand="SELECT ID, TasnifNo, DemirbasNo, 
YazarAdi, YazarSoyadi, KitapAdi, TamamlayiciAdi, Ceviren, 
BasimKaydi, BasimTarihi, BasimYeri, YayinEvi, SayfaNo 
FROM kitaplar WHERE (YazarAdi LIKE '%' + @YazarAdi + '%')">

        <SelectParameters>
            <asp:ControlParameter ControlID="TextBoxYazarAdi"
 Name="YazarAdi" PropertyName="Text"
                Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>

How can I show the SelectParameter in MySQL?

http://weblogs.asp.net/marcio/archive/2009/05/09/sqldatasource-mysql.aspx?CommentPosted=true#commentmessage

SELECT * FROM conteudo WHERE Titulo LIKE Concat('%', ?Texto, '%')

just change the SQL query and SQLDataSource works with MySQL too