Datatable新增(1)

 

private System.Data.DataSet dataSet;

    privatevoid MakeDataTables()

    {

        // Run all of the functions.

        MakeParentTable();

        MakeChildTable();

        MakeDataRelation();

        BindToDataGrid();

    }

 

    privatevoid MakeParentTable()

    {

        // Create a new DataTable.

        System.Data.DataTable table =new DataTable("ParentTable");

        // Declare variables for DataColumn and DataRow objects.

        DataColumn column;

        DataRow row;

 

        // Create new DataColumn, set DataType,

        // ColumnName and add to DataTable.   

        column = new DataColumn();

        column.DataType = System.Type.GetType("System.Int32");

        column.ColumnName ="id";

        column.ReadOnly =true;

        column.Unique =true;

        // Add the Column to the DataColumnCollection.

        table.Columns.Add(column);

 

        //第二種方法:table.Columns.Add("item",Type.GetType("System.String"));

        //第三種方法: table.Columns.Add("列名");

 

        // Create second column.

        column = new DataColumn();

        column.DataType = System.Type.GetType("System.String");

        column.ColumnName ="ParentItem";

        column.AutoIncrement =false;

        column.Caption ="ParentItem";

        column.ReadOnly =false;

        column.Unique =false;

        // Add the column to the table.

        table.Columns.Add(column);

 

        // Make the ID column the primary key column.

        DataColumn[] PrimaryKeyColumns =new DataColumn[1];

        PrimaryKeyColumns[0] = table.Columns["id"];

        table.PrimaryKey = PrimaryKeyColumns;

 

        // Instantiate the DataSet variable.

        dataSet = new DataSet();

        // Add the new DataTable to the DataSet.

        dataSet.Tables.Add(table);

 

        // Create three new DataRow objects and add

        // them to the DataTable

        for (int i = 0; i <= 2; i++)

        {

            row = table.NewRow();

            row["id"] = i;

            row["ParentItem"] ="ParentItem " + i;

            table.Rows.Add(row);

        }

    }

 

    privatevoid MakeChildTable()

    {

        // Create a new DataTable.

        DataTable table =new DataTable("childTable");

        DataColumn column;

        DataRow row;

 

        // Create first column and add to the DataTable.

        column = new DataColumn();

        column.DataType = System.Type.GetType("System.Int32");

        column.ColumnName ="ChildID";

        column.AutoIncrement =true;

        column.Caption ="ID";