手工创建DataTable

最新推荐文章于 2024-08-09 08:26:09 发布

weixin_30767835

最新推荐文章于 2024-08-09 08:26:09 发布

阅读量82

点赞数

文章标签： xhtml ui c#

原文链接：http://www.cnblogs.com/liupan/archive/2007/04/03/698568.html

版权

创建WEB应用程序.拖动两个GrieViewd对象到表单中.一个命名为Bugs.另一个命名BugConstraints

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

using System;

using System.Data;

using System.Configuration;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

public partial class _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

//调用可创建表和方法的关系

DataSet ds = CreateDataSet();

//将数据源的第一个表作为GridView的数据源

Bugs.DataSource=ds.Tables["Bugs"];

Bugs.DataBind();

BugConstraints.DataSource=ds.Tables["Bugs"].Constraints;

BugConstraints.DataBind();

}

//手工创建

private DataSet CreateDataSet()

{

//初始化新的DataSet对象,将使用表和关系填充对象

DataSet dataSet = new DataSet();

//以SQL数据表为依据来创建Bugs表及其列

DataTable tblBugs = new DataTable("Bugs");

DataColumn newColumn;

newColumn = tblBugs.Columns.Add("BugID",Type.GetType("System.Int32"));

newColumn.AutoIncrement = true;//自动增加

newColumn.AutoIncrementSeed = 1;//起始为1

newColumn.AutoIncrementStep = 1;//步长为1

newColumn.AllowDBNull = false;//不允许为空

//设置一个命名的约束

UniqueConstraint constraint = new UniqueConstraint("Unique_BugID", newColumn);

tblBugs.Constraints.Add(constraint);

//为主键创建一个列数组

DataColumn[] columnArray = new DataColumn[1];

columnArray[0] = newColumn;

//为PrimaryKey属性添加该数组

tblBugs.PrimaryKey = columnArray;

//Product的列

newColumn = tblBugs.Columns.Add("Product", Type.GetType("System.Int32"));

newColumn.AllowDBNull = false;

newColumn.DefaultValue = 1;

DataColumn bugProductColumn = newColumn;

//Version 列

newColumn = tblBugs.Columns.Add("Version", Type.GetType("System.String"));

newColumn.AllowDBNull = false;

newColumn.MaxLength = 50;

newColumn.DefaultValue = "0.1";

//Description列

newColumn = tblBugs.Columns.Add("Description", Type.GetType("System.String"));

newColumn.AllowDBNull = false;

newColumn.MaxLength = 8000;

newColumn.DefaultValue = "";

//Reporter列

newColumn = tblBugs.Columns.Add("Reporter", Type.GetType("System.Int32"));

newColumn.AllowDBNull = false;

DataColumn bugReporterColumn = newColumn;

//基于所有创建的数据库架构添加行

DataRow newRow;//声明一个新行

newRow = tblBugs.NewRow();

newRow["Product"] = 1;

newRow["Version"] = "0.1";

newRow["Description"] = "Crashes on load";

newRow["Reporter"] = 5;

tblBugs.Rows.Add(newRow);

newRow = tblBugs.NewRow();

newRow["Product"] = 1;

newRow["Version"] = "0.1";

newRow["Description"] = "Does not report correct owner of bug";

newRow["Reporter"] = 5;

tblBugs.Rows.Add(newRow);

newRow = tblBugs.NewRow();

newRow["Product"] = 1;

newRow["Version"] = "0.1";

newRow["Description"] = "Fails to reload properly";

newRow["Reporter"] = 6;

tblBugs.Rows.Add(newRow);

newRow = tblBugs.NewRow();

newRow["Product"] = 1;

newRow["Version"] = "0.1";

newRow["Description"] = "Does not show history of previous action";

newRow["Reporter"] = 5;

tblBugs.Rows.Add(newRow);

newRow = tblBugs.NewRow();

newRow["Product"] = 2;

newRow["Version"] = "0.1";

newRow["Description"] = "Loses data overnight";

newRow["Reporter"] = 5;

tblBugs.Rows.Add(newRow);

newRow = tblBugs.NewRow();

newRow["Product"] = 2;

newRow["Version"] = "0.1";

newRow["Description"] = "HTML is not shown properly";

newRow["Reporter"] = 6;

tblBugs.Rows.Add(newRow);

//将表添加到DataSet中

dataSet.Tables.Add(tblBugs);

//Product Table

//实列化Products表并为其添加列

DataTable tblProduct = new DataTable("lkProduct");

newColumn = tblProduct.Columns.Add("ProductID", Type.GetType("System.Int32"));

newColumn.AutoIncrement = true;//自动增加

newColumn.AutoIncrementSeed = 1;//从1开始

newColumn.AutoIncrementStep = 1;//增加1

newColumn.AllowDBNull = false;//不允许为NULL

newColumn.Unique = true;//每个值必须唯一

newColumn = tblProduct.Columns.Add("ProductDescription", Type.GetType("System.String"));

newColumn.AllowDBNull = false;

newColumn.MaxLength = 8000;

newColumn.DefaultValue = "";

newRow = tblProduct.NewRow();

newRow["ProductDescription"] = "BugX Bug Tracking";

tblProduct.Rows.Add(newRow);

newRow = tblProduct.NewRow();

newRow["ProductDescription"] = "PIM-MY Personal Information Manager";

tblProduct.Rows.Add(newRow);

//将表添加到DataSet中

dataSet.Tables.Add(tblProduct);

//People

//实列化People表,并为起添家列

DataTable tblPeople = new DataTable("People");

newColumn = tblPeople.Columns.Add("PersonID", Type.GetType("System.Int32"));

newColumn.AutoIncrement = true;//自动增加

newColumn.AutoIncrementSeed = 1;//初始化为1

newColumn.AutoIncrementStep = 1;//步长为1

newColumn.AllowDBNull = false;//不允许为空

UniqueConstraint uniqueConstraint = new UniqueConstraint("Unique_PersonID", newColumn);

tblPeople.Constraints.Add(uniqueConstraint);

//将PersonID列作为外键约束

DataColumn PersonIDColumn=newColumn;

columnArray = new DataColumn[1];

columnArray[0] = newColumn;

tblPeople.PrimaryKey = columnArray;

newColumn = tblPeople.Columns.Add("FullName", Type.GetType("System.String"));

newColumn.AllowDBNull = false;

newColumn.MaxLength = 8000;

newColumn.DefaultValue = "";

newColumn = tblPeople.Columns.Add("eMail", Type.GetType("System.String"));

newColumn.AllowDBNull = false;

newColumn.MaxLength = 100;

newColumn.DefaultValue = "";

newColumn = tblPeople.Columns.Add("Phone", Type.GetType("System.String"));

newColumn.AllowDBNull = false;

newColumn.MaxLength = 20;

newColumn.DefaultValue = "";

newColumn = tblPeople.Columns.Add("Role", Type.GetType("System.Int32"));

newColumn.DefaultValue = 0;

newColumn.AllowDBNull = false;

newRow = tblPeople.NewRow();

newRow["FullName"] = "Jesse Liberty";

newRow["email"] = "jliberty@libertyassociater.com";

newRow["Phone"] = "617-555-7301";

newRow["Role"] = 1;

tblPeople.Rows.Add(newRow);

newRow = tblPeople.NewRow();

newRow["FullName"] = "Dan Hurwitz";

newRow["email"] = "dhurwitz@libertyassociater.com";

newRow["Phone"] = "781-555-3375";

newRow["Role"] = 1;

tblPeople.Rows.Add(newRow);

newRow = tblPeople.NewRow();

newRow["FullName"] = "John Galt";

newRow["email"] = "jGalt@franconia.com";

newRow["Phone"] = "617-555-9876";

newRow["Role"] = 1;

tblPeople.Rows.Add(newRow);

newRow = tblPeople.NewRow();

newRow["FullName"] = "Jesse Liberty";

newRow["email"] = "jliberty@libertyassociater.com";

newRow["Phone"] = "617-555-3232";

newRow["Role"] = 3;

tblPeople.Rows.Add(newRow);

newRow = tblPeople.NewRow();

newRow["FullName"] = "ron petrusha";

newRow["email"] = "ron@oreilly.com";

newRow["Phone"] = "707-555-0515";

newRow["Role"] = 2;

tblPeople.Rows.Add(newRow);

newRow = tblPeople.NewRow();

newRow["FullName"] = "tatiana diaz";

newRow["email"] = "tatiana@oreilly.com";

newRow["Phone"] = "617-555-1234";

newRow["Role"] = 2;

tblPeople.Rows.Add(newRow);

//将People表添加到DataSet中

dataSet.Tables.Add(tblPeople);

//创建外键约束

ForeignKeyConstraint fk = new ForeignKeyConstraint("FK_BugToPeople",PersonIDColumn,bugReporterColumn);

fk.DeleteRule = Rule.Cascade;

tblBugs.Constraints.Add(fk);

//声明DataRelation和DataColumn对象

System.Data.DataRelation dataRelation;

System.Data.DataColumn dataColumn1;

System.Data.DataColumn dataColumn2;

//在Bug和BugHistory之间创建关系

dataColumn1 = dataSet.Tables["People"].Columns["PersonID"];

dataColumn2 = dataSet.Tables["Bugs"].Columns["Reporter"];

dataRelation = new System.Data.DataRelation("BugsToReporter", dataColumn1, dataColumn2);

dataSet.Relations.Add(dataRelation);

return dataSet;

}

转载于:https://www.cnblogs.com/liupan/archive/2007/04/03/698568.html

weixin_30767835

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
手工创建DataTable

创建WEB应用程序.拖动两个GrieViewd对象到表单中.一个命名为Bugs.另一个命名BugConstraints<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %><!DOCTYPE html PUBLIC "-//W3C...
复制链接

扫一扫