GridView - Show headers on empty data source

Question

In C  how do I still show the headers of a gridview  even with the data source is empty    I am not auto generating the columns as they are all predefined    Currently what I am doing is the following   Get a DataTable back from a stored procedure  then set the DataSource of the gridview  and then call DataBind     This works fine when I have data  but when no rows are returned then I just get a blank spot where the grid should be   Edit  Thanks all for the  NET 4  property  I asked this back in the  NET 3 5 days  This is much easier now

User · Answer

You can use HeaderTemplate property to setup the head programatically or use ListView instead if you are using .NET 3.5.

Personally, I prefer ListView over GridView and DetailsView if possible, it gives you more control over your html.

User · Answer

lt asp GridView ID  gvEmployee  runat  server                       AutoGenerateColumns  False  ShowHeaderWhenEmpty    True    gt                         lt Columns gt                             lt asp BoundField DataField  Id  HeaderText  Id    gt                             lt asp BoundField DataField  Name  HeaderText  Name    gt                             lt asp BoundField DataField  Designation  HeaderText  Designation    gt                             lt asp BoundField DataField  Salary  HeaderText  Salary     gt                         lt  Columns gt                         lt EmptyDataTemplate gt No Record Available lt  EmptyDataTemplate gt                     lt  asp GridView gt      in CS Page  gvEmployee DataSource   dt    gvEmployee DataBind

User · Answer

I was using asp sqlDataSource  It worked for me when I set the CancelSelectOnNullParameter to false as below    lt asp SqlDataSource ID  SqlData1  runat  server  ConnectionString    SelectCommand  myStoredProcedure  SelectCommandType  StoredProcedure  CancelSelectOnNullParameter  False  gt   lt  asp SqlDataSource gt

User · Answer

I was using asp sqlDataSource  It worked for me when I set the CancelSelectOnNullParameter to false as below    lt asp SqlDataSource ID  SqlData1  runat  server  ConnectionString    SelectCommand  myStoredProcedure  SelectCommandType  StoredProcedure  CancelSelectOnNullParameter  False  gt   lt  asp SqlDataSource gt

User · Answer

lt asp GridView ID  grdGroup   EmptyDataText  No Records Found  ShowHeaderWhenEmpty  True  runat  server  gt    This is a basic example of Gridview with EmptyDataText and ShowHeaderWhenEmpty

User · Answer

After posting this I did come up with a way that works  However  I don t feel it is the best way to handle this  Any suggestions on a better one     Check to see if we get rows back  if we do just bind   if  dtFunding Rows Count    0        grdFunding DataSource   dtFunding      grdFunding DataBind      else       Other wise add a emtpy  New Row  to the datatable and then hide it after binding        dtFunding Rows Add dtFunding NewRow          grdFunding DataSource   dtFunding       grdFunding DataBind         grdFunding Rows 0  Visible   false

User · Answer

set   lt asp GridView AutoGenerateColumns  false  ShowHeaderWhenEmpty  true    showheaderwhenEmpty Property

User · Answer

I found a very simple solution to the problem   I simply created two GridViews   The first GridView called a DataSource with a query that was designed to return no rows   It simply contained the following        lt Columns gt           lt asp TemplateField HeaderStyle-HorizontalAlign  Left  gt               lt HeaderTemplate gt                   lt asp Label ID  lbl0  etc  gt    lt  asp Label gt                  lt asp Label ID  lbl1  etc  gt    lt  asp Label gt                lt  HeaderTemplate gt           lt  asp TemplateField gt       lt  Columns gt    Then I created a div with the following characteristics and I place a GridView inside of it with ShowHeader  false  so that the top row is the same size as all the other rows    lt div style  overflow  auto  height  29 5em  width  100   gt       lt asp GridView ID  Rollup  runat  server  ShowHeader  false  DataSourceID  ObjectDataSource  gt           lt Columns gt               lt asp TemplateField HeaderStyle-HorizontalAlign  Left  gt                   lt ItemTemplate gt                   lt asp Label ID  lbl0  etc  gt    lt  asp Label gt                  lt asp Label ID  lbl1  etc  gt    lt  asp Label gt                    lt  ItemTemplate gt               lt  asp TemplateField gt           lt  Columns gt       lt  asp GridView gt   lt  div gt

User · Answer

If you are working with ASP NET 3 5 and lower  and your problem is relatively simple like mine  you can just return a null row from the SQL query   if not exists  select RepId  startdate enddate from RepTable where RepID  10       select null RepID null StartDate null EndDate else      select RepId  startdate enddate from RepTable where RepID  10   This solution does not require any C  code or ASP NET code   Make sure you cast the null columns into appropriate names  otherwise it will not work  Else block must be included which is the same query as in if not exists  query part  In my case if I am using  RepID instead of 10  Which is mapped to a DropDownList box outside gridview    Each time I change the drop down to select a different rep  Gridview is updated  If no record is found  it shows a null row

