Chapter 8: Building Desktop Applications with WPF | 235 |
following sections show you how to perform create, read, update, and delete (CRUD) operations via WPF. You’ll first see how to insert data, using VS tools to construct a data entry screen. Then you’ll learn how to read, modify, and delete data through a DataGrid. We’ll start with single value binding. To make the examples more interesting, I added extra fields to the tables. You can review Chapter 7 to learn how to add fields to a database and create a LINQ to SQL entity model.
Setting Up a Data Source
Before you can bind to data in the window, you’ll need a data source to work with data. To get started, update the Order table, created in Chapter 7, so that it has the following fields:
●OrderID, int, primary key,
●CustomerID, int
●OrderDate, datetime
●Location, varchar(50)
●Amount, money
Then update the Customer table with the following fields:
●CustomerID, int, primary key,
●Name, nvarchar(50)
●Age, int
●Birthday, datetime
●Income, money
With the database updated, you can add a LINQ to SQL entity model to the project, using the same techniques described in Chapter 7.
To add the data source for binding, open the NewOrder window in the Designer, and select the Data Add New Data Source menu, which opens the Choose A Data Source Type window, shown in Figure
There are different ways to connect to a data source, including directly to the database, via a Web service, via an object, or through SharePoint. This book shows you how to use LINQ to SQL, which is connected by selecting Object and clicking Next, which shows the Select The Data Objects window in Figure
