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>
}
