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" <an****@armour.com> wrote in message
news:eL**************@TK2MSFTNGP12.phx.gbl...

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

[anand]

Thanks Martin....

Regards,

Anand

"Martin Marinov" <me********@mecrossroad.bg> wrote in message
news:#h**************@TK2MSFTNGP11.phx.gbl...

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" <an****@armour.com> wrote in message
news:eL**************@TK2MSFTNGP12.phx.gbl...

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

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.716 / Virus Database: 472 - Release Date: 7/5/2004