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