Why does my if statement always go to else condition in foreach loop, even though value of jml in database is 5
foreach (DataRow dr in dt.Rows)
{
nohp = Convert.ToString(dr[1]);
idpasien = Convert.ToString(dr[0]);
jml = Convert.ToString(dr[2]);
Cursor.Current = Cursors.WaitCursor;
if (jml=="5")
{
MySqlCommand cmd3 = new MySqlCommand("UPDATE datapasien SET JmlKirim='1' Where PasienID='" + idpasien.Trim() + "'", con);
cmd3.ExecuteNonQuery();
terkirim = terkirim + 1;
}
{
MySqlCommand cmd3 = new MySqlCommand("UPDATE datapasien SET JmlKirim='6' Where PasienID='" + idpasien.Trim() + "'", con);
cmd3.ExecuteNonQuery();
}
}
Aucun commentaire:
Enregistrer un commentaire