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.