public Window1()
{
InitializeComponent();
AdventureWorksLT2008DataSet.CustomerDataTable dt = GetData();
DG1.DataContext = dt;
}
//</SnippetCustomerClass>
//<SnippetGetDataTop>
public ObservableCollection <Customer> GetData()
{
//</SnippetGetDataTop>
AdventureWorksLT2008DataSetTableAdapters.CustomerTableAdapter ctadapter = new DataGrid_CustomColumns.AdventureWorksLT2008DataSetTableAdapters.CustomerTableAdapter();
AdventureWorksLT2008DataSet.CustomerDataTable dt = new AdventureWorksLT2008DataSet.CustomerDataTable();
ctadapter.Fill(dt);
OrderStatus[] custstatus = { OrderStatus.New, OrderStatus.Received, OrderStatus.None, OrderStatus.Shipped, OrderStatus.New, OrderStatus.Processing,
OrderStatus.Received, OrderStatus.None, OrderStatus.Shipped, OrderStatus.New };
bool[] IsMember = { true, true, false, true, false, true, true, false, true, false };
ObservableCollection <Customer> customers = new ObservableCollection <Customer>();
int i;
for (i = 0; i < 10; i++)
{
DataRow r = dt.Rows[i];
Customer c = new Customer();
c.FirstName = (string)r["FirstName"];
c.LastName = (string)r["LastName"];
c.Email = new Uri("mailto:" + (string)r["EmailAddress"]);
c.IsMember = IsMember[i];
c.Status = custstatus[i];
customers.Add(c);
}
return(customers);
//<SnippetGetDataEnd>
}
public AdventureWorksLT2008DataSet.CustomerDataTable GetData()
{
AdventureWorksLT2008DataSetTableAdapters.CustomerTableAdapter custadapter = new AdventureWorksLT2008DataSetTableAdapters.CustomerTableAdapter();
AdventureWorksLT2008DataSet.CustomerDataTable custdata = new AdventureWorksLT2008DataSet.CustomerDataTable();
custadapter.Fill(custdata);
return(custdata);
}
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>
}
//<SnippetAdd1>
public Window1()
{
//</SnippetAdd1>
InitializeComponent();
AdventureWorksLT2008DataSet.CustomerDataTable dt = GetData();
DG1.DataContext = dt;
DG2.DataContext = dt;
//<SnippetAdd2>
//Create a new column to add to the DataGrid
DataGridTextColumn textcol = new DataGridTextColumn();
//Create a Binding object to define the path to the DataGrid.ItemsSource property
//The column inherits its DataContext from the DataGrid, so you don't set the source
Binding b = new Binding("LastName");
//Set the properties on the new column
textcol.Binding = b;
textcol.Header = "Last Name";
//Add the column to the DataGrid
DG2.Columns.Add(textcol);
}
