dataset.cs

客户关系管理系统ASP.NET+VB.NET编程完整程序！

			RelationTable.Columns["ID"].ReadOnly = true;
			RelationTable.Columns.Add("FKParentTableID", typeof(System.Int32));
			RelationTable.Columns["FKParentTableID"].AllowDBNull = true;
			RelationTable.Columns["FKParentTableID"].ReadOnly = false;
			RelationTable.Columns.Add("FKChildTableID", typeof(System.Int32));
			RelationTable.Columns["FKChildTableID"].AllowDBNull = true;
			RelationTable.Columns["FKChildTableID"].ReadOnly = false;
			RelationTable.Columns.Add("ForeignKeyColumnName", typeof(System.String));
			RelationTable.Columns["ForeignKeyColumnName"].AllowDBNull = true;
			RelationTable.Columns["ForeignKeyColumnName"].ReadOnly = false;
			RelationTable.Columns["ForeignKeyColumnName"].MaxLength = 100;

			RelationTable.Columns.Add("RelationshipType", typeof(System.String));
			RelationTable.Columns["RelationshipType"].AllowDBNull = true;
			RelationTable.Columns["RelationshipType"].ReadOnly = false;
			RelationTable.Columns["RelationshipType"].MaxLength = 100;

			RelationTable.Columns.Add("ChildAccessorName", typeof(System.String));
			RelationTable.Columns["ChildAccessorName"].AllowDBNull = true;
			RelationTable.Columns["ChildAccessorName"].ReadOnly = false;
			RelationTable.Columns["ChildAccessorName"].MaxLength = 100;

			RelationTable.Columns.Add("ParentAccessorName", typeof(System.String));
			RelationTable.Columns["ParentAccessorName"].AllowDBNull = true;
			RelationTable.Columns["ParentAccessorName"].ReadOnly = false;
			RelationTable.Columns["ParentAccessorName"].MaxLength = 100;

			RelationTable.Columns.Add("ChildSetAccessor", typeof(System.String));
			RelationTable.Columns["ChildSetAccessor"].AllowDBNull = true;
			RelationTable.Columns["ChildSetAccessor"].ReadOnly = false;
			RelationTable.Columns["ChildSetAccessor"].MaxLength = 50;

			RelationTable.Columns.Add("ChildGetAccessor", typeof(System.String));
			RelationTable.Columns["ChildGetAccessor"].AllowDBNull = true;
			RelationTable.Columns["ChildGetAccessor"].ReadOnly = false;
			RelationTable.Columns["ChildGetAccessor"].MaxLength = 50;

			RelationTable.Columns.Add("ParentSetAccessor", typeof(System.String));
			RelationTable.Columns["ParentSetAccessor"].AllowDBNull = true;
			RelationTable.Columns["ParentSetAccessor"].ReadOnly = false;
			RelationTable.Columns["ParentSetAccessor"].MaxLength = 50;

			RelationTable.Columns.Add("ParentGetAccessor", typeof(System.String));
			RelationTable.Columns["ParentGetAccessor"].AllowDBNull = true;
			RelationTable.Columns["ParentGetAccessor"].ReadOnly = false;
			RelationTable.Columns["ParentGetAccessor"].MaxLength = 50;

			RelationTable.Columns.Add("IsMandatory", typeof(System.String));
			RelationTable.Columns["IsMandatory"].AllowDBNull = true;
			RelationTable.Columns["IsMandatory"].ReadOnly = false;
			RelationTable.Columns["IsMandatory"].MaxLength = 5;

			RelationTable.Columns.Add("DisassociateChild", typeof(System.String));
			RelationTable.Columns["DisassociateChild"].AllowDBNull = false;
			RelationTable.Columns["DisassociateChild"].ReadOnly = false;
			RelationTable.Columns["DisassociateChild"].MaxLength = 5;

			RelationTable.Columns.Add("CascadeDelete", typeof(System.String));
			RelationTable.Columns["CascadeDelete"].AllowDBNull = false;
			RelationTable.Columns["CascadeDelete"].ReadOnly = false;
			RelationTable.Columns["CascadeDelete"].MaxLength = 5;

			RelationTable.Columns.Add("CascadeUpdate", typeof(System.String));
			RelationTable.Columns["CascadeUpdate"].AllowDBNull = false;
			RelationTable.Columns["CascadeUpdate"].ReadOnly = false;
			RelationTable.Columns["CascadeUpdate"].MaxLength = 5;

			RelationTable.Columns.Add("EnforceConstraint", typeof(System.String));
			RelationTable.Columns["EnforceConstraint"].AllowDBNull = false;
			RelationTable.Columns["EnforceConstraint"].ReadOnly = false;
			RelationTable.Columns["EnforceConstraint"].MaxLength = 5;

			RelationTable.Columns.Add("NullableFKey", typeof(System.String));
			RelationTable.Columns["NullableFKey"].AllowDBNull = false;
			RelationTable.Columns["NullableFKey"].ReadOnly = false;
			RelationTable.Columns["NullableFKey"].MaxLength = 50;

			RelationTable.PrimaryKey = new DataColumn[]{RelationTable.Columns["ID"]};
			RelationTable.PrimaryKey[0].AutoIncrement = true;
			RelationTable.PrimaryKey[0].AutoIncrementSeed = -1000000;
			RelationTable.PrimaryKey[0].AutoIncrementStep = -1;
						
			DataTable RelationColumnTable = ds.Tables.Add("RelationColumn");
			RelationColumnTable.Columns.Add("ID", typeof(System.Int32));
			RelationColumnTable.Columns["ID"].AllowDBNull = false;
			RelationColumnTable.Columns["ID"].ReadOnly = true;
			RelationColumnTable.Columns.Add("FKRelationID", typeof(System.Int32));
			RelationColumnTable.Columns["FKRelationID"].AllowDBNull = true;
			RelationColumnTable.Columns["FKRelationID"].ReadOnly = false;
			RelationColumnTable.Columns.Add("ParentColumnName", typeof(System.String));
			RelationColumnTable.Columns["ParentColumnName"].AllowDBNull = true;
			RelationColumnTable.Columns["ParentColumnName"].ReadOnly = false;
			RelationColumnTable.Columns["ParentColumnName"].MaxLength = 200;

			RelationColumnTable.Columns.Add("ChildColumnName", typeof(System.String));
			RelationColumnTable.Columns["ChildColumnName"].AllowDBNull = true;
			RelationColumnTable.Columns["ChildColumnName"].ReadOnly = false;
			RelationColumnTable.Columns["ChildColumnName"].MaxLength = 200;

			RelationColumnTable.Columns.Add("OrdinalPosition", typeof(System.Int32));
			RelationColumnTable.Columns["OrdinalPosition"].AllowDBNull = true;
			RelationColumnTable.Columns["OrdinalPosition"].ReadOnly = false;
			RelationColumnTable.Columns.Add("NullableFKey", typeof(System.String));
			RelationColumnTable.Columns["NullableFKey"].AllowDBNull = true;
			RelationColumnTable.Columns["NullableFKey"].ReadOnly = false;
			RelationColumnTable.Columns["NullableFKey"].MaxLength = 5;

			RelationColumnTable.Columns.Add("ChildColumnIsPrimaryKey", typeof(System.String));
			RelationColumnTable.Columns["ChildColumnIsPrimaryKey"].AllowDBNull = true;
			RelationColumnTable.Columns["ChildColumnIsPrimaryKey"].ReadOnly = false;
			RelationColumnTable.Columns["ChildColumnIsPrimaryKey"].MaxLength = 5;

			RelationColumnTable.PrimaryKey = new DataColumn[]{RelationColumnTable.Columns["ID"]};
			RelationColumnTable.PrimaryKey[0].AutoIncrement = true;
			RelationColumnTable.PrimaryKey[0].AutoIncrementSeed = -1000000;
			RelationColumnTable.PrimaryKey[0].AutoIncrementStep = -1;
						
			DataTable TableTable = ds.Tables.Add("Table");
			TableTable.Columns.Add("ID", typeof(System.Int32));
			TableTable.Columns["ID"].AllowDBNull = false;
			TableTable.Columns["ID"].ReadOnly = true;
			TableTable.Columns.Add("FKDatabaseID", typeof(System.Int32));
			TableTable.Columns["FKDatabaseID"].AllowDBNull = true;
			TableTable.Columns["FKDatabaseID"].ReadOnly = false;
			TableTable.Columns.Add("Name", typeof(System.String));
			TableTable.Columns["Name"].AllowDBNull = true;
			TableTable.Columns["Name"].ReadOnly = false;
			TableTable.Columns["Name"].MaxLength = 100;

			TableTable.Columns.Add("AllowNew", typeof(System.String));
			TableTable.Columns["AllowNew"].AllowDBNull = true;
			TableTable.Columns["AllowNew"].ReadOnly = false;
			TableTable.Columns["AllowNew"].MaxLength = 5;

			TableTable.Columns.Add("IsLookupTable", typeof(System.String));
			TableTable.Columns["IsLookupTable"].AllowDBNull = false;
			TableTable.Columns["IsLookupTable"].ReadOnly = false;
			TableTable.Columns["IsLookupTable"].MaxLength = 5;

			TableTable.Columns.Add("GenerateCodeFor", typeof(System.String));
			TableTable.Columns["GenerateCodeFor"].AllowDBNull = true;
			TableTable.Columns["GenerateCodeFor"].ReadOnly = false;
			TableTable.Columns["GenerateCodeFor"].MaxLength = 100;

			TableTable.Columns.Add("AccessorName", typeof(System.String));
			TableTable.Columns["AccessorName"].AllowDBNull = true;
			TableTable.Columns["AccessorName"].ReadOnly = false;
			TableTable.Columns["AccessorName"].MaxLength = 100;

			TableTable.Columns.Add("GenerateSampleCode", typeof(System.String));
			TableTable.Columns["GenerateSampleCode"].AllowDBNull = true;
			TableTable.Columns["GenerateSampleCode"].ReadOnly = false;
			TableTable.Columns["GenerateSampleCode"].MaxLength = 5;

			TableTable.Columns.Add("InsertOrder", typeof(System.Int32));
			TableTable.Columns["InsertOrder"].AllowDBNull = false;
			TableTable.Columns["InsertOrder"].ReadOnly = false;
			TableTable.PrimaryKey = new DataColumn[]{TableTable.Columns["ID"]};
			TableTable.PrimaryKey[0].AutoIncrement = true;
			TableTable.PrimaryKey[0].AutoIncrementSeed = -1000000;
			TableTable.PrimaryKey[0].AutoIncrementStep = -1;
			
			ds.Relations.Add("FKDataTypeIDColumn",
				new DataColumn[]{ds.Tables["DataType"].Columns["ID"]},
				new DataColumn[]{ds.Tables["Column"].Columns["FKDataTypeID"]},true);
			ds.Relations["FKDataTypeIDColumn"].ChildKeyConstraint.DeleteRule = Rule.None;
			ds.Relations["FKDataTypeIDColumn"].ChildKeyConstraint.UpdateRule = Rule.None;


			ds.Relations.Add("FKTableIDColumn",
				new DataColumn[]{ds.Tables["Table"].Columns["ID"]},
				new DataColumn[]{ds.Tables["Column"].Columns["FKTableID"]},true);
			ds.Relations["FKTableIDColumn"].ChildKeyConstraint.DeleteRule = Rule.None;
			ds.Relations["FKTableIDColumn"].ChildKeyConstraint.UpdateRule = Rule.None;


			ds.Relations.Add("FKProcedureIDParam",
				new DataColumn[]{ds.Tables["Procedure"].Columns["ID"]},
				new DataColumn[]{ds.Tables["Param"].Columns["FKProcedureID"]},true);
			ds.Relations["FKProcedureIDParam"].ChildKeyConstraint.DeleteRule = Rule.Cascade;
			ds.Relations["FKProcedureIDParam"].ChildKeyConstraint.UpdateRule = Rule.Cascade;


			ds.Relations.Add("FKDataTypeIDParam",
				new DataColumn[]{ds.Tables["DataType"].Columns["ID"]},
				new DataColumn[]{ds.Tables["Param"].Columns["FKDataTypeID"]},true);
			ds.Relations["FKDataTypeIDParam"].ChildKeyConstraint.DeleteRule = Rule.Cascade;
			ds.Relations["FKDataTypeIDParam"].ChildKeyConstraint.UpdateRule = Rule.Cascade;


			ds.Relations.Add("FKDatabaseIDProcedure",
				new DataColumn[]{ds.Tables["Database"].Columns["ID"]},
				new DataColumn[]{ds.Tables["Procedure"].Columns["FKDatabaseID"]},true);
			ds.Relations["FKDatabaseIDProcedure"].ChildKeyConstraint.DeleteRule = Rule.Cascade;
			ds.Relations["FKDatabaseIDProcedure"].ChildKeyConstraint.UpdateRule = Rule.Cascade;


			ds.Relations.Add("FKParentTableIDRelation",
				new DataColumn[]{ds.Tables["Table"].Columns["ID"]},
				new DataColumn[]{ds.Tables["Relation"].Columns["FKParentTableID"]},true);
			ds.Relations["FKParentTableIDRelation"].ChildKeyConstraint.DeleteRule = Rule.None;
			ds.Relations["FKParentTableIDRelation"].ChildKeyConstraint.UpdateRule = Rule.None;


			ds.Relations.Add("FKChildTableIDRelation",
				new DataColumn[]{ds.Tables["Table"].Columns["ID"]},
				new DataColumn[]{ds.Tables["Relation"].Columns["FKChildTableID"]},true);
			ds.Relations["FKChildTableIDRelation"].ChildKeyConstraint.DeleteRule = Rule.None;
			ds.Relations["FKChildTableIDRelation"].ChildKeyConstraint.UpdateRule = Rule.None;


			ds.Relations.Add("FKRelationIDRelationColumn",
				new DataColumn[]{ds.Tables["Relation"].Columns["ID"]},
				new DataColumn[]{ds.Tables["RelationColumn"].Columns["FKRelationID"]},true);
			ds.Relations["FKRelationIDRelationColumn"].ChildKeyConstraint.DeleteRule = Rule.None;
			ds.Relations["FKRelationIDRelationColumn"].ChildKeyConstraint.UpdateRule = Rule.None;


			ds.Relations.Add("FKDatabaseIDTable",
				new DataColumn[]{ds.Tables["Database"].Columns["ID"]},
				new DataColumn[]{ds.Tables["Table"].Columns["FKDatabaseID"]},true);
			ds.Relations["FKDatabaseIDTable"].ChildKeyConstraint.DeleteRule = Rule.Cascade;
			ds.Relations["FKDatabaseIDTable"].ChildKeyConstraint.UpdateRule = Rule.Cascade;


		}
	}
}