/**/
/// <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;
}
}
/// 绑定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);
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);