AnonymousJones
New member
- Joined
- Mar 27, 2008
- Messages
- 2
First off, Im not a database guy. My background is in C/C++ and Im just getting the hang of this C# stuff. With that being said Im 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 dont include a WHERE clause or it wont update any rows at all.
To give you an overview of what Im 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 doesnt 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 cant 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.
Heres 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 dont include a WHERE clause or it wont update any rows at all.
To give you an overview of what Im 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 doesnt 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 cant 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.
Heres 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.
