ASP.NET

If Datasource=null, how to show gridview with header

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: Dec 2008

Posts: 6

Reputation: arunmozhi is an unknown quantity at this point

Solved Threads: 0

arunmozhi

Offline

Newbie Poster

If Datasource=null, how to show gridview with header

Mar 4th, 2009

in asp.net how to show the girdview with header, when the datasource=null, i have used

gridview.EmptyDataText="Some Text"

but i need to show the grid with the header

any one plz help me..

•

Join Date: Dec 2008

Posts: 104

Reputation: Aneesh_Argent is an unknown quantity at this point

Solved Threads: 18

Aneesh_Argent Aneesh_Argent is offline

Offline

Junior Poster

Re: If Datasource=null, how to show gridview with header

Mar 4th, 2009

Before binding your DataTable(DataSource) to the grid, check the row count of the DataTable. If its empty (row count = 0) then add a dummy row to the DataTable and then bind it with the grid. Also make the visibility of the dummy row in the grid to false.

Here is some sample code

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
        if(dt.Rows.Count > 0 )
        {
            //DataSource is not empty
            gvResults.DataSource = dt;
            gvResults.DataBind();
        }
        else
        {
            //DataSource empty, add dummy row
            dt.Rows.Add(dt.NewRow());
            gvResults.DataSource = dt;
            gvResults.DataBind();
           //Make dummy row invisible
            gvResults.Rows[0].Visible = false;
        }
        if(dt.Rows.Count > 0 )
        {
            //DataSource is not empty
            gvResults.DataSource = dt;
            gvResults.DataBind();
        }
        else
        {
            //DataSource empty, add dummy row
            dt.Rows.Add(dt.NewRow());
            gvResults.DataSource = dt;
            gvResults.DataBind();
           //Make dummy row invisible
            gvResults.Rows[0].Visible = false;
        }