12) 10 columns are there in table, but display only 5 columns in grid view. How?

hi,

write a select query to what are the columns u need to display in gridview

example:

select col1,col2,col3,col4,col5 from tbltame 

Regards
Kavi.n

Fundaravi, if this helps please login to Mark As Answer. | Alert Moderator

gv.datasource="call function where these column names present in storedprocedure"
<asp:gridview.........>
<Columns>
<asp:TemplateField HeaderText="Select">
<ItemTemplate>
<asp:CheckBox ID="chkChange" runat="server" />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="PartNo">
<ItemTemplate>
<asp:Label ID="lblPartNo" runat="server" Text='<%#Eval("Column1") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="GR No">
<ItemTemplate>
<asp:Label ID="lblRNo" runat="server" Text='<%#Eval("Column2") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Line No">
<ItemTemplate>
<asp:Label ID="lblNo" runat="server" Text='<%#Eval("Column3")%>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="PNo">
<ItemTemplate>
<asp:Label ID="lONo" runat="server" Text='<%#Eval("Column4") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField></column></gridview>


these column1-colum5 shd present in function while binding gridivew

Fundaravi, if this helps please login to Mark As Answer. | Alert Moderator

Fill DataTable with this query:

SELECT col1,col2,col3,col4,col5 FROM TableName

and bind it with gridview.

Ajay
ajaypatelfromsanthal.blogspot.in

Fundaravi, if this helps please login to Mark As Answer. | Alert Moderator

Set autogeneratecolumns="false" and assign the value using <%#Eval("Columnname") %> in itemtemplate of tempaltefield.

Ashok Nalam

Fundaravi, if this helps please login to Mark As Answer. | Alert Moderator