Display selected fields in datagrid

[anand]

Hello group,

I using a datagrid to display output of a query, now the problem is that it
displays all column of query in columns of grid, ( e. g.)is it possible that
i fetch Employee name ,age and salary and i display only name and age..

Thanks

Andy

 

[Martin Marinov]

You have to use AutogenerateColumns = False and define the columns that you
want to display
e.g.

<asp:datagrid autogeneratecolumn=false runat="server" id="dg">
<Columns>
<asp:BoundColumn DataField="EmployeeName" />
<asp:BoundColumn DataField="Age" />
<asp:BoundColumn DataField="Salary" Visible="false" />
</Columns>
</asp:daatgrid>

Regards
Martin

 

[anand]

Thanks Martin....

Regards,

Anand

You have to use AutogenerateColumns = False and define the columns that you
want to display
e.g.

<asp:datagrid autogeneratecolumn=false runat="server" id="dg">
<Columns>
<asp:BoundColumn DataField="EmployeeName" />
<asp:BoundColumn DataField="Age" />
<asp:BoundColumn DataField="Salary" Visible="false" />
</Columns>
</asp:daatgrid>

Regards
Martin