Datagrids vs multiple selects
Posted on 2006-05-30
hello, I have a situation where I am trying to build some sort of reporting functionality.
I have a table of accounts, lets say there are 1000 accounts.
I have another table of payments, lets say there are 500,000 payments (multiple payments per account)
I have to obtain the payment information for each account, and manipulate it in some way.
I imagine that is why they created DataTables - you just do a "big" select from the database, and keep that table in memory, and then do selects against that in-memory table, right?
Can anyone show me an example of how to do that?
So basically, in this example, I just want to get back the matching payment records for an account. I have an account id in the payment table.