//下面是生成一个摸班列,你要多个就加个循环吧。 TemplateColumn tc = new TemplateColumn(); tc.HeaderText = ListBox2.Items[i].Text.ToString(); tc.ItemTemplate = new Column_TextBox(i.ToString(),80); DataGrid1.Columns.Add(tc);//定义一个接口类 public class Column_TextBox:ITemplate { private string pColumn_ID; private int pWidth;
public Column_TextBox(string Column_ID,int Width) { pColumn_ID = Column_ID; pWidth = Width; } public void InstantiateIn(Control container) { TextBox tx= new TextBox(); tx.ID = pColumn_ID; tx.Width = pWidth; container.Controls.Add(tx); } }
更正: TemplateColumn tc = new TemplateColumn(); tc.HeaderText = "你好"; tc.ItemTemplate = new Components.Column_TextBox(名字,长度); DataGrid1.Columns.Add(tc);
我在创建一个模板列 TemplateColumn tc = new TemplateColumn(); tc.ItemTemplate = new ColumnTemplate(); 我怎么找不到ColumnTemplate这个方法类阿
/// <summary>
/// 实现ITemplate接口,用来打印
/// </summary>
public class ColumnTemplate : ITemplate
{
public void InstantiateIn(Control container)
{
LinkButton lb = new LinkButton();
lb.Text = "打印";
lb.CommandName = "Print";
container.Controls.Add(lb);
}
}
/// <summary>
/// 实现ITemplate接口,用来导出
/// </summary>
public class ColumnTemplateExport : ITemplate
{
public void InstantiateIn(Control container)
{
LinkButton lb = new LinkButton();
lb.Text = "导出";
lb.CommandName = "Export";
container.Controls.Add(lb);
}
}
/// <summary>
/// 清空GRID的COLUMN
/// </summary>
/// <param name="vardg"></param>
private static void RefreshGrid(DataGrid vardg)
{
vardg.Columns.Clear();
BoundColumn dc = new BoundColumn();
dc.HeaderText = "ID";
dc.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
dc.DataField = "ID";
dc.Visible = false;
dc.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
vardg.Columns.AddAt(0,dc); dc = new BoundColumn();
dc.HeaderText = "序号";
dc.HeaderStyle.Wrap = false;
dc.HeaderStyle.Width = 30;
dc.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
dc.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
vardg.Columns.AddAt(1,dc);
} /// <summary>
/// 创建按专家打印的GRID
/// </summary>
/// <param name="vardg"></param>
private static void CreateExpertDataGrid(DataGrid vardg)
{
RefreshGrid(vardg); BoundColumn dc = new BoundColumn();
dc.HeaderText = "专家姓名";
dc.HeaderStyle.Wrap = false;
dc.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
dc.DataField = "EXPERT_NAME";
dc.SortExpression = "EXPERT_NAME";
dc.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
vardg.Columns.AddAt(2,dc);
dc = new BoundColumn();
dc.HeaderText = "所属医院";
dc.HeaderStyle.Wrap = false;
dc.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
dc.DataField = "HOSPITAL";
dc.SortExpression = "HOSPITAL";
vardg.Columns.AddAt(3,dc);
TemplateColumn tc = new TemplateColumn();
tc.ItemTemplate = new ColumnTemplate();
tc.HeaderText = "打印";
dc.HeaderStyle.Wrap = false;
tc.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
tc.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
tc.HeaderStyle.Width = 30;
vardg.Columns.AddAt(4,tc);
tc = new TemplateColumn();
tc.ItemTemplate = new ColumnTemplateExport();
tc.HeaderText = "导出";
dc.HeaderStyle.Wrap = false;
tc.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
tc.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
tc.HeaderStyle.Width = 30;
vardg.Columns.AddAt(5,tc);
}
表dep:depid(标识主键),depname(学院名字)
表stu:stuid(标识主键),stuname(学生名字),studepid(学院id=表dep.depid) 前台:
<%@ Page language="c#" Codebehind="WebForm30.aspx.cs" AutoEventWireup="false" Inherits="csdn.WebForm30" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>WebForm30</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<link href="css.css" rel="stylesheet" type="text/css">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
</form>
</body>
</HTML>
后台:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls; namespace csdn
{
/// <summary>
/// WebForm30 的摘要说明。
/// </summary>
public class WebForm30 : System.Web.UI.Page
{
DataGrid DataGrid1=new DataGrid();
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
CreateDataGrid();
}
protected void CreateDataGrid()
{
DataGrid1.AutoGenerateColumns=false;
DataGrid1.CssClass="border";
DataGrid1.BorderWidth=0;
DataGrid1.CellSpacing=1;
DataGrid1.CellPadding=5;
DataGrid1.ItemStyle.CssClass="item";
DataGrid1.HeaderStyle.CssClass="header";
DataGrid1.DataKeyField="stuid";
//以上设定DataGrid的样式
TemplateColumn tm=new TemplateColumn();
tm.ItemTemplate=new ColumnTemplate1();
tm.HeaderText="姓名";
DataGrid1.Columns.Add(tm);
//建立第一个模板列
TemplateColumn tm2=new TemplateColumn();
tm2.ItemTemplate=new ColumnTemplate2();
tm2.HeaderText="学院";
DataGrid1.Columns.Add(tm2);
//建立第二个模板列
ButtonColumn bc=new ButtonColumn();
bc.ButtonType=ButtonColumnType.PushButton;
bc.CommandName="del";
bc.Text="删除";
DataGrid1.Columns.Add(bc);
//建立删除按钮列
SetBind();
//填充数据
Page.Controls[1].Controls.Add(DataGrid1);
//给页面的form加入这个DataGrid1
} protected void SetBind()
{
SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["conn"]);
SqlDataAdapter da=new SqlDataAdapter("select * from stu,dep where stu.studepid=dep.depid",conn);
DataSet ds=new DataSet();
da.Fill(ds,"table1");
this.DataGrid1.DataSource=ds.Tables["table1"];
this.DataGrid1.DataBind();
} private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
//和上面连接给出的例子中的代码一样,给下拉框绑定数据,并且选择默认的
SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["conn"]);
SqlDataAdapter da=new SqlDataAdapter("select * from dep",conn);
DataSet ds=new DataSet();
da.Fill(ds,"table1");
if(e.Item.ItemType==ListItemType.Item||e.Item.ItemType==ListItemType.AlternatingItem)
{
DropDownList ddl=(DropDownList)e.Item.FindControl("dep");
ddl.DataSource=ds.Tables["table1"];
ddl.DataTextField="depname";
ddl.DataValueField="depid";
ddl.DataBind();
ddl.Items.FindByValue(Convert.ToString(DataBinder.Eval(e.Item.DataItem,"depid"))).Selected=true;
}
} private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
if(e.CommandName=="del")
{
SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["conn"]);
SqlCommand comm=new SqlCommand("delete from stu where stuid=@id",conn);
SqlParameter parm1=new SqlParameter("@id",SqlDbType.Int);
parm1.Value=this.DataGrid1.DataKeys[e.Item.ItemIndex];
comm.Parameters.Add(parm1);
conn.Open();
comm.ExecuteNonQuery();
conn.Close();
SetBind();
}
} #region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
this.DataGrid1.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid1_ItemDataBound);
this.DataGrid1.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_ItemCommand);//这里的两个事件千万别忘记,因为DataGrid是后台创建的,这些事件需要自己来写上,vs.net也不会为你创建
}
#endregion
} public class ColumnTemplate1 : ITemplate
{
//第一个模板列
public void InstantiateIn(Control container)
{
LiteralControl l = new LiteralControl();
l.DataBinding += new EventHandler(this.OnDataBinding);
//数据绑定
container.Controls.Add(l);
//为模板列加入LiteralControl
} public void OnDataBinding(object sender, EventArgs e)
{
LiteralControl l = (LiteralControl) sender;//LiteralControl发送绑定请求
DataGridItem container = (DataGridItem) l.NamingContainer;
l.Text = ((DataRowView)container.DataItem)["stuname"].ToString();//绑定stuname字段
}
} public class ColumnTemplate2 : ITemplate
{
//第二个模板列
public void InstantiateIn(Control container)
{
DropDownList dpl = new DropDownList();
dpl.ID="dep";
container.Controls.Add(dpl);
//加入一个id="dep"的下拉框,数据在DataGrid的ItemDataBound中绑定
}
}
} http://www.cnblogs.com/lovecherry/archive/2005/03/25/125526.html这个地址
http://www.cnblogs.com/lovecherry/archive/2005/03/26/126102.html
TemplateColumn tc = new TemplateColumn();
tc.HeaderText = ListBox2.Items[i].Text.ToString();
tc.ItemTemplate = new Column_TextBox(i.ToString(),80);
DataGrid1.Columns.Add(tc);//定义一个接口类
public class Column_TextBox:ITemplate
{
private string pColumn_ID;
private int pWidth;
public Column_TextBox(string Column_ID,int Width)
{
pColumn_ID = Column_ID;
pWidth = Width;
} public void InstantiateIn(Control container)
{
TextBox tx= new TextBox();
tx.ID = pColumn_ID;
tx.Width = pWidth;
container.Controls.Add(tx);
} }
TemplateColumn tc = new TemplateColumn();
tc.HeaderText = "你好";
tc.ItemTemplate = new Components.Column_TextBox(名字,长度);
DataGrid1.Columns.Add(tc);
TemplateColumn tc = new TemplateColumn();
tc.ItemTemplate = new ColumnTemplate();
我怎么找不到ColumnTemplate这个方法类阿
ColumnTemplate();没仔细看是不是?
这个类是后边自己创建的,如果你要自己重新写,那么先把下面的类自己先建好!
public class ColumnTemplate1 : ITemplate
{
//第一个模板列
public void InstantiateIn(Control container)
{
LiteralControl l = new LiteralControl();
l.DataBinding += new EventHandler(this.OnDataBinding);
//数据绑定
container.Controls.Add(l);
//为模板列加入LiteralControl
} public void OnDataBinding(object sender, EventArgs e)
{
LiteralControl l = (LiteralControl) sender;//LiteralControl发送绑定请求
DataGridItem container = (DataGridItem) l.NamingContainer;
l.Text = ((DataRowView)container.DataItem)["stuname"].ToString();//绑定stuname字段
}
} public class ColumnTemplate2 : ITemplate
{
//第二个模板列
public void InstantiateIn(Control container)
{
DropDownList dpl = new DropDownList();
dpl.ID="dep";
container.Controls.Add(dpl);
//加入一个id="dep"的下拉框,数据在DataGrid的ItemDataBound中绑定
}
}
}
http://dev.csdn.net/develop/article/22/22942.shtm
等我有时间再写一篇嵌套daatgrid动态加载模板列的文章
先吧我写的2个例子看懂
http://www.cnblogs.com/lovecherry/archive/2005/03/25/125526.html
http://www.cnblogs.com/lovecherry/archive/2005/03/26/126102.html
再者,为何以下的两个地方出错?
public void dgChildAddColumns(object sender, System.EventArgs e)
{
DataGrid dgChild = (DataGrid)dgGrid.FindControl("dgChild");
dgChild.Columns.Clear(); //出错
BoundColumn mybc = new BoundColumn();
mybc.HeaderText = "名称";
mybc.HeaderStyle.Wrap = false;
mybc.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
mybc.DataField = "Name";
mybc.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
dgChild.Columns.AddAt(0,mybc); //出错
}
{
DataGrid dgChild = (DataGrid)dgGrid.FindControl("dgChild");
dgChild.Columns.Clear(); //出错
BoundColumn mybc = new BoundColumn();
mybc.HeaderText = "名称";
mybc.HeaderStyle.Wrap = false;
mybc.HeaderStyle.HorizontalAlign = HorizontalAlign.Center;
mybc.DataField = "Name";
mybc.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
dgChild.Columns.AddAt(0,mybc); //出错
}
请问为什么?
例如:
(for int i=0;i<ds.Table[0].rows.count;i++)
{
//do this
}
不如直接生成。既然是动态。那么为什么还要模板呢。
个人认为这样就够了。
DataGridID.Columns.Add(...
DataGridID.Rows[x].Cells[y].Controls.Add(...