Dynamic SQL and C#.Net

I am using Dynamic SQl in my stored Procedure. In front end I am using C#.net gridview to display the data.

I have three fields in my Table,

1) Active- Bit 2) DateMadeInactive-smallDate 3)Comments-Varchar(Max)

Depending on the condition of the active Value I have to display those three or two fields in the gridview.

If Active= true, Then I have to display active and Comments.

If Active =false, Then I have to DateMadeInactive and Comments Fields.

For Rendering the Active field I am using the following

<asp:TemplateField HeaderText="Comments" SortExpression="Comments" >
                <ItemTemplate>
                    <%#Eval("Comments")%>
                </ItemTemplate>
            </asp:TemplateField>

In my stored Procedure I am checking Like this开发者_如何学编程 for null, if its null then I am displaying as false

set @SQLQuery = @SQLQuery+  ',isnull(Register.Active,''0'')as Active,

Could anybody tell me where do I check for the Active value or Is there any method in SQL which Checks for the True/False condition of the field.

I am not expecting complete answer, just a hint only...

Thank you.

Hari

The GridView.RowDataBound event is what you're looking for.

When handling the event check the value of the field and show or hide your controls accordingly.

Beware: You can't hide the whole column, as it affects every row, you must show or hide the controls inside the column.