Datatable新增(1)

 

private System.Data.DataSet dataSet;

    private void MakeDataTables()

    {

        // Run all of the functions.

        MakeParentTable();

        MakeChildTable();

        MakeDataRelation();

        BindToDataGrid();

    }

 

    private void 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);

        }

    }

 

    private void 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";