Community discussion forum

Update statement for Oracle database

• • Reply

  8 months ago

  by ericson

  Jeffrey Ericson

  , United States

  Joined 10 months ago

   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:Parameter Name="COMMENTS" />
                  <asp:Parameter Name="UPDATED_BY" />
                  <asp:Parameter Name="UPDATE_DATE" />
                  <asp:Parameter Name="BEGIN_YEAR" />

   

  The stange part is that everything works fine in QueryBuilder but not when the page is running.  Please help. 

  Report abuse