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=
riginal_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
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=
riginal_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
Last edited by a moderator: