ASP.NET

  <?xml version="1.0" ?> 
- <soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
- <soap:Body>
- <TN_DetailsResp xmlns="http://tempuri.org/">
  <PersNr>2</PersNr> 
  <ProjCode>2</ProjCode> 
  <CardNr>2</CardNr> 
    </TN_DetailsResp>
  </soap:Body>
  </soap:Envelope>

 Public Function UpdateCourseSubject(ByVal SubjectID As Integer, ByVal original_CourseID As Integer) As Boolean<br />
            Dim taCourseSubject As New dsTracksTableAdapters.CourseSubjectTableAdapter<br />
            Dim dtCourseSubject As dsTracks.CourseSubjectDataTable = taCourseSubject.GetDataByCourseID(original_CourseID)<br />
            If dtCourseSubject.Rows.Count = 0 Then Return False<br />
            Dim rCourseSubject As dsTracks.CourseSubjectRow = dtCourseSubject.Rows(0)<br />
            rCourseSubject.CourseID = original_CourseID<br />
            rCourseSubject.SubjectID = SubjectID<br />
<br />
            Dim rowsAffected As Integer = taCourseSubject.Update(dtCourseSubject)<br />
            Return rowsAffected = 1<br />
        End Function<br />
<br />
    End Class

UPDATE    CourseSubject<br />
SET              SubjectID = @SubjectID<br />
WHERE     (CourseID = @Original_CourseID)