Update Oracle table without DataGrid

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
 
G

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

Mark Fresa

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top