绑定GridView控件时，当数据集DataSet为空时也显示GridView的表头

     /**/ /// <summary>
    /// 绑定GridView控件（当DataSet为空时也显示GridView的表头）
    /// </summary>
    /// <param name="gridView">所要绑定的GridView</param>
    /// <param name="ds">所要绑定的数据集</param>
    /// <returns>void </returns>
     public   void  BindGridView(GridView gridView, DataSet ds)
     ... {
        if (ds.Tables[0].Rows.Count > 0)
        ...{
            gridView.DataSource = ds;
            gridView.DataBind();
        }
        else
        ...{
            ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
            gridView.DataSource = ds;
            gridView.DataBind();
            int columnCount = gridView.Rows[0].Cells.Count;
            gridView.Rows[0].Cells.Clear();
            gridView.Rows[0].Cells.Add(new TableCell());
            gridView.Rows[0].Cells[0].ColumnSpan = columnCount;
            gridView.Rows[0].Cells[0].Text = "没有数据";
            gridView.RowStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center;
        }
    }

 

// ------------------------------调用实例--------------------------------
string  connString  =   " server=(local);uid=sa;pwd=;database=pubs " ;
string  cmdText  =   " select * from authors " ;
SqlConnection conn  =   new  SqlConnection(connString);
SqlDataAdapter adp  =   new  SqlDataAdapter(cmdText, conn);
DataSet ds  =   new  DataSet();
adp.Fill(ds);
BindGridView( this .GridView1, ds);