AnonymousJones
Newcomer
- Joined
- Mar 27, 2008
- Messages
- 2
First off, I'm not a database guy. My background is in C/C++ and I'm just getting the hang of this C# stuff. With that being said I'm setting up a DataGridView with a SqlDataSource that connects to an Oracle database.
I have my select statement working, but the update statement either updates every row in the table when I don't include a WHERE clause or it won't update any rows at all.
To give you an overview of what I'm trying to do, I want to edit comments in a table and have everything else remain the same.
There are 5 or 6 fields that make the row unique and I try to add these to my WHERE clause but it causes nothing to get updated. I also try to use just one of the values from the table in my WHERE clause and that doesn't work either.
The weird thing is that in "Query Builder" it will update the database. I can see the changes when I fire up the asp.net page, but then can't make updates to it while its running! Please help.
I want to be able to update just one row with a comment and save it back to the database without the entire database table being updated.
Here's the update statement:
UpdateCommand="UPDATE PROJECT_EOC SET COMMENTS = :COMMENTS, UPDATED_BY = :UPDATED_BY, UPDATE_DATE = :UPDATE_DATE WHERE (TO_CHAR(BEGIN_YEAR) = :BEGIN_YEAR)">
<UpdateParameters>
<asp
arameter Name="COMMENTS" />
<asparameter Name="UPDATED_BY" />
<asparameter Name="UPDATE_DATE" />
<asparameter Name="BEGIN_YEAR" />
everything works fine in QueryBuilder, but does not work when I run the application.
I have my select statement working, but the update statement either updates every row in the table when I don't include a WHERE clause or it won't update any rows at all.
To give you an overview of what I'm trying to do, I want to edit comments in a table and have everything else remain the same.
There are 5 or 6 fields that make the row unique and I try to add these to my WHERE clause but it causes nothing to get updated. I also try to use just one of the values from the table in my WHERE clause and that doesn't work either.
The weird thing is that in "Query Builder" it will update the database. I can see the changes when I fire up the asp.net page, but then can't make updates to it while its running! Please help.
I want to be able to update just one row with a comment and save it back to the database without the entire database table being updated.
Here's the update statement:
UpdateCommand="UPDATE PROJECT_EOC SET COMMENTS = :COMMENTS, UPDATED_BY = :UPDATED_BY, UPDATE_DATE = :UPDATE_DATE WHERE (TO_CHAR(BEGIN_YEAR) = :BEGIN_YEAR)">
<UpdateParameters>
<asp
arameter Name="COMMENTS" /><asp
arameter Name="UPDATED_BY" /><asp
arameter Name="UPDATE_DATE" /><asp
arameter Name="BEGIN_YEAR" />everything works fine in QueryBuilder, but does not work when I run the application.