public static void InsertMysqlDoctor()
{
ConectarTarifario();
string query = "select * from medicos where flag = '0' and dni <> '0' order by dni";
OleDbCommand commandselect = new OleDbCommand(query, Conex);
OleDbDataReader reader = commandselect.ExecuteReader();
ConnectionMySQL.Connect();
while (reader.Read())
{
ConnectionMySQL.InsertDoctor(reader.GetValue(0).ToString(), reader.GetString(1), reader.GetString(2), reader.GetString(3));
UpdateAfterInsert("medicos", "dni", 0, reader);
}
ConnectionMySQL.Disconnect();
FinalMessage();
}
