public static void InsertMysqlPatientOther()
{
ConectarHC();
string query = "SELECT * FROM histories WHERE flag = '0' ORDER BY hc asc";
OleDbCommand commandselect = new OleDbCommand(query, Conex);
OleDbDataReader reader = commandselect.ExecuteReader();
while (reader.Read())
{
ConnectionMySQL.Connect();
ConnectionMySQL.InsertPatientOther(reader.GetValue(0).ToString(), reader.GetValue(1).ToString(), reader.GetValue(2).ToString());
ConnectionMySQL.Disconnect();
UpdateAfterInsert("histories", "hc", 0, reader);
//MessageBox.Show(Helper.GetComplexName(reader.GetValue(1).ToString())[0] + " -- " + Helper.GetComplexName(reader.GetValue(1).ToString())[1]);
}
FinalMessage();
}
