Update Oracle table without DataGrid

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Can anyone tell me how to do this? I'm relatively new to ADO.NET.
I'm using VB.NET, by the way.
Thanks
 
The code will be similar to this:

Dim conn As new OracleConnection("conn string here")

'You can actually send the SQL and not use type = stored proc
Dim cmd As new OracleCommand("name of stored proc", conn)
cmd.CommandType = CommandType.StoredProcedure

conn.Open()
cmd.ExecuteNonQuery()
conn.Dispose()

You should add a try ... finally around the execution, with the Dispose() in
the finally, but this is a fairly basic template to work with.


--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************
 
Back
Top