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(); }