GridView in ASP.NET is not displaying with or without data

Question

I'm adding a GridView & then showing data in it from a SQL Server database. The problem is that the GridView is not displaying in the browser with or without data.

Here is my code:

<asp:GridView ID="GridAllStore"  runat="server" AutoGenerateColumns="False" Width="100%"  ViewStateMode="Enabled">

public partial class AdminPanel : System.Web.UI.Page
{
    storelocatorDataSetTableAdapters.storedbTableAdapter tastore = new storelocatorDataSetTableAdapters.storedbTableAdapter();
    storelocatorDataSetTableAdapters.View_1TableAdapter taview = new storelocatorDataSetTableAdapters.View_1TableAdapter();

    List<storelocatorDataSet.storedbRow> lststore = new List<storelocatorDataSet.storedbRow>();
    List<storelocatorDataSet.View_1Row> lstview = new List<storelocatorDataSet.View_1Row>();
    protected void Page_Load(object sender, EventArgs e)
    {
        lstview = taview.GetData().ToList();
        GridAllStore.DataSource = lstview; 
    }
}

You either have to set AutoGenerateColumns to true ot provide the columns as Bound- or TemplateFields that you want to show. You must DataBind irt either way. — Tim Schmelter
– Tim Schmelter, Commented Apr 23, 2012 at 21:50
Still data is not displaying . Actually gridview is not displaying in browser from the beginning . I thought adding data source will solve the problem . :( — Fahim Ahmed
– Fahim Ahmed, Commented Apr 23, 2012 at 21:51

James Johnson · Accepted Answer · 2012-04-23 22:22:43Z

19

I think the problem is that you haven't defined any columns to display. You have to explicitly define the columns when you set AutoGenerateColumns to false.

To make sure that the basics are working set AutoGenerateColumns to true:

<asp:GridView ID="GridAllStore"  runat="server" AutoGenerateColumns="true" Width="100%"  ViewStateMode="Enabled">

With AutoGenerateColumns set to true, the datasource assigned, and DataBind() called, you should start seeing some data. Once you start seeing the data, you can define the specific columns you want to display.

Since you only need to bind the grid on the first page load, utilize the !Page.IsPostBack condition:

protected void Page_Load(object sender, EventArgs e)
{
    if (!Page.IsPostBack)
    {
        GridAllStore.DataSource = lstview;
        GridAllStore.DataBind();
    }
}

edited Apr 23, 2012 at 22:22

answered Apr 23, 2012 at 22:04

James Johnson

46.1k8 gold badges75 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tim B James · Accepted Answer · 2012-04-23 22:09:47Z

2

Change your code to:

protected void Page_Load(object sender, EventArgs e)
{
    lstview = taview.GetData().ToList();
    GridAllStore.DataSource = lstview; 
    GridAllStore.DataBind();
}

And change your GridView markup to:

<asp:GridView ID="GridAllStore"  runat="server" AutoGenerateColumns="True" Width="100%"  ViewStateMode="Enabled" />

Noticed that it is now AutoGenerateColumns="True" as this will show the data and generate the columns. You might need to customise what is being shown though. To do this, since you dont really know what you are doing just now, switch to the design view and you can edit the gridview template.

Check out this post for some help with customizing the columns and data that you output. http://msdn.microsoft.com/en-us/library/bb288032.aspx

edited Apr 23, 2012 at 22:09

answered Apr 23, 2012 at 22:03

Tim B James

20.4k4 gold badges77 silver badges108 bronze badges

3 Comments

Fahim Ahmed Over a year ago

Thanks ! :) I have just done that . It worked . But I really don't have any idea how to remove autogenereated columns . Can you help me please ?

Tim B James Over a year ago

If you open up the .aspx page in design view mode, you can click on the GridView control and edit it. It allows you to select what columns you want to display. Alternatively, you can use custom TemplateFields. Maybe have a look here for some help with it? msdn.microsoft.com/en-us/library/bb288032.aspx

Tim B James Over a year ago

If you need anymore help with that, give us a yell!

Beenish Khan · Accepted Answer · 2012-04-23 21:50:22Z

1

Have you tried adding following line immediately after setting the Datasource ?

GridAllStore.DataBind();

answered Apr 23, 2012 at 21:50

Beenish Khan

1,58311 silver badges18 bronze badges

6 Comments

Beenish Khan Over a year ago

Have you confirmed that you have data in lstview ?

Beenish Khan Over a year ago

And AutoGenerateColumns is set to true too ? Also check grid's visibility and it's parent control's visibility. Do a view source too and see if grid is there but not showing up for some reason.

Fahim Ahmed Over a year ago

It worked now after setting the AutogeneratedColumns to true . :D But , now I want to remove the autogeneratedcolumns. How van I do that ?

Beenish Khan Over a year ago

You can turn off the property and add your own columns. Here's a tutorial to get you started : c-sharpcorner.com/uploadfile/61b832/…

Fahim Ahmed Over a year ago

I just checked your tuto . It gives me error like this : Error Creating Control - GridAllStoreLiteral content ('<asp :BoundField HeaderText="Store" DataField="name" __designer:mapid="81" /> <asp :BoundField HeaderText="Contact No." DataField="contact" __designer:mapid="82" /> <asp :BoundField HeaderText="Address" DataField="address" __designer:mapid="83" />') is not allowed within a 'System.Web.UI.WebControls.DataControlFieldCollection'.

|

Collectives™ on Stack Overflow

GridView in ASP.NET is not displaying with or without data

3 Answers 3

Comments

3 Comments

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

3 Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related