Just plinking around with the eval version - I have a couple applications that need read only views of hundreds of tables with many thousands of rows each - I'd like to be able to load a table and show a "screen full" of rows without waiting for the entire data adapter to "fill up" first - I currently just have a hard coded "top 500" clause on my queries with an option to "show all" as necessary just to reduce the pain of folks wandering around the DB (long story, can't be avoided) -
I was interested in the "virtual data" mode but in the help that seems to be tied exlusively to the WinData control with is targeted at created data, not pulling data from a remote DB across the wire.
Is there a way to set this type of thing up for read only type applications using the grid that I'm missing?
thanks
-J
Hi J,
What you are talking about here is really not the grid or the UltraDataSource, but loading data from the back end. As far as I know, the Dotnet framework doesn't have any great way to load data on demand - it's set up to load entire tables at once. You can, of course, write queries to load a only some rows. I'm no gret expert on SQL, but I've never been able to find a way to load segements of a table, though. It's easy to get the Top 500 rows. But if you want rows 501-1000, it becomes problematic.