VB.Net Frontend with Oracle Backend - Data Insertion
By Prof.Sreeparna Chakrabarti
Assistant Professor, Department of Computer Science, Kristu Jayanti College(Autonomous), Bangalore
To download ODT with ODAC:
https://www.oracle.com/in/database/te...
Code:
Dim name As String = TextBox1.Text
Dim reg As String = TextBox2.Text
Dim conn As OracleConnection = New OracleConnection("DATA SOURCE=DESKTOP-82BNM1J;DBA PRIVILEGE=SYSDBA;USER ID=SYS;PASSWORD=sys")
Dim cmd As OracleCommand = New OracleCommand()
cmd.CommandText = "Insert into TEST.STUDENT values('" + name + "','" + reg + "')"
cmd.Connection = conn
Try
conn.Open()
cmd.ExecuteNonQuery()
MessageBox.Show("Data Inserted Successfully")
Catch ex As Exception
MessageBox.Show("Failed to insert Data: ", ex.Message)
Finally
conn.Close()
End Try