GridView ASP if the table is empty

Question

How can I display a message in the place of the GridView if there is no results come from the database?

Answer 1

The GridView has an EmptyDataRow template and style, just make the use of that:

  <asp:gridview id="CustomersGridView" 
    datasourceid="CustomersSqlDataSource" 
    autogeneratecolumns="true"
    runat="server">

    <emptydatarowstyle backcolor="LightBlue"
      forecolor="Red"/>

    <emptydatatemplate>

      <asp:image id="NoDataImage"
        imageurl="~/images/Image.jpg"
        alternatetext="No Image" 
        runat="server"/>

        No Data Found.  

    </emptydatatemplate> 

  </asp:gridview>

example from MSDN GridView.EmptyDataRowStyle Property (available since .NET 2.0)

Answer 2

There is also the EmptyDataText property that you type on the <asp:GridView ... >

EmptyDataText="There is no items in the list box"

and the EmptyDataRowStyle-CssClass to style it.