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.

Ankit Sharma · Answer

hi, You can insert the image path same as you insert any other data. If that image path is working correctly from one table in your DB then it will certainly work correctly with another table also. Few references https://stackoverflow.com/questions/416881/insert-picture-into-sql-server-2005-image-field-using-only-sql https://stackoverflow.com/questions/13237623/copy-data-into-another-table Please try this and let me know.

Kasuni Abegunawardana · Answer

Sure.Thank you. I have another doubt. I inseted an image in DB properly and i retrive it into to gatagrid as well. I want to insert that data again into another table. I did it to other data but i have no idea how to insert the image view path again protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) { string sValue1 = GridView1.SelectedRow.Cells[1].Text; string sValue2 = GridView1.SelectedRow.Cells[2].Text; string sValue3 = GridView1.SelectedRow.Cells[3].Text; string sValue4 = GridView1.SelectedRow.Cells[4].Text; string sValue5 = GridView1.SelectedRow.Cells[5].Text; string sValue6 = GridView1.SelectedRow.Cells[6].Text; string sValue7 = GridView1.SelectedRow.Cells[7].Text; string sValue8 = GridView1.SelectedRow.Cells[8].Text; string sValue9 = GridView1.SelectedRow.Cells[9].Text; string sValue10 = GridView1.SelectedRow.Cells[10].Text; string sValue11 = GridView1.SelectedRow.Cells[11].Text; string sValue12 = GridView1.SelectedRow.Cells[12].Text; string sValue13 = GridView1.SelectedRow.Cells[13].Text; string sValue14 = GridView1.SelectedRow.Cells[14].Text; string sValue15 = GridView1.SelectedRow.Cells[15].Text; string sValue16 = GridView1.SelectedRow.Cells[16].Text; string sValue17 = GridView1.SelectedRow.Cells[17].Text; string sValue18 = GridView1.SelectedRow.Cells[18].Text; string sValue19 = GridView1.SelectedRow.Cells[19].Text; string sValue20 = GridView1.SelectedRow.Cells[20].Text; string sql = "INSERT INTO TableName (insert into Consultant_tb(C_SurName,C_FirstName,C_MiddelName,C_NIC_Number,C_Gender,C_Nationality,C_Address,C_PostalCode,C_TelephoneNumber,C_MobileNumber,C_MedicalLicenceNumber,C_EmailAddress,C_Password,C_DegreeName,C_University,C_YearObtained,C_AdditionalQualification,C_Experience,C_Evidence,C_Advertisement ) values(@C_SurName,@C_FirstName,@C_MiddelName,@C_NIC_Number,@C_Gender,@C_Nationality,@C_Address,@C_PostalCode,@C_TelephoneNumber,@C_MobileNumber,@C_MedicalLicenceNumber,@C_EmailAddress,@C_Password,@C_DegreeName,@C_University,@C_YearObtained,@C_AdditionalQualification,@C_Experience,@C_Evidence,@C_Advertisement)"; try { con.Open(); SqlCommand cmd = new SqlCommand(sql, con); cmd.Parameters.AddWithValue("@C_SurName",sValue1 ); cmd.Parameters.AddWithValue("@C_FirstName",sValue2 ); cmd.Parameters.AddWithValue("@C_MiddelName",sValue3); cmd.Parameters.AddWithValue("@C_NIC_Number",sValue4); cmd.Parameters.AddWithValue("@C_Gender", sValue5); cmd.Parameters.AddWithValue("@C_Nationality",sValue6); cmd.Parameters.AddWithValue("@C_Address", sValue7); cmd.Parameters.AddWithValue("@C_PostalCode",sValue8 ); cmd.Parameters.AddWithValue("@C_TelephoneNumber",sValue9); cmd.Parameters.AddWithValue("@C_MobileNumber",sValue10); cmd.Parameters.AddWithValue("@C_MedicalLicenceNumber",sValue11); cmd.Parameters.AddWithValue("@C_EmailAddress", sValue12); cmd.Parameters.AddWithValue("@C_Password",sValue13 ); cmd.Parameters.AddWithValue("@C_DegreeName",sValue14 ); cmd.Parameters.AddWithValue("@C_University", sValue15); cmd.Parameters.AddWithValue("@C_YearObtained",sValue16 ); cmd.Parameters.AddWithValue("@C_AdditionalQualification",sValue17 ); cmd.Parameters.AddWithValue("@C_Experience", sValue18); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); } finally { con.Close(); } }

Ankit Sharma · Answer

Hi Kasuni, Since you have not shared your table definitions so i am providing a generic solution INSERT INTO consultant(Column1, Column2) SELECT Column1, Column2 FROM confrmation where U_Email = "abc" to delete the record use this DELETE FROM confrmation where U_Email = "abc" I hope you can write ADo.NET code on your own. Please remember to insert before deleting. Hope this helps

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

Answers (3)