Advertisement
Guest User

Untitled

a guest
Dec 21st, 2014
156
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.61 KB | None | 0 0
  1. private List<Item> items = new List<Item>();
  2.  
  3. private void _LoadItems() {
  4. Order order = _GetOrder();
  5. if (order == null)
  6. return;
  7. using (SqlConnection connection = new SqlConnection(Properties.Settings.Default.ConnectionString)) {
  8. connection.Open();
  9. var command = new SqlCommand("SelectItems", connection);
  10. command.CommandType = System.Data.CommandType.StoredProcedure;
  11. command.Parameters.AddWithValue("@OrderNumber", order.OrderNumber);
  12. var adapter = new SqlDataAdapter(command);
  13. var table = new DataTable();
  14. adapter.Fill(table);
  15. this.items.Clear();
  16. foreach (DataRow row in table.Rows) {
  17. var item = new Item(row);
  18. this.items.Add(item);
  19. }
  20. this.lvItems.ItemsSource = this.items;
  21. MessageBox.Show(this.items.Count + "");
  22. }
  23. }
  24.  
  25. <ListView Margin="0" Name="lvItems" SelectionChanged="lvItems_SelectionChanged">
  26. <ListView.View>
  27. <GridView>
  28. <GridViewColumn Header="Description" Width="400" DisplayMemberBinding="{Binding Description}" />
  29. <GridViewColumn Header="Unit Price" Width="150" DisplayMemberBinding="{Binding UnitPrice}" />
  30. <GridViewColumn Header="Quantity" Width="150" DisplayMemberBinding="{Binding Quantity}" />
  31. </GridView>
  32. </ListView.View>
  33. </ListView>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement