Use SQL SELECT to create a cursor that contains the proper values. Bind the cursor to the grid.
>I have a table that has the following columns:
>
>ac_charge I
>body I
>buff I
>allign I
>teardown I
>
>Each column contains 0,1,2,3
>
>I have a grid with 3 columns - Description, in process, completed
>If the value is 2, In Process gets a check.
>If the value is 3, completed gets a check.
>If the value is 1, the item is listed in the Description column and put in bold (or bold red)
>If the value is 0 then the item isn't included in the list.
>
>The question I have is, how do you take each column item in the table and when the value is equal to 1 put them in consecutive rows in the Description column of the grid? Can I use a collection as a source for each row?
>
>thanks for any suggestions.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer