DataTable dt = new DataTable("Staff");
DataColumn dc;
dc = new DataColumn("ID", System.Type.GetType("System.Int32"));
dt.Columns.Add(dc); dc = new DataColumn("BeginDate", System.Type.GetType("System.DateTime"));
dt.Columns.Add(dc); dc = new DataColumn("EndDate", System.Type.GetType("System.DateTime"));
dt.Columns.Add(dc); dc = new DataColumn("Company", System.Type.GetType("System.String"));
dt.Columns.Add(dc); dc = new DataColumn("Department", System.Type.GetType("System.String"));
dt.Columns.Add(dc); dc = new DataColumn("Manager", System.Type.GetType("System.String"));
dt.Columns.Add(dc); dc = new DataColumn("Telephone", System.Type.GetType("System.String"));
dt.Columns.Add(dc); DataRow dr; dr = dt.NewRow();
dr["ID"] = 1;
dr["BeginDate"] = System.DateTime.Today;
dr["EndDate"] = System.DateTime.Today;
dr["Company"] = "××××";
dr["Department"] = "××××";
dr["Manager"] = "××";
dr["Telephone"] = "654321";
dt.Rows.Add(dr); dgWork.DataSource = dt;
dgWork.DataBind();
DataColumn dc;
dc = new DataColumn("ID", System.Type.GetType("System.Int32"));
dt.Columns.Add(dc); dc = new DataColumn("BeginDate", System.Type.GetType("System.DateTime"));
dt.Columns.Add(dc); dc = new DataColumn("EndDate", System.Type.GetType("System.DateTime"));
dt.Columns.Add(dc); dc = new DataColumn("Company", System.Type.GetType("System.String"));
dt.Columns.Add(dc); dc = new DataColumn("Department", System.Type.GetType("System.String"));
dt.Columns.Add(dc); dc = new DataColumn("Manager", System.Type.GetType("System.String"));
dt.Columns.Add(dc); dc = new DataColumn("Telephone", System.Type.GetType("System.String"));
dt.Columns.Add(dc); DataRow dr; dr = dt.NewRow();
dr["ID"] = 1;
dr["BeginDate"] = System.DateTime.Today;
dr["EndDate"] = System.DateTime.Today;
dr["Company"] = "××××";
dr["Department"] = "××××";
dr["Manager"] = "××";
dr["Telephone"] = "654321";
dt.Rows.Add(dr); dgWork.DataSource = dt;
dgWork.DataBind();
解决方案 »
- <%%>为什么这么用?
- datagrid控件单元控件赋值问题
- 简单的XmlReader读出 提示虚拟路径错误
- 日期格式问题(急)
- 各位仁兄,如何将aspx文件用html格式在客户端显示
- 高人请进,谁有办法把 Microsoft.Web.UI.WebControls 集成到其他程序集中去
- 求助!asp.net(C#)中table控件的分页问题
- 请问如何将这条SQL语句改为Nhibernate使用的HQL语句?
- 菜鸟求助了!
- 问题已解决散分!!asp.net 调用PB做的DLL异常现象[急求解!]
- 如何在ASP.NET中用代码实现ACTION的功能?并取回ACTION页面的执行结果?
- 请教一个asp.net的问题!为什么重装系统后,原来写的网站就没有办法再用了呢?
for(int i = 0; i < Count; i++)//建表
{
DataColumn myColumn = new DataColumn();
myColumn.DataType = typeof(object);
myColumn.Caption = ""; myColumn.ColumnName = ""
WorkTable.Columns.Add(myColumn);
}
this.dlbF.DataSource = dsSource.Tables[0].DefaultView;
this.dlbF.DataTextField = "";
this.dlbF.DataValueField = "";
this.dlbF.DataBind();
DataColumn col;
col = new DataColumn("id",typeof(int));
tbTest.Columns.Add(col);
col = new DataColunm("title",typeof(string));
col.MaxLength = 50; // 设置字段长度
tbTest.Columns.Add(col);// 设置主键
tbTest.PrimaryKey = new DataColumn[]{tbTest.Columns["id"]};
// 添加数据
DataRow row = tbTest.NewRow();
row["id"] = 1;
row["title"] = "第一条记录";
tbTest.Rows.Add(row);
tbTest.PrimaryKey = new DataColumn[]{tbTest.Columns["id"]};