HELP with ODBC and Gridview Updating

[remondo]

I have created a GridView that selects data from a MySql database via ODBC 3.51

 

The select command works just fine as the table is being displayed properly. However, i do not know how to set the Update command manually. [You can't seem to be able to get the update feature by merely clicking on the checkbox in the advanced button - you have to do it manually if you're using ODBC].

 

some of the commands i've tried and didn't work are: (just look at the updatecommand)

 

#1

ProviderName="<%$ ConnectionStrings:bionicConnec... %>" SelectCommand="SELECT supplier_id, supplier_name, supplier_address1 from suppliers" UpdateCommand="update suppliers set supplier_name=:supplier_name where supplier_id=:original_supplier... >

 

#2

UpdateCommand="update suppliers set supplier_name=@supplier_name where supplier_id=@suppliersupplier_...

 

#3

UpdateCommand="update suppliers set supplier_name=? where supplier_id=?"

 

Please help! I'm going nuts with this problem :-)

Edited September 9, 2006 by PlausiblyDamp