-
January 5th, 2010, 02:59 AM
#1
Unable to update table using Strongly Typed TableAdapters and DataTables in VS 2008
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.
Raghu
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|