|
-
Aug 12th, 2009, 03:32 PM
#2
Re: SQL Datagrid updating
Your code is perfectly valid for a form, I have no idea why you only found aspx results.
You can find out how many records were affected by your , I think via an argument to ExecuteNonQuery (or perhaps a property of the command). Based on what you have said it will almost certainly be 0, but you should check anyway.
Assuming that returns 0, the next step is to add a Watch for update.Parameters , and check what the values are - you may be surprised.
If that is valid too, check the data in the table to ensure that there is at least one record that exactly matches both conditions in your Where clause (including the parameter value).
Tags for this Thread
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
|