public static AdventureWorksLT2008DataSet GetTypeDateSet() { AdventureWorksLT2008DataSet result = new AdventureWorksLT2008DataSet(); (new ProductTableAdapter()).Fill(result.Product); (new AddressTableAdapter()).Fill(result.Address); (new CustomerTableAdapter()).Fill(result.Customer); (new CustomerAddressTableAdapter()).Fill(result.CustomerAddress); (new ProductCategoryTableAdapter()).Fill(result.ProductCategory); (new ProductDescriptionTableAdapter()).Fill(result.ProductDescription); (new ProductModelTableAdapter()).Fill(result.ProductModel); (new ProductModelProductDescriptionTableAdapter()).Fill(result.ProductModelProductDescription); (new SalesOrderDetailTableAdapter()).Fill(result.SalesOrderDetail); (new SalesOrderHeaderTableAdapter()).Fill(result.SalesOrderHeader); return result; }
public static AdventureWorksLT2008DataSet GetTypeDateSet() { AdventureWorksLT2008DataSet result = new AdventureWorksLT2008DataSet(); (new ProductTableAdapter()).Fill(result.Product); (new AddressTableAdapter()).Fill(result.Address); (new CustomerTableAdapter()).Fill(result.Customer); (new CustomerAddressTableAdapter()).Fill(result.CustomerAddress); (new ProductCategoryTableAdapter()).Fill(result.ProductCategory); (new ProductDescriptionTableAdapter()).Fill(result.ProductDescription); (new ProductModelTableAdapter()).Fill(result.ProductModel); (new ProductModelProductDescriptionTableAdapter()).Fill(result.ProductModelProductDescription); (new SalesOrderDetailTableAdapter()).Fill(result.SalesOrderDetail); (new SalesOrderHeaderTableAdapter()).Fill(result.SalesOrderHeader); return(result); }
public Window1() { InitializeComponent(); DataTable dt = new DataTable(); AdventureWorksLT2008DataSet myData = new AdventureWorksLT2008DataSet(); //CustomerGrid.ItemsSource = myData.Customer; AdventureWorksLT2008DataSet.CustomerDataTable custDataTable = new AdventureWorksLT2008DataSet.CustomerDataTable(); AdventureWorksLT2008DataSetTableAdapters.CustomerTableAdapter custTableAdapter = new DataGrid1.AdventureWorksLT2008DataSetTableAdapters.CustomerTableAdapter(); custTableAdapter.Fill(custDataTable); //<Snippet2> //Set the DataGrid's DataContext to be a filled DataTable CustomerGrid.DataContext = custDataTable; //</Snippet2> }