How To Create The Multi-level Class Library DataEntityTier

Double NorthwindDataSet.xsd on in Solution Explorer to open the dataset in the Dataset Designer. Click the right mouse button and select Add Query on CustomersTableAdapter to open the Query Wizard TableAdapter. On the Select, a type of command to leave the default Use SQL Statements and click Next. In the Choose a Query Type page, leave the default SELECT statement that returns rows, then click Next. On the Specify a SQL SELECT query, leave the default and click Next. On the Choose the type GetCustomers methods to generate the method name in the Return a DataTable. Click Finish. Please note that the same procedure must be repeated for the Orders table, ok? And then from the Build menu, click Rebuild Solution and compiled. Step 7: To add references to the data service: In Solution Explorer, right-click the right mouse button and choose Add Reference on DataService. In the Add Reference dialog box, click the Projects tab and select both projects and DataAccessTier DataEntityTier. And OK. Step 8: Create functions and GetCustomers GetOrders in the data service: DataService in the project, double-click IService1.cs. and add the following code below the comment. Then double-click Service1.cs.e and add the following code to the Service1 class. Then fill in the Solution. Step 9: Create the presentation layer: To add a new project, right-click Solution Explorer, choose Add New Project. In the New Project dialog box, select Windows in the Project Types pane, and in the Templates pane, click Windows Application.

Forms

Give the project name PresentationTier, then click OK. PresentationTier The project is created and added to the solution NTierWalkthrough. To set the new project as a startup project, in Solution Explorer, right-click the right mouse button and click on PresentationTier. Set as StartUp Project. Now we PresentationTier please add a project reference, then click the right-click and PresentationTier. Choose Add Reference. In the Add Reference dialog box, click the Projects tab and then click Select DataEntityTier. OK. At this point, you di Nuovo click the right-click and choose Add Reference PresentationTier service. In the Add Reference dialog box, click Find in the service and select Service1 and OK. Step 10: Add two data-bound DataGridView to the form: In Solution Explorer, select the project and PresentationTier In the Data Sources window, expand NorthwindDataSet, then find the node Customers. Drag the Customers node onto Form1. In the Data Sources window, expand the Customers node, and find the related Orders, nested in the Customers node. Drag the node onto Form1 and related Orders Create a handler for the Form1_Load event by double-clicking an empty area of the form. Add the following code to the Form1_Load event handler. Now double-click the app. Config and Project PresentationTier apritelo.Trovare the dimension attribute and maxReceivedMessageSize change the value to 6553600. Now press F5 and you will notice that the Customers and Orders tables of data are retrieved from the data service and displayed on the form. Have to fun everyone! By Anna.