|
|
 |
|
|
Thread Tools | Display Modes |
Apr 26th, 2005, 6:10 PM
|
#1 |
|
Professional Programmer
Join Date: Mar 2005
Posts: 343
Rep Power: 4
 |
Another random question, DataTable vs Array(s)
So, I return data from a database, and first off, from my "standard" programming background, I was bringing the data back in Arrays, it all worked okay, but arrays have a few issues for what I was trying to do, but then I found DataTables, question is..
How much data can you bring back from a database in a datatable? And how efficient/inefficient are they? Example, if I'm bringing back one row of data, but my class has the datatable defined, should I bring all the data back in the datatable? Or just bring it back in individual variables, and leave the datatables for the bigger stuff? Thoughts? |
|
|
|
Apr 26th, 2005, 9:10 PM
|
#2 |
|
Programmer
Join Date: Mar 2005
Location: Edmonton, Alberta, Canada
Posts: 37
Rep Power: 0
 |
Arla:
For quick data access, like returning 1 or so rows, I would recommend the DataReader. Anything bigger, where you need perhaps more persistent data to manipulate on the client, I would use the DataSet Kevin Parkinson
__________________
public class MySignature extends Post implements JavaSyntax throws NuttinHoney{
MySignature()
{
Salutation();
Name();
}
public string Salutation()
{
Screen.printLn( "Sincerely,\n" );
}
public string Name()
{
Screen.printLn( "Kevin Parkinson" );
}
} |
|
|
|
|
| Bookmarks |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
