Derek,
There's no limitation, AFAIK, except available RAM probably. Hopefully you will not have a DataSet with 100,000 rows to display though ... that's a bit much for any user to get their head around, wouldn't you think? <g>
~~Bonnie
>The DataSet concept is fairly new to be, I'm used to working with temporary tables created from SELECT...INTO TABLE in VFP.
>
>If I fill a DataSet with 100 or 1,000 records from a table, is there a limit it can contain or does .NET internally disk buffer the data so I need not worry. Not that I ever plan to, but could it contain 75,000 records or more?
>
>In VFP I ordinarily would have to worry about where I am placing my temporary records for grid display; since I plan on using DataGrid and since it uses DataSets, do I have to worry or just Fill() the DataSet with any amount of data and let it run? What if a user has a SELECT that returns 100,000 records (again, not that I have plans for this size, but several years of detail sales records can generate this many rows)?
>
>The limit cannot be available RAM as tables in databases commonly grow to megs and gigs in size.
>
>Thanks in advance.