后台动态生成GridView列和模版

https://www.cnblogs.com/yangwujun/p/4747272.html

考虑到很多数据源是不确定的，所以这时无法在前台设置gridview的表头，需要在后台动态指定并绑定数据。

前台代码如下：

复制代码
<%@ Page Title="主页" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
CodeFile="Default.aspx.cs" Inherits="_Default" %>

<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">

复制代码

.cs页面代码如下

复制代码
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
BindData();
}

///

/// 绑定gridview
///

public void BindData()
{
string sqlcc = "SELECT * from Users";//order by gwbg.id desc
DataTable dt = new DataTable();
dt = DBHelp.ExecuteQueryWithoutParameter(sqlcc, CommandType.Text);
GridView1.AutoGenerateColumns = false;//设置自动产生列为false
GridView1.RowEditing += new GridViewEditEventHandler(GridView1_RowEditing); //添加编辑事件
GridView1.RowDeleting += new GridViewDeleteEventHandler(GridView1_RowDeleting);//添加删除事件
GridView1.RowCancelingEdit += new GridViewCancelEditEventHandler(GridView1_RowCancelingEdit);//添加删除事件
GridViewBind(GridView1, dt, "Id");
}

/// <summary>
/// 绑定生成GridView
/// </summary>
/// <param name="gdv">要绑定的GridView</param>
/// <param name="dtblDataSource">GridView的数据源</param>
/// <param name="strDataKey">GridView的DataKeyNames</param>
public static void GridViewBind(GridView gdv, DataTable dtblDataSource, string strDataKey)
{
    gdv.Columns.Clear();

    gdv.AutoGenerateColumns = false;
    gdv.DataSource = dtblDataSource;
    gdv.DataKeyNames = new string[]{ strDataKey };

    for (int i = 0; i < dtblDataSource.Columns.Count; i++)   //绑定普通数据列
    {
        BoundField bfColumn = new BoundField();
        bfColumn.DataField = dtblDataSource.Columns[i].ColumnName;
        bfColumn.HeaderText = dtblDataSource.Columns[i].Caption;
        gdv.Columns.Add(bfColumn);
    }

    //添加编辑列
    CommandField cf = new CommandField();//命令字段
    cf.ButtonType = ButtonType.Link;//超链接样式的按钮
    cf.ShowEditButton = true;//显示编辑按钮
    cf.CausesValidation = false;//引发数据验证为false
    cf.HeaderText = "编辑";
    cf.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
    gdv.Columns.Add(cf);//添加编辑按钮到gridview

    //添加删除列
    CommandField cf2 = new CommandField();
    cf2.ButtonType = ButtonType.Link;
    cf2.ShowDeleteButton = true;//显示删除按钮
    cf2.CausesValidation = false;
    cf2.HeaderText = "删除";
    cf2.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
    gdv.Columns.Add(cf2);

    //添加包复选框的模板列
    TemplateField tf = new TemplateField();
    tf.ItemTemplate = new MyTemplate("", DataControlRowType.DataRow);
    //tf.HeaderText = "选择";
    tf.HeaderTemplate = new MyTemplate("模版列-选择框", DataControlRowType.Header);
    tf.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
    gdv.Columns.Add(tf);

    gdv.DataBind();//绑定


}

//删除gridview的行
void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
    int i = e.RowIndex;
    MessageBox.Show(this, "删除ID为："+GridView1.Rows[i].Cells [0].Text.ToString () );
}

//编辑行
public void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
{
    int i = e.NewEditIndex;
    string id = GridView1.Rows[i].Cells[0].Text.ToString();
    MessageBox.Show(this, "删除ID为：" + id);
}

//取消
protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
    GridView1.EditIndex = -1;
    BindData();
}

}
复制代码

　　其中，添加模版的MyTemplate类代码为：

复制代码
public class MyTemplate : ITemplate
{
private string strColumnName;
private DataControlRowType dcrtColumnType;

public MyTemplate()
{
    //
    // TODO: 在此处添加构造函数逻辑
    //
}

/// <summary>
/// 动态添加模版列
/// </summary>
/// <param name="strColumnName">列名</param>
/// <param name="dcrtColumnType">列的类型</param>
public MyTemplate(string strColumnName, DataControlRowType dcrtColumnType)
{
    this.strColumnName = strColumnName;
    this.dcrtColumnType = dcrtColumnType;
}

public void InstantiateIn(Control ctlContainer)
{
    switch (dcrtColumnType)
    {
        case DataControlRowType.Header: //列标题

            //如果头部使用标题则使用以下代码
            Literal ltr = new Literal();
            ltr.Text = strColumnName;
            ctlContainer.Controls.Add(ltr);
            break;
        case DataControlRowType.DataRow: //模版列内容——加载CheckBox
            CheckBox cb = new CheckBox();
            cb.ID = "CheckBox1";
            cb.Checked = false;
            ctlContainer.Controls.Add(cb);
            break;
    }
}

}
复制代码
在MyTemplate类中，这里是直接写了添加CheckBox，其实我们可以在MyTemplate的构造函数里添加一个参数，表示传进来的要在模版里面添加的控件的类型。这样就可以根据

控件类型来自动生成控件了，而不要在类里面去手动写需要生成的控件。

其中效果图如下：