110,539
社区成员
发帖
与我相关
我的任务
分享
sqldataadapter.Fill(ds,"班级");
sqldataadapter.Fill(ds,"学生信息");
ds.Relations.Add("每个班级的学生",ds.Tables["班级"].Columns["班级编号"],ds.Tables["学生信息"].Columns["班级编号"])
DataGrid1.SetDataBinding(ds,"班级.每个班级的学生")
SqlConnection conn = new SqlConnection();
SqlConnectionStringBuilder ssb = new SqlConnectionStringBuilder();
conn.ConnectionString =
"Data Source=localhost; Initial Catalog=Northwind; Integrated Security = True;";
conn.Open();
DataSet dbSet = new DataSet(); // 创建数据集
using (SqlDataAdapter da = new SqlDataAdapter("select * from Customers", conn))
{
da.Fill(dbSet, "Customers"); // 填充一个 Customers 表
}
using (SqlDataAdapter da = new SqlDataAdapter("select * from Orders", conn))
{
da.Fill(dbSet, "Orders"); // 填充一个 Orders 表
}
DataColumn parentCol = dbSet.Tables["Customers"].Columns["CustomerID"];
DataColumn childCol = dbSet.Tables["Orders"].Columns["CustomerID"];
DataRelation relation =
new DataRelation("FK_Customers_Orders", parentCol, childCol); // 建立主从关系
dbSet.Relations.Add(relation); // 添加主从关系到数据集中
BindingSource bs_Customers = new BindingSource(); // 创建绑定源
BindingSource bs_Orders = new BindingSource();
bs_Customers.DataSource = dbSet;
bs_Customers.DataMember = "Customers"; // 绑定到数据源——主表
bs_Orders.DataSource = bs_Customers;
bs_Orders.DataMember = "FK_Customers_Orders"; // 绑定到关系——从表,注意:区分大小写
dataGridView1.DataSource = bs_Customers; // DataGridView 显示
dataGridView2.DataSource = bs_Orders;