datatable建立一個主/從關係

來源:互聯網
上載者:User
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.");    }}

  

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.