.NET (Core and Framework)

Kevin Marois wrote:

Maybe, the hit on the command could just be the initial binding.

using (var con = new System.Data.SqlClient.SqlConnection())
using (var cmd = con.CreateCommand())
{
    con.ConnectionString = "<insert your connectionstring here>";
    con.Open();

    cmd.CommandText = @"UPDATE candidate_personal_details
                           SET GUARDIAN_NAME=@GuardianName
                              ,GUARDIAN_PH_NO=GuardianPhone
                              ,GUARDIAN_MOB=@GuardianMobile
                              ,NATIONALITY=@GuardianNationality
                              ,GENDER=@GuardianGender
                              ,D_O_B=@GuardianDob
                              ,PRESENT_ADDRESS=@GuardianPresentAdress
                              ,DIST1=@GuardianDist1
                              ,PIN1=@GuardianIn1
                              ,PERMANENT_ADDRESS=@GuardianAddress2
                              ,DIST2=@GuardianDist2
                              ,PIN2=@GuardianIn1
                              ,LOCAL_GUARDIAN_NAME=@GuardianLocalName
                              ,LOCAL_GUARDIAN_ADDRESS=@GuardianAddress3
                              ,DIST3=@GuardianDist3
                              ,PIN3=@GuardianIn1
                              ,LOCAL_GUARDIAN_PH_NO=@GuardianPhone626 -- how many phones do they HAVE?
                              ,LOCAL_GUARDIAN_MOB=@GuardianMob3
                         WHERE EMAIL_ID=@GuardianMailId";
    cmd.Parameters.AddWithValue("@GuardianName", TextBox23.Text);
    cmd.Parameters.AddWithValue("@GuardianPhone", TextBox24.Text);
    cmd.Parameters.AddWithValue("@GuardianMobile", TextBox25.Text);
    cmd.Parameters.AddWithValue("@GuardianNationality", TextBox26.Text);
    cmd.Parameters.AddWithValue("@GuardianGender", TextBox27.Text);
    //..and so on for all paramenters
    cmd.ExecuteNonQuery();
    cmd.Parameters.Clear();
    cmd.CommandText = @"UPDATE educational_details
                           SET X_N_O_INSTITUTION=@X_NO_Institution
                              ,X_N_O_BOARD=@X_NO_Board
                              ,X_Y_O_PASSING=X_Y_O..
                        WHERE EMAIL_ID=@GuardianMailId");
    cmd.Parameters.AddWithValue("@GuardianName", TextBox23.Text);
    cmd.Parameters.AddWithValue("@GuardianPhone", TextBox24.Text);
    cmd.Parameters.AddWithValue("@GuardianMobile", TextBox25.Text);
    cmd.Parameters.AddWithValue("@GuardianNationality", TextBox26.Text);
    cmd.Parameters.AddWithValue("@GuardianGender", TextBox27.Text);
    //..and so on for all paramenters
    cmd.ExecuteNonQuery();
}

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

http://www.codeproject.com/Messages/3122367/How-to-get-an-answer-to-your-question.aspx[^]

9. Please do not post links to your question into an unrelated forum such as the lounge. It will be deleted. Likewise, do not post the same question in more than one forum.

Matt T Heffron wrote:

Any other expectation is akin to expecting a MAC executable to run on Linux.