I have a datagrid with a 8 columns that I use display the status of a job in each of the 8 departments. The status is indicated by one of 9 colors. I set the forecolor/backcolor to the same so the user sees a solid box.
In my SQL, I set the 8 fields to 0-9 which corresponds to one of the colors.
First question: I noticed that when I set the cursor on the colored box, I see the database value (0-9). I could restrict the accces from clicking on these columns but would rather clear out the cell contents but how ?
I thought maybe the SetColumnValueAtRow function but it's not working.
Help me Obi Wan Kenobi. You're my only hope !