ranking Sort Sort   |   date Sort Sort   |   member Sort Sort
Syndication

5
Date Submitted Tue. Sep. 5th, 2006 8:27 PM
Revision 1
Beginner MovingParts
Tags Bind | Control | controls | datasource | same | two
Comments 0 comments
so you executed a query that took .5 second to execute and you want to bind that to a windows control. next you decide that you will need to have two controls bound to the same datasource. not a problem, except when you do this:
control1.datasource = datatable
control2.datasource = datatable

you notice that each control mirrors the other and you cannot pick two seperate and distinct values.

one way to solve this is to create two datatables and execute the query twice. unfortunately this now doubles your query time. bad idea.

here is the elegant solution...