I am embedding a SQL editor in my company's existing program to allow our clients to easily run queries against our database. The current layout is a textbox where they type in the code and a Datagridview.
The problem I am having is that it is conceivable that a query they enter will return a lot of records, freezing up the GUI. What I want to be able to do is execute the sql through a DbReader object and feed the Datagridview 1 record (or maybe 10 records, possibly even 100 records) at a time as it gets read by the DbReader so that even a query with a million results will show up. Any ideas?
Thanks in advance.
-Luis
The problem I am having is that it is conceivable that a query they enter will return a lot of records, freezing up the GUI. What I want to be able to do is execute the sql through a DbReader object and feed the Datagridview 1 record (or maybe 10 records, possibly even 100 records) at a time as it gets read by the DbReader so that even a query with a million results will show up. Any ideas?
Thanks in advance.
-Luis