User · Answer

ASP Net 4 0 added the boolean ShowHeaderWhenEmpty property   http   msdn microsoft com en-us library system web ui webcontrols gridview showheaderwhenempty aspx     lt asp GridView runat  server  ID  GridView1  ShowHeaderWhenEmpty  true  AutoGenerateColumns  false  gt       lt Columns gt           lt asp BoundField HeaderText  First Name  DataField  FirstName    gt           lt asp BoundField HeaderText  Last Name  DataField  LastName    gt       lt  Columns gt   lt  asp GridView gt    Note  the headers will not appear unless DataBind   is called with something other than null   GridView1 DataSource   New List Of String  GridView1 DataBind

User · Answer

I was just working through this problem  and none of these solutions would work for me   I couldn t use the EmptyDataTemplate property because I was creating my GridView dynamically with custom fields which provide filters in the headers   I couldn t use the example almny posted because I m using ObjectDataSources instead of DataSet or DataTable   However  I found this answer posted on another StackOverflow question  which links to this elegant solution that I was able to make work for my particular situation   It involves overriding the CreateChildControls method of the GridView to create the same header row that would have been created had there been real data   I thought it worth posting here  where it s likely to be found by other people in a similar fix

User · Answer

You can use HeaderTemplate property to setup the head programatically or use ListView instead if you are using .NET 3.5.

Personally, I prefer ListView over GridView and DetailsView if possible, it gives you more control over your html.

User · Answer

After posting this I did come up with a way that works  However  I don t feel it is the best way to handle this  Any suggestions on a better one     Check to see if we get rows back  if we do just bind   if  dtFunding Rows Count    0        grdFunding DataSource   dtFunding      grdFunding DataBind      else       Other wise add a emtpy  New Row  to the datatable and then hide it after binding        dtFunding Rows Add dtFunding NewRow          grdFunding DataSource   dtFunding       grdFunding DataBind         grdFunding Rows 0  Visible   false

User · Answer

lt asp GridView ID  gvEmployee  runat  server                       AutoGenerateColumns  False  ShowHeaderWhenEmpty    True    gt                         lt Columns gt                             lt asp BoundField DataField  Id  HeaderText  Id    gt                             lt asp BoundField DataField  Name  HeaderText  Name    gt                             lt asp BoundField DataField  Designation  HeaderText  Designation    gt                             lt asp BoundField DataField  Salary  HeaderText  Salary     gt                         lt  Columns gt                         lt EmptyDataTemplate gt No Record Available lt  EmptyDataTemplate gt                     lt  asp GridView gt      in CS Page  gvEmployee DataSource   dt    gvEmployee DataBind

User · Answer

Use an EmptyDataTemplate like below   When your DataSource has no records  you will see your grid with headers  and the literal text or HTML that is inside the EmptyDataTemplate tags    lt asp GridView ID  gvResults  AutoGenerateColumns  False  HeaderStyle-CssClass  tableheader  runat  server  gt       lt EmptyDataTemplate gt           lt asp Label ID  lblEmptySearch  runat  server  gt No Results Found lt  asp Label gt       lt  EmptyDataTemplate gt       lt Columns gt           lt asp BoundField DataField  ItemId  HeaderText  ID    gt           lt asp BoundField DataField  Description  HeaderText  Description    gt                   lt  Columns gt   lt  asp GridView gt

User · Answer

After posting this I did come up with a way that works  However  I don t feel it is the best way to handle this  Any suggestions on a better one     Check to see if we get rows back  if we do just bind   if  dtFunding Rows Count    0        grdFunding DataSource   dtFunding      grdFunding DataBind      else       Other wise add a emtpy  New Row  to the datatable and then hide it after binding        dtFunding Rows Add dtFunding NewRow          grdFunding DataSource   dtFunding       grdFunding DataBind         grdFunding Rows 0  Visible   false

User · Answer

You can set the ShowHeadersWhenNoRecords property of the ownertableview to true  aspx    lt asp GridView ID  RadGrid2  runat  server   gt          lt MasterTableView ShowHeadersWhenNoRecords  true    gt     Also when the datasource for the GridView is null when no records   you can try setting it as shown below  c      if  GridView1 DataSource    null                  GridView1 DataSource   new string                 GridView1 DataBind

User · Answer

