Hi
i fetch record from database and i update the ,
but when i click the update button it just show the msg "Data updated "
but the data cannot be update
Here my code
command = New OracleCommand("update hr_t_candidate_interview set offer_status='" & DropDownList2.Text & "',offer_loi_offer='" & dloi0.Text & "',received_dt_offer_letter='" & textBox3.Text & "',offer_letter_date='" & textBox1.Text & "',expected_joining_date='" & textBox2.Text & "',medical_fitness='" & Dstatus.Text & "',hr_medical_region='" & Dlocation.Text & "',joined_on='" & textBox4.Text & "',hr_testimonial_verified='" & DropDownList1.Text & "',remarks='" & remark.Text & "',last_followup_on='" & textBox5.Text & "' where ref_f_number='" & t1.Text & "' ", connection)
command.ExecuteNonQuery() connection.Close()
MsgBox("Data updated")
pls help me to solve this issue..
Thanks in advance