Connection to oracle database

Question

how can i insert data into an oracle databse?

tewarianand · Answer

I am giving small code for inserting data into oracle database : You should change the values of data source user id password. For example here i take a Student table with two fields Rno and Name dim Con As OleDb.OleDbConnection dim Qry as string Con = New OleDb.OleDbConnection(Provider=MSDAORA; Data Source = xdpi; User Id = data_sys; Password = validation) Con.Open() Qry = Insert Into Student(Rno Name) Values ( & Val(TxtRNo.Text) & ' & Trim(TxtName.Text) & ') Dim Cmd As New OleDb.OleDbCommand(Qry Con) Cmd.ExecuteNonQuery()

Adam Erstelle · Answer

Create a connection object with the proper connection string to your Oracle database. Create a command object from the connection object. Create a command (I use commandtext and SQL) and execute the command object's ExecuteNonQuery method.