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

{

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();

}

}