viren singh

viren singh

  • NA
  • 1
  • 0

Needing to reference a string into insert statement

Dec 23 2009 3:37 PM

I havent programmed with vb.net for quite some time and needing some assitance probably easy just cant figure it out
cmd.CommandText = sqlqry2
Dim dr2 As OracleDataReader = cmd.ExecuteReader()
dr2.Read()
Dim parent As String = (dr2.Item("parent_user_id"))
MsgBox(parent)

Dim sqlinsert As String = "INSERT INTO user_tracker (sequence_id,transaction_id,backend_id,user_id,customer_id,domain_name,service_id,action,backend_status,sales_channel,status_time,PASSWORD) VALUES (user_tracker_seq.NEXTVAL,'PRVMNT','PSI'," + "'" + TextBox13.Text + "'," + " &parent&)
 
i need to reference the parent string value into my insert should be easily done.

Answers (1)