Chapter 9 : TIO-0908-Details.aspx
I am having MySQL Syntax problem with SELECT...WHERE statement. The following statement produce empty result:
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
                    ProviderName="System.Data.Odbc"
                     ConnectionString="DRIVER={MySQL ODBC 3.51 Driver};
                     SERVER=localhost; DATABASE=Stockdb; UID=root; PASSWORD=blabla;OPTION=3"
SelectCommand="SELECT ItemId, ItemTitle FROM MenuItems WHERE ItemId = @'ID' ">
where as in MSSQL it works fine in SelectCommand="SELECT * FROM [authors] WHERE ([au_id] = @au_id)">

Any idea how to tackle this?

Yubmat:

That code does not match up with what I have for TIO 0908. Can you reference the page?

Have you had success with other SQL statements agaisnt this database?

Yes it works with other SQL statement but don't work with WHERE parameter!.Actually I am
working on Query String and I need the value to pass to another page. I know it works for MS SQL but not for MySQL. I am new to MySQL and need help from expert.

I'm not an expert in mySql. The book uses (and was testing against) SSE.
For mySql questions I'd suggest the Wrox books on mySQL.

Managed to solve using MySQL Connector/NET instead of Connector ODBC. Thanks.