CREATE TABLE [ Production].[ Product] ( [ Product ID] INT IDENTITY (1, 1) NOT NULL, [ Name] [dbo].[ Name] NOT NULL, [ Product Number] NVARCHAR (25) NOT NULL, [ Make Flag] [dbo].[ Flag] NOT NULL, [ Finished Goods Flag] [dbo].[ Flag] NOT NULL, [ Color] NVARCHAR (15) NULL, [ Safety Stock Level] SMALLINT NOT NULL, [ Reorder Point] SMALLINT NOT NULL, [ Standard Cost] MONEY NOT NULL, [ List Price] MONEY NOT NULL, [ Size] NVARCHAR (5) NULL, [ Size Unit Measure Code] NCHAR (3) NULL, [ Weight Unit Measure Code] NCHAR (3) NULL, [ Weight] DECIMAL (8, 2) NULL, [ Days To Manufacture] INT NOT NULL, [ Product Line] NCHAR (2) NULL, [ Class] NCHAR (2) NULL, [ Style] NCHAR (2) NULL, [ Product Subcategory ID] INT NULL, [ Product Model ID] INT NULL, [ Date Added] DATETIME NOT NULL, [ Sell Start Date] DATETIME NOT NULL, [ Sell End Date] DATETIME NULL, [ Discontinued Date] DATETIME NULL, [rowguid] UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL, [ Modified Date] DATETIME NOT NULL GO EXECUTE sp_addextendedproperty @name = N' MS_ Description @value = N' Products sold or used in the manfacturing of sold products. @level0type = N' SCHEMA @level0name = N' Production @level1type = N' TABLE @level1name = N' Product.
using System; using System. Collections. Object Model; using System. Component Model; using System. Windows; using System. Windows. Controls; using System. Windows. Data; namespace Data Grid Validation public partial class Main Window : Window public Main Window Initialize Component data Grid1. Initializing New Item += (sender, e) => Course new Course = e. New Item as Course; new Course. Start Date = new Course. End Date = Date Time. Today; ; public class Courses : Observable Collection< Course> public Courses this. Add(new Course Name = Learning WPF, Id = 1001, Start Date = new Date Time(2010, 1, 11 End Date = new Date Time(2010, 1, 22) this. Add(new Course Name = Learning Silverlight, Id = 1002, Start Date = new Date Time(2010, 1, 25 End Date = new Date Time(2010, 2, 5) this. Add(new Course Name = Learning Expression Blend, Id = 1003, Start Date = new Date Time(2010, 2, 8 End Date = new Date Time(2010, 2, 19) this. Add(new Course Name = Learning LINQ, Id = 1004, Start Date = new Date Time(2010, 2, 22 End Date = new Date Time(2010, 3, 5) public class Course : IEditable Object, INotify Property Changed private string _name; public string Name get return _name; set if name = value) return; _name = value; On Property Changed( Name private int _number; public int Id get return _number; set if number = value) return; _number = value; On Property Changed( Id private Date Time _start Date; public Date Time Start Date get return _start Date; set if start Date = value) return; _start Date = value; On Property Changed( Start Date private Date Time _end Date; public Date Time End Date get return _end Date; set if end Date = value) return; _end Date = value; On Property Changed( End Date region IEditable Object private Course backup Copy; private bool in Edit; public void Begin Edit if (in Edit) return; in Edit = true; backup Copy = this. Memberwise Clone as Course; public void Cancel Edit if (!in Edit).
Download Now