User Profile

Collapse

Profile Sidebar

Collapse
cruncher06
cruncher06
Last Activity: Oct 10 '13, 04:43 PM
Joined: Oct 8 '13
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • cruncher06
    replied to Unable to Run an Update Query Against DB2
    in ASP .NET
    I have updated the code as follows. Do you know how I should write it. I have added the control that I am trying to update after this?

    Code:
    Dim requestId As Integer = requestDetails.DataKey.Value


        Dim newRequestTypeTextBox As TextBox = requestDetails.FindControl("editRequestTypeTextBox")
        Dim newEmployeeNameTextBox As TextBox = requestDetails.FindControl("editEmployeeNameTextBox")
    ...
    See more | Go to post

      Leave a comment:

    • cruncher06
      started a topic Unable to Run an Update Query Against DB2
      in ASP .NET

      Unable to Run an Update Query Against DB2

      Here is an update query that I am trying to run:
      Code:
      comm = New Data.OleDb.OleDbCommand("UPDATE TESTGEN.ITMGT.ACCESS_LOG SET REQUEST_TYPE=:newRequestType, EMPLOYEE_NAME=:newEmployeeName, PERM_TEMP=:newPermTemp, COMPUTER_NAME=:newComputerName, SIMILIAR_TO=:newSimilarTo, UPDATE_REASON =:newUpdateReason, PHONE_NUM=:newPhoneNumber, CONTACT_PERSON=:newContactPerson, CONTACT_NUM=:newContactNumber WHERE (RECORD_ID=" & requestId & ")",
      ...
      See more | Go to post
      Last edited by Rabbit; Oct 8 '13, 05:45 PM. Reason: Please use [CODE] and [/CODE] tags when posting code or formatted data.
      No activity results to display
      Show More
      Working...