datatable创建一个主/从关系

使用ADO.NET访问数据库

最新推荐文章于 2019-04-27 17:18:33 发布

转载最新推荐文章于 2019-04-27 17:18:33 发布 · 366 阅读

本文介绍了一种使用ADO.NET从SQL Server数据库中获取数据的方法。通过创建连接字符串、使用SqlConnection建立连接、创建并填充DataSet，然后通过DataRelation建立表间关系，最后将数据绑定到UI控件上。

 
 转自：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."
 );
 
 }
 
 }