public static void InsertMysqlDiagnosticCategory()
{
ConectarSiteds();
string query = "select cCateCode,sCateDesc from CateDiagnostico where flag = '0' order by cCateCode";
OleDbCommand commandselect = new OleDbCommand(query, Conex);
OleDbDataReader reader = commandselect.ExecuteReader();
ConnectionMySQL.Connect();
while (reader.Read())
{
ConnectionMySQL.InsertDiagnosticCategory(reader.GetString(0), reader.GetString(1));
UpdateAfterInsert("CateDiagnostico", "cCateCode", 0, reader);
}
ConnectionMySQL.Disconnect();
FinalMessage();
}