[pravvi]

Hi can anyone tell me how exactly do i insert values into my backend(sql-oracle 10g) using my front end? (vb6)
mine is a simple code:

Dim con As New ADODB.Connection
Dim rs As New ADODB.Recordset

Private Sub Combo1_Change()
Combo1.AddItem "Web Content Development", 0
Combo1.AddItem "Client and Server Side Scripting", 1
Combo1.AddItem "Network Security Configuration", 2
Combo1.AddItem "Web Server, E-Commerce Development", 3
End Sub

Private Sub Command1_Click()

End Sub

Private Sub Form_Load()
con.Open "employees", "username", "password"
rs.Execute "insert into projects(prjcode,prjname,teamsize)values(" & Val(Text1.Text) & "," & Val(Text2.Text) & "," & Val(Text3.Text) & ") ", con, adOpenDynamic, adLockBatchOptimistic 

i have left command1 blank because i don't know what to write there...i want my program such that, during runtime i insert values in textbox and when i click the command button, a new column is added into the table projects

[maj3091]

Your starting point is opening the database, so have a look at this link for connection string to Oracle.

Have a look at this link for using vb6 to access oracle.

The tutorial was found at the top of the google search for "VB6 and Oracle".

[BobRodes]

Personally, I would use the command object for this. Recordsets are meant for select queries.