
/**//// <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);
本文介绍了一种绑定GridView控件的方法,即使数据集为空也能显示表头,并提供了完整的代码实现及示例。

3592

被折叠的 条评论
为什么被折叠?



