con.Open();
        string query = "UPDATE interior set Name_Arabic=N'" + txtName_Arabic.Text + "',gender='" + CBgender.Text + "',NATIONALITY='" + CBNATIONALITY.Text + "',username='" + txtusername.Text + "',Time='" + txttime.Text + "',clock='" + txtclock.Text + "',note='" + txt_note.Text + "',type='" + textBox2.Text + "',Irregularities='" + txtIrregularities.Text + "',Irregularities_date='" + txtIrregularities_data.Text + "' where CIVILIDD='" + txtCIVILIDD.Text + "'";
        SqlDataAdapter sda = new SqlDataAdapter(query, con);
        sda.SelectCommand.ExecuteNonQuery();
        con.Close();

string query2 = "select * from [next] where id='" + txtCIVILIDD.Text + "'";
        SqlCommand command = new SqlCommand(query2, con);
        SqlDataAdapter adapter = new SqlDataAdapter(command);
        con.Open();