Database retrieving problem

[Nishad85]

Hi I have 3 columns in my table. They are Yes\No filelds. If the row is Yes i want to take the header name of the column.in the below example if morning is yes i want to take Morning in datagrid eg: if Morning Evening Afternoon Yes No YES Yes Yes No No Yes Yes in the above example in first row Morning and Afternoon is True. I want to retieve this to a Datagrid column Named Session.. i want to retrieve the above data to Session column . in the case of first row i want to show like this in datagrid column Session Morning, Evening Please help me to write Query and code