Thursday, November 29, 2012

Insert or Update Data to Oracle DB with ASPX VB

Function Update_Insert_TableData(Byval InsertString as String) as System.Data.Dataset
  Dim Connection as New OracleConnection(myconnectionString)
  Dim adapter as New OracleDataAdapter(queryString,connection)
  connection.open()
  adapter.ExecuteNoneQuery()
  conneciton.Close()
  connection.Dispose()
End Function

1 comment: