Why are there unwanted duplicate and extra columns in Asp: GridView?

Question

I am trying to show some details on my webpage using an ASP: GridView control. Accordingly, I added the columns that I need to show. But each column is displayed twice (Pic) in the GridView.

The backlink code looks as follows:

objVendor = client.GetAllVenorsForPCMS(); if (objVendor.Count > 0) { gvVendorsDetails.DataSource = objVendor; gvVendorsDetails.DataBind(); } else { gvVendorsDetails.DataSource = null; gvVendorsDetails.DataBind(); } 

and aspx code as follows:

  <div align="center" style="border: 1px solid;"> <asp:GridView ID="gvVendorsDetails" runat="server" CssClass="mGrid"> <Columns> <asp:BoundField HeaderText="Vendor ID" DataField="VendorID" Visible="false" /> <asp:BoundField HeaderText="Vendor Name" DataField="VendorName" Visible="true" /> <asp:BoundField HeaderText="Vendor Description" DataField="VendorDescription" Visible="true" /> <asp:BoundField HeaderText="Address" DataField="Address" Visible="true" /> <asp:BoundField HeaderText="City" DataField="City" Visible="true" /> <asp:BoundField HeaderText="State" DataField="State" Visible="true" /> <asp:BoundField HeaderText="Country" DataField="Country" Visible="true" /> <asp:BoundField HeaderText="Contact Person" DataField="ContactPerson" Visible="true" /> <asp:BoundField HeaderText="Contact No" DataField="ContactNo" Visible="true" /> <asp:BoundField HeaderText="ZIP Code" DataField="ZIPCode" Visible="true" /> </Columns> </asp:GridView> </div> 

I added columns only once, but how will it work twice in the columns of results !?

Answer 1

A common reason for this is that you also set the AutoGenerateColumns property to true (which is the default). By setting the property to false, the columns generated only by those that you explicitly specify will be limited.

i.e. fix it like this:

 <asp:GridView ID="gvVendorsDetails" runat="server" CssClass="mGrid" AutoGenerateColumns="False"> <Columns> ...