public Products() { InitializeComponent(); var db = new newDigitalXDBEntities(); int numlock = 1; if (numlock == 0) { dgdProducts.ItemsSource = (from productVariable in db.Products select new { productVariable.ProductID, productVariable.RetailerID, productVariable.SubCategoryID, productVariable.ProductName, productVariable.ProductDescription, productVariable.Price, productVariable.UnitsInStock, productVariable.IsDiscontinued } ); } else { this.Visibility = Visibility.Visible; } }
public Customers() { InitializeComponent(); var db = new newDigitalXDBEntities(); dgdCustomer.ItemsSource = (from customerVariable in db.Customers select new { customerVariable.CustomerID, customerVariable.FirstName, customerVariable.LastName, customerVariable.UserName } ); }
public Orders() { InitializeComponent(); var db = new newDigitalXDBEntities(); dgdOrders.ItemsSource = (from orderVariable in db.Orders select new { orderVariable.OrderID, orderVariable.CustomerID, orderVariable.AddressID, orderVariable.OrderDate, orderVariable.Complete } ); }