datagridview重叠_datagridview绑定list_datagridview右键菜单(64)

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

masterDataAdapter.Fill(data, "Customers");

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

SqlDataAdapter detaiataAdapter = new

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

detaiataAdapter.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.");

}

}

}

23. 如何在同一DataGridView中显示主从表？

DataGridView 不支持在同一DataGridView 中显示主从表。Windows Forms的先前版本中的DataGrid控件或许是你需要的一个解决方案。

24. 如何避免用户对列排序?

对于DataGridView 控件，默认情况下，TextBox类型的列会自动排序，而其它类型的列则不会自动排序。这种自动排序有时会把数据变得比较乱，这时你会想更改这些默认设置。

本文来自电脑杂谈，转载请注明本文网址：
http://www.pc-fly.com/a/tongxinshuyu/article-50070-64.html