After creating a data set and a data source, the next step is to indicate to each control where its data would come from.

If you drag a table from the Data Source window and drop it on a form, Microsoft Visual Studio adds the necessary Windows controls to the form and binds them to the columns of the table. To move from one record to another, you would need a way to navigate among the records. You can manually take care of this if you want. Alternatively, the .NET Framework provides a class named BindingNavigator that contains all the necessary functionality for this task.

There are various ways you can create a binding navigator:

1. Open the LambdaSquareApartments1 file and select everything in it the document
2. Copy to the clipboard
3. Display the Query window (if it not available, right-click any connection in the Server Explorer and click New Query)
4. To create a new database, paste in the Query window
5. Right-click inside the Query window and click Execute
6. To create a new application, on the main menu, click FILE -> New -> Project...
7. Make sure Windows Forms Application. Set the Name to LambdaSquareApartments1
8. Click OK.
   If you are asked whether you want to save SQLQuery1.sql, click No
9. On the main menu, click PROJECT -> Add New Data Source...
10. On the first page of the wizard, make sure Database is selected and click Next
11. On the second page of the wizard, make sure Dataset is selected and click Next
12. In the third page of the wizard, click New Connection...
    If the Choose Data Source dialog box comes up, click Microsoft SQL Server and click Continue
13. In the Server Name combo box, select the server or type (local)
14. In the Select or Enter a Database Name combo box, select LambdaSquareApartments1
15. Click OK
16. On the Data Source Configuration Wizard, make sure the new connection is selected
    Click the + button of Connection String
17. Click Next
18. Change the connection string to csLambdaSquareApartments and click Next
19. Click the check boxes of Tables and Stored Procedures
20. Change the name of the data set to dsLambdaSquareApartments
21. Click Finish
22. To create a new form, on the main menu, click PROJECT -> Add Windows Form...
23. Set the Name to Apartments and click Add
24. From the Data Source, drag Apartments and drop it on the new form
25. Design the form as follows:
     
    
26. To create a new form, on the main menu, click PROJECT -> Add Windows Form...
27. Set the Name to Employees and click Add
28. From the Data Source, drag Employees and drop it on the new form
29. Design the form as follows:
     
    
30. To create a new form, on the main menu, click PROJECT -> Add Windows Form...
31. Set the Name to Registrations and click Add
32. From the Data Source, drag Registrations and drop it on the new form
33. Design the form as follows:
     
    
34. To create a new form, on the main menu, click PROJECT -> Add Windows Form...
35. Set the Name to Payments and click Add
36. From the DataSource, drag Payments and drop it on the form
37. Design the form as follows:
     
    
38. In the Solution Explorer, right-click Form1.cs and click Rename
39. Type LambdaSquareApartments.cs and press Enter twice
40. Design the form as follows:
     

    Control (Name) Name Button btnRegistrations Tenants Registrations... Button btnRentPayments Rent Payments... Button btnApartments Apartments... Button btnEmployees Employees... Button Close btnClose

41. Double-click the Tenants Registrations button
42. Return to the form and double-click the Rent Payments button
43. Return to the form and double-click the Apartments button
44. Return to the form and double-click the Employees button
45. Return to the form and double-click the Close button
46. Implement the events as follows:

    using System;
    using System.Collections.Generic;
    using System.ComponentModel;
    using System.Data;
    using System.Drawing;
    using System.Linq;
    using System.Text;
    using System.Threading.Tasks;
    using System.Windows.Forms;
    
    namespace LambdaSquareApartments1
    {
        public partial class LambdaSquareApartments : Form
        {
            public LambdaSquareApartments()
            {
                InitializeComponent();
            }
    
            private void btnRegistrations_Click(object sender, EventArgs e)
            {
                Registrations regs = new Registrations();
                regs.Show();
            }
    
            private void btnRentPayments_Click(object sender, EventArgs e)
            {
                Payments pmts = new Payments();
                pmts.Show();
            }
    
            private void btnApartments_Click(object sender, EventArgs e)
            {
                Apartments aparts = new Apartments();
                aparts.Show();
            }
    
            private void btnEmployees_Click(object sender, EventArgs e)
            {
                Employees empls = new Employees();
                empls.Show();
            }
    
            private void btnClose_Click(object sender, EventArgs e)
            {
                Close();
            }
        }
    }