Update Oracle table without DataGrid

[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

 

[Guest]

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!
***************************

 

[Mark Fresa]

I appreciate your help, Cowboy/Greg.
You are right on the money.
Thanks again.
Mark