Joining two DataTables to a CheckListBox control...
-
My situation is that I have two tables: tblKeyword and tblProjectKeyword. tblKeyword contains a list of available keywords (intKeywordID, txtKeyword). tblProjectKeyword (intProjectID, intKeywordID). tblProjectKeyword.intKeywordID is a FK to tblKeyword.intKeywordID. tblProjectKeyword.intProjectID is also a FK to another table. So the tblProjectKeyword table is a Many-Many relationship... a join table. What I'd like to do is bind the contents of tblKeyword to a CheckListBox control but have all the matching records in tblProjectKeyword appear checked for a specific project. My keywords work similar to the Categories window in Outlook items... the user will be able to check/uncheck and add more keywords to the list.... So, the CheckedListBox would contain ALL keywords, and have only those in the tblProjectKeyword checked. Additions to the list would be added to the tblKeyword table and checked items would be added to the tblProjectKeyword table. Currently I'm implementing this manually (creating all the items... when one is checked, I add a record to the table, etc, etc). I was wondering if I could use databinding with this complex example. I know you can bind a table to it, but I didn't know if I could bind two tables with some specific conditions. Currently, I am binding the tblKeyword table to the control.. then stepping through everything in the list, checking to see if it's in the tblProjectKeyword list, and checking those that are found. When the checked state changes, I manually add/delete items to the tblProjectKeyword Datatable. Thanks for your input in advance! AC Andrew Connell IM on MSN andrew@aconnell.com