datatable创建一个主/从关系

转自：http://www.cnblogs.com/xiaofengfeng/category/291662.html

private void GetData()

{

    try

    {

        // Specify a connection string. Replace the given value with a

        // valid connection string for a Northwind SQL Server sample

        // database accessible to your system.

        String connectionString =

            "Integrated Security=SSPI;Persist Security Info=False;" +

            "Initial Catalog=Northwind;Data Source=localhost";

        SqlConnection connection = new SqlConnection(connectionString);

 

        // Create a DataSet.

        DataSet data = new DataSet();

        data.Locale = System.Globalization.CultureInfo.InvariantCulture;

 

        // Add data from the Customers table to the DataSet.

        SqlDataAdapter masterDataAdapter = new

            SqlDataAdapter("select * from Customers", connection);

        masterDataAdapter.Fill(data,"Customers");

 

        // Add data from the Orders table to the DataSet.

        SqlDataAdapter detailsDataAdapter = new

            SqlDataAdapter("select * from Orders", connection);

        detailsDataAdapter.Fill(data,"Orders");

 

        // Establish a relationship between the two tables.

        DataRelation relation = new DataRelation("CustomersOrders",

            data.Tables["Customers"].Columns["CustomerID"],

            data.Tables["Orders"].Columns["CustomerID"]);

        data.Relations.Add(relation);

 

        // Bind the master data connector to the Customers table.

        masterBindingSource.DataSource = data;

        masterBindingSource.DataMember = "Customers";

 

        // Bind the details data connector to the master data connector,

        // using the DataRelation name to filter the information in the

        // details table based on the current row in the master table.

        detailsBindingSource.DataSource = masterBindingSource;

        detailsBindingSource.DataMember = "CustomersOrders";

    }

    catch (SqlException)

    {

        MessageBox.Show("To run this example, replace the value of the " +

            "connectionString variable with a connection string that is " +

            "valid for your system.");

    }

}