View Single Post
Old May 16th, 2006, 02:00 AM
Hammam Hammam is offline
Registered User
Join Date: Apr 2006
Location: JUBAIL, , Saudi Arabia.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts

Yes you can

make the stored procedure and put all the inserts and updates you want and then call it

this is an example to call stored oracle procedure

Dim DBConn As OracleClient.OracleConnection = New OracleClient.OracleConnection
Dim strConnection As String

'Get connection string from Web.Config
 strConnection = ConfigurationSettings.AppSettings("ConnectionStrin g")
 DBConn.ConnectionString = strConnection

Dim AdmCom As OracleClient.OracleCommand = New OracleClient.OracleCommand("Procedure_name", DBConn)
AdmCom.CommandType = CommandType.StoredProcedure

AdmCom.Parameters().Add("p_first_name_s", Trim(FirstName.Text))
AdmCom.Parameters().Add("p_mid_name_s", Trim(SecondName.Text))
AdmCom.Parameters().Add("p_third_Name_s", Trim(ThirdName.Text))