Unable to update table using Strongly Typed TableAdapters and DataTables in VS 2008
I am building a DAL for my mysql database intensive WPF project. The UpdateCommand for the table adapter i have set its text with parametes as input
SET id = @id
when i execute this query in Query Builder the @id parameter is taken as null no matter i set its value in Query Builder Parameters GUI and so in database also its set as null.
But when i give direct value to id like
SET id = 1
database is updated as expected with id set to 1.
I tried various ways and could not find why this happens.
Plz someone help me with this.