How to send one table (One raw data) into another table

Question

Hi all,

 

I just wanna to send one raw data from table to table in asp.net web forms.

I have to tables consultan and confrmation.

 

Data are in the confrmation table. i wanna to send a data record according to the primary key to the consultant's table.

  

When i enter U_Email (PK in confirmation table) i wanna to delete that recode from  confirmation table and insert that record into Consultant table.

 

Thank you.