Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Aug 8th, 2012  |  syntax: None  |  size: 0.60 KB  |  hits: 15  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1.  
  2.     Public Shared Sub EditStudent(ByVal Id As Integer, ByVal Naam As String, ByVal Onbeschikbaar As Boolean)
  3.         Try
  4.             Dim oId As New SqlParameter("@iId", Id)
  5.             Dim oNaam As New SqlParameter("@sNaam", Naam)
  6.             Dim oOnbeschikbaar As New SqlParameter("@bOnbeschikbaar", Onbeschikbaar)
  7.  
  8.             Dim sqlStatement As String = "UPDATE Student SET @sNaam =?, @bOnbeschikbaar =? WHERE @iId = ? "
  9.  
  10.             Db.ExecuteNonQuery("AbConnectionString", sqlStatement, oId, oNaam, oOnbeschikbaar)
  11.  
  12.         Catch ex As Exception
  13.             Throw (ex)
  14.  
  15.         End Try
  16.     End Sub