Actually, I want to fill a checkedlistbox which is getting its data directly from a fill method in the TemplatesBO.



Currently it is just doing a fillall()



(though I'd still like to know a how to of the previous BO / BO question )



Now, I have a PDFsBO that just represents selected records (same scenario as first question)



Now I want to write a fill method to fill the second checked listbox "Templates" so that no item comes from a record that has a pk matching an itemplateskey found in PDFsBO



I assume I need to pass in a list (or array?) of itemplateskeys found in pdfsBO.



But what is the "Select " statement for the fill that will select only records "where ikey not in (select itemplateskey from parameterarray)")

The brute force way is to build a list of PKs from the checked listbox that you then use in a select query.







Likely, you'd generate the list of selected PKs in the form and pass that list to a Fill method in the BO.



Hope that makes sense...

It does indeed and that is the direction I was headed before I heard the siren song of LINQ. I am going to mess with both approaches, as I'm sure each will come in handy at one time or another.



By Tuesday I may have LINQ chops to show you (ordered a couple of books as I can see where LINQ to objects can be kind of cool. Beth Massey has a couple of nice aggregation examples on her blog)

Hi Charles,



Be aware that LINQ requires .NET 3.0 or 3.5, and there is a size difference between .NET 2.0 runtime and the newest one.

Edhy Rijo

Thanks Eddy



I'm specing everything against 3.5 and SQL 2008. No reason to be backward compatible with anything.



Is the size of the run-time an issue?

Not unless you have download or install limitations.  In most environments this should not be an issue.