.net datatable skips rows load(datareader)
i'm perplexing stock datatable, build localreport, controlling following: mysqlcommand cmd = new mysqlcommand(); cmd.connection = new mysqlconnection(properties.settings.default.dbconnectionstring); cmd.commandtype = commandtype.text; cmd.commandtext = "select ... left join ... where ..."; /* query snipped */ // prepared data datatable.clear(); cn.open(); // fill datatable dt.load(cmd.executereader()); // fill report rds = new reportdatasource("invoicesdataset_invoicetable",dt); reportviewerlocal.localreport.datasources.clear(); reportviewerlocal.localreport.datasources.add(rds); at indicate i beheld news deficient blank record. i've altered few conditions query relapse accurately twin rows and... surprise : news shows wholly quarrel instead two. i've attempted debug where problem i got stranded at dt.load(cmd.executereader()); when i've beheld datareader contains twin annals nonetheless datatable contains wholly one. accident, i've total an o...