Dataset is a collection tables. isn't it? So, howmany table we can use a single dataset?
2007-07-10 23:01:21 · 5 answers · asked by aravindan s 1 in Computers & Internet ➔ Programming & Design
Dataset has a collection of tables. isnt it? then, howmany tables we can use a single dataset?
2007-07-10 23:12:34 · update #1
A dataset is a set of data that can be gathered.
It can be the result of a simple SQL query like
select * from employee where employee.state = 'IL'
It can also be selected from multiple tables with multiple inner or outer joins.
It does not need to come from multiple tables, but it can. It can also come from multiple sources.
A results set is a better term.
2007-07-10 23:06:30 · answer #1 · answered by Dave H 4 · 1⤊ 1⤋
If you are refering to a "Dataset" class in the Microsoft .NET Framework, the "Tables" property is a specialized collection class. Collection classes in .NET theoretically have a limit to the size of an 'int' (which is used to index the collection), leaving you a maximum of "2^32" or "4,294,967,296" total items. (Note that this count does not take into consideration the size of the items stored.)
This theoretical limit, however, is much higher than what is practical, since the references to the objects (in this case, DataTables and their associated elements) consume physical memory and virtual (swap) space.
Because different configurations exist for physical and virtual memory sizes, along with other factors like other running applications, frequency of Garbage Collection in the .NET framework and the amount of information being stored in the various objects, it is difficult to determine the exact number you can store without some profiling of your application.
2007-07-11 00:31:23 · answer #2 · answered by JFalcon 5 · 1⤊ 0⤋
In some fields of computing a dataset is the name used for a file of data.
I think you are probably talking about a database. The limit of the number of tables in a database will probably have something to do with the type of database you are using and the amount of space you have available on your computer or server.
2007-07-10 23:13:05 · answer #3 · answered by AnalProgrammer 7 · 1⤊ 0⤋
As many as you want until the computer memory bursts lol. Of course adding one gazillion DataTables to a DataSet means that you have problems with your program design!
2007-07-11 00:31:51 · answer #4 · answered by Smutty 6 · 1⤊ 0⤋
Since you didn't specify the type of system or software, take a look at the link below, it may help you to figure it out for yourself.
2016-05-19 04:53:21 · answer #5 · answered by ? 3 · 0⤊ 0⤋