Setting Value in AutoCompleteBox Using Code in LightSwitch 2012

This article shows how to set AutoCompleteBox values using code in a LightSwitch Application (Visual C#) in Visual Studio 2012.

The following is the procedure for setting AutoCompleteBox Values using code.

Step 1

Open the Solution Explorer.



Step 2

In the Solution Explorer, right-click on the server and choose "Add Table".



Step 3

In this way we add two tables (one is an Employee table and the other is an Item table). The tables are as in the following:

Employee Table



City Table



Step 4

Now, in order to establish a relationship between Employee and City, click on the "Add Relationship" button.



The Add New Relationship dialog box appears on the screen.



Step 5

Open the Employee Table, click on the "Write Code" button in the menu bar. A drop down list will appear and choose the Employee_Created method.



Add the Following code to the code window:

partial void Employee_Created()

        {

            this.City = DataWorkspace.ApplicationData.Cities.Where((City) => City.CityName == "Abc").FirstOrDefault();

        }

The logic above is executed when an instance of a new employee is created.

Step 6

We can also apply some business logic. The City could be set to "Meerut" for Employees with a EmpName beginning with "A".

For this purpose, open the Employee Table, select the EmpName and click on the "WriteCode" dropdown list and select the EmpName_Changed method.



Add the following code in the code window:

if (this.EmpName.StartsWith("A"))

            {

                this.City=DataWorkspace.ApplicationData.Cities.Where((City)=> City.CityName == "Abc").FirstOrDefault();

            }

Step 7

In the Solution Explorer, right-click on the Screens and choose "Add Screen".



Step 8

The Add New Screen dialog box appears. Select the "New Data Screen" from the Screen Template, under screen information, choose "Employees" under screen data and provide some name to the Screen and click the "OK" button.



Step 9

The screen designer appears.



Step 10

Press F5 to run the application.


 
Step 11

If you want to insert the city value then you can insert it using an Editable Data Screen under the screen data by choosing the City option.

However I have inserted the value under cities as "Abc" and "Meerut".