I was just working through this problem  and none of these solutions would work for me   I couldn t use the EmptyDataTemplate property because I was creating my GridView dynamically with custom fields which provide filters in the headers   I couldn t use the example almny posted because I m using ObjectDataSources instead of DataSet or DataTable   However  I found this answer posted on another StackOverflow question  which links to this elegant solution that I was able to make work for my particular situation   It involves overriding the CreateChildControls method of the GridView to create the same header row that would have been created had there been real data   I thought it worth posting here  where it s likely to be found by other people in a similar fix

User · Answer

Add this property to your grid-view   ShowHeaderWhenEmpty  True  it might help just check

User · Answer

Juste add ShowHeaderWhenEmpty property and set it at true  This solution works for me

User · Answer

lt asp GridView ID  gvEmployee  runat  server                           AutoGenerateColumns  False  ShowHeaderWhenEmpty    True    gt                             lt Columns gt                                 lt asp BoundField DataField  Id  HeaderText  Id    gt                                 lt asp BoundField DataField  Name  HeaderText  Name    gt                                 lt asp BoundField DataField  Designation  HeaderText  Designation    gt                                 lt asp BoundField DataField  Salary  HeaderText  Salary     gt                             lt  Columns gt                             lt EmptyDataTemplate gt No Record Available lt  EmptyDataTemplate gt                         lt  asp GridView gt          in CS Page      gvEmployee DataSource   dt        gvEmployee DataBind       Help   see that link  http   www c-sharpcorner com UploadFile d0e913 how-to-display-the-empty-gridview-in-case-of-no-records-in-d

User · Answer

Use an EmptyDataTemplate like below   When your DataSource has no records  you will see your grid with headers  and the literal text or HTML that is inside the EmptyDataTemplate tags    lt asp GridView ID  gvResults  AutoGenerateColumns  False  HeaderStyle-CssClass  tableheader  runat  server  gt       lt EmptyDataTemplate gt           lt asp Label ID  lblEmptySearch  runat  server  gt No Results Found lt  asp Label gt       lt  EmptyDataTemplate gt       lt Columns gt           lt asp BoundField DataField  ItemId  HeaderText  ID    gt           lt asp BoundField DataField  Description  HeaderText  Description    gt                   lt  Columns gt   lt  asp GridView gt

User · Answer

set   lt asp GridView AutoGenerateColumns  false  ShowHeaderWhenEmpty  true    showheaderwhenEmpty Property

User · Answer

You can use HeaderTemplate property to setup the head programatically or use ListView instead if you are using .NET 3.5.

Personally, I prefer ListView over GridView and DetailsView if possible, it gives you more control over your html.

User · Answer

If you are working with ASP NET 3 5 and lower  and your problem is relatively simple like mine  you can just return a null row from the SQL query   if not exists  select RepId  startdate enddate from RepTable where RepID  10       select null RepID null StartDate null EndDate else      select RepId  startdate enddate from RepTable where RepID  10   This solution does not require any C  code or ASP NET code   Make sure you cast the null columns into appropriate names  otherwise it will not work  Else block must be included which is the same query as in if not exists  query part  In my case if I am using  RepID instead of 10  Which is mapped to a DropDownList box outside gridview    Each time I change the drop down to select a different rep  Gridview is updated  If no record is found  it shows a null row

User · Answer

ASP Net 4 0 added the boolean ShowHeaderWhenEmpty property   http   msdn microsoft com en-us library system web ui webcontrols gridview showheaderwhenempty aspx     lt asp GridView runat  server  ID  GridView1  ShowHeaderWhenEmpty  true  AutoGenerateColumns  false  gt       lt Columns gt           lt asp BoundField HeaderText  First Name  DataField  FirstName    gt           lt asp BoundField HeaderText  Last Name  DataField  LastName    gt       lt  Columns gt   lt  asp GridView gt    Note  the headers will not appear unless DataBind   is called with something other than null   GridView1 DataSource   New List Of String  GridView1 DataBind

User · Answer

Use an EmptyDataTemplate like below   When your DataSource has no records  you will see your grid with headers  and the literal text or HTML that is inside the EmptyDataTemplate tags    lt asp GridView ID  gvResults  AutoGenerateColumns  False  HeaderStyle-CssClass  tableheader  runat  server  gt       lt EmptyDataTemplate gt           lt asp Label ID  lblEmptySearch  runat  server  gt No Results Found lt  asp Label gt       lt  EmptyDataTemplate gt       lt Columns gt           lt asp BoundField DataField  ItemId  HeaderText  ID    gt           lt asp BoundField DataField  Description  HeaderText  Description    gt                   lt  Columns gt   lt  asp GridView gt

User · Answer

You can use HeaderTemplate property to setup the head programatically or use ListView instead if you are using .NET 3.5.

Personally, I prefer ListView over GridView and DetailsView if possible, it gives you more control over your html.

User · Answer

Add this property to your grid-view   ShowHeaderWhenEmpty  True  it might help just check

User · Answer

lt asp GridView ID  grdGroup   EmptyDataText  No Records Found  ShowHeaderWhenEmpty  True  runat  server  gt    This is a basic example of Gridview with EmptyDataText and ShowHeaderWhenEmpty

User · Answer

Juste add ShowHeaderWhenEmpty property and set it at true  This solution works for me

User · Answer

lt asp GridView ID  gvEmployee  runat  server                           AutoGenerateColumns  False  ShowHeaderWhenEmpty    True    gt                             lt Columns gt                                 lt asp BoundField DataField  Id  HeaderText  Id    gt                                 lt asp BoundField DataField  Name  HeaderText  Name    gt                                 lt asp BoundField DataField  Designation  HeaderText  Designation    gt                                 lt asp BoundField DataField  Salary  HeaderText  Salary     gt                             lt  Columns gt                             lt EmptyDataTemplate gt No Record Available lt  EmptyDataTemplate gt                         lt  asp GridView gt          in CS Page      gvEmployee DataSource   dt        gvEmployee DataBind       Help   see that link  http   www c-sharpcorner com UploadFile d0e913 how-to-display-the-empty-gridview-in-case-of-no-records-in-d

User · Answer

After posting this I did come up with a way that works  However  I don t feel it is the best way to handle this  Any suggestions on a better one     Check to see if we get rows back  if we do just bind   if  dtFunding Rows Count    0        grdFunding DataSource   dtFunding      grdFunding DataBind      else       Other wise add a emtpy  New Row  to the datatable and then hide it after binding        dtFunding Rows Add dtFunding NewRow          grdFunding DataSource   dtFunding       grdFunding DataBind         grdFunding Rows 0  Visible   false

User · Answer

Use an EmptyDataTemplate like below   When your DataSource has no records  you will see your grid with headers  and the literal text or HTML that is inside the EmptyDataTemplate tags    lt asp GridView ID  gvResults  AutoGenerateColumns  False  HeaderStyle-CssClass  tableheader  runat  server  gt       lt EmptyDataTemplate gt           lt asp Label ID  lblEmptySearch  runat  server  gt No Results Found lt  asp Label gt       lt  EmptyDataTemplate gt       lt Columns gt           lt asp BoundField DataField  ItemId  HeaderText  ID    gt           lt asp BoundField DataField  Description  HeaderText  Description    gt                   lt  Columns gt   lt  asp GridView gt

User · Answer

I found a very simple solution to the problem   I simply created two GridViews   The first GridView called a DataSource with a query that was designed to return no rows   It simply contained the following        lt Columns gt           lt asp TemplateField HeaderStyle-HorizontalAlign  Left  gt               lt HeaderTemplate gt                   lt asp Label ID  lbl0  etc  gt    lt  asp Label gt                  lt asp Label ID  lbl1  etc  gt    lt  asp Label gt                lt  HeaderTemplate gt           lt  asp TemplateField gt       lt  Columns gt    Then I created a div with the following characteristics and I place a GridView inside of it with ShowHeader  false  so that the top row is the same size as all the other rows    lt div style  overflow  auto  height  29 5em  width  100   gt       lt asp GridView ID  Rollup  runat  server  ShowHeader  false  DataSourceID  ObjectDataSource  gt           lt Columns gt               lt asp TemplateField HeaderStyle-HorizontalAlign  Left  gt                   lt ItemTemplate gt                   lt asp Label ID  lbl0  etc  gt    lt  asp Label gt                  lt asp Label ID  lbl1  etc  gt    lt  asp Label gt                    lt  ItemTemplate gt               lt  asp TemplateField gt           lt  Columns gt       lt  asp GridView gt   lt  div gt

User · Answer

You may use EmptyDataText as shown below    lt asp GridView ID   gridView  RunAt  server  AutoGenerateColumns  false            EmptyDataText  No entries found   gt    It does not show headers  it renders your message  No entries found   instead

User · Answer

You may use EmptyDataText as shown below    lt asp GridView ID   gridView  RunAt  server  AutoGenerateColumns  false            EmptyDataText  No entries found   gt    It does not show headers  it renders your message  No entries found   instead

User · Answer

You can set the ShowHeadersWhenNoRecords property of the ownertableview to true  aspx    lt asp GridView ID  RadGrid2  runat  server   gt          lt MasterTableView ShowHeadersWhenNoRecords  true    gt     Also when the datasource for the GridView is null when no records   you can try setting it as shown below  c      if  GridView1 DataSource    null                  GridView1 DataSource   new string                 GridView1 DataBind

[asp.net] GridView - Show headers on empty data source

Examples related to asp.net

Examples related to gridview

Examples related to header