Hi all,

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

UPDATE design_details
SET id = @id
Where (id=3)

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

UPDATE design_details
SET id = 1
where (id=3)

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.