C#动态生成gridview

最近&＃xff0c;开发了个项目&＃xff0c;提交测试时&＃xff0c;测试人员要测试后台录入数据&＃xff0c;问题出来了&＃xff0c;由于权限限制&＃xff0c;不能直接到DB服务器上去查数据【isqlw不能用了&＃xff0c;哎】&＃xff0c;DBA也不在&＃xff0c;其他一切途径似乎都不可行了。哎&＃xff0c;命苦啊&＃xff0c;只有再开发个web查询页面&＃xff0c;在页面中输入select语句&＃xff0c;来显示结果集。结果集用什么显示&＃xff0c;当然是GridView了。不过结果集可能有多个&＃xff0c;怎么全部显示呢&＃xff0c;限定结果集为10个&＃xff0c;页面中用10个GridView&＃xff0c;通过隐藏&＃xff0c;来显示&＃xff1f;No&＃xff0c;这种山寨做法&＃xff0c;不是我所能搞不定的&＃xff0c;咱来动态生成GridView吧&＃xff0c;有几个结果集&＃xff0c;就动态生成几个GridView&＃xff0c;呵呵&＃xff0c;这样多好。很快写下了下面的核心代码&＃xff1a;
private void BindData()
{
try
{
using (SqlConnection con &＃61; new SqlConnection(ConfigurationManager.ConnectionStrings["SQLConnString"].ToString()))
{
string sql &＃61; this.txtSQL.Value.Trim();
SqlDataAdapter myda &＃61; new SqlDataAdapter(sql, con);
DataSet ds &＃61; new DataSet();
con.Open();
myda.Fill(ds, "tb");
for (int i &＃61; 0; i {
GridView temp &＃61; new GridView();
this.Page.Controls.Add(temp);
temp.AutoGenerateColumns &＃61; true;
temp.CssClass &＃61; "GreenBorderTbl";
temp.HeaderStyle.CssClass&＃61;"GreenBorderTblTh";
temp.ShowFooter &＃61; true;
temp.FooterStyle.CssClass &＃61; "Foot";
temp.DataSource &＃61; ds.Tables[i];
temp.DataBind();
if (ds.Tables[i].Rows.Count > 0)
{
temp.FooterRow.Cells[0].Text &＃61; string.Format("共{0}条记录", ds.Tables[i].Rows.Count);
}
}
con.Close();
}
}
catch (Exception ex)
{
Response.Write(string.Format("BindData:[StackTrace]{0}[Message]{1}", ex.StackTrace, ex.Message));
}
}
运行,my god! 竟然出现了下面的图片&＃xff1a;

抓紧看msdn&＃xff0c;GridView的构造函数&＃xff0c;看到了下面的代码&＃xff1a;

CS&＃xff1a;

// Add the GridView object to the Controls collection
// of the PlaceHolder control.
GridViewPlaceHolder.Controls.Add(customersGridView);

aspx&＃xff1a;

"GridViewPlaceHolder" runat&＃61;"Server"/>

呵呵&＃xff0c;发明创造咱不行&＃xff0c;比葫芦画瓢也不行吗&＃xff1f;抓紧在aspx中声明&＃xff1a;"GridViewPlaceHolder"
runat&＃61;"Server"/> &＃xff0c;在cs中把this.Page.Controls.Add(temp)替换成this.GridViewPlaceHolder.Controls.Add(temp)。编译运行程序&＃xff0c;呵呵&＃xff0c;出现了下面的画面&＃xff1a;
呵呵&＃xff0c;动态生成gridview是达到了&＃xff0c;placeholder是什么东东呢&＃xff0c;以后再说吧&＃xff01;

keyword: 动态 生成 gridview