My First Post! Be easy on me :P
I have a Small SQL CE Database that consists of three tables. Each Table gets filled into a seperate DataGridView, once this is completed a simple foreach loop iterates through an imagelist(s). One per DataGridView and matches the Primary Key to the Index of the ImageList. This populates the appropriate columns with the correct image. There is not much data here: 200 Rows, 10 columns per Table.
Right now i'm not liking using the index of the image stored in the imagelist because if I remove an entry from the table my primary key does not match the appropriate image and display the incorrect one. Whats the best way to simplify this? I'm trying to achive a simple way to update and remove data later on and have the appropriate image correspond with what is in the table. I have experimented with adding a new column to the table with a file name and then loading the images based on the filename in the imagelist which seems to work fine. Just looking for ideas! Any help is appreciated. Thanks