TIP: You also need to make some other difference visible between the Off / On states. I did the Red / Green thing, and then found that 4 of my users are red/green colourblind.
Oh, and have you tried using a Checkbox with Appearance set to Button?
Alse, you should probably stay away from dataadapters etc, as you are in Net 2.0, I would recommend using TableAdapters.
If you search the forum for 'cjard' he has some really helpful links in his signature, I think (IIRC) you should look at DW2.