Articles → LIGHT SWITCH 2011 → Bind Grid With View In Lightswitch 2011

Bind Grid With View In Lightswitch 2011

Software Requirement

1. Visual studio 2010 is installed on your machine.
2. Visual Studio 2010 service pack 1 is installed on your machine.
3. Microsoft Visual Studio Light switch 2011 is installed on your machine.

Prerequisite Knowledge

1. How to create lightswitch project?
2. How to create an entity in lightswitch?
3. How to create a screen in lightswitch?
4. Basics about objects like tables, views etc in SQL server

Steps For Execution

1. Create a new lightswitch project
2. Create tables
3. Adding data in the tables
4. Add data source in lightswitch
5. Add new screen from table
6. Add view in the database.
7. Update data source.
8. Add new screen from view

Create A New Lightswitch Project

Create Tables

Adding Data In The Tables

Add Data Source In Lightswitch

1. Enter server name
2. Select authentication type i.e. windows authentication or SQL Server authentication.
3. Select database.
4. Click on ‘Test Connection’ (this step is optional).
5. Once the connection is tested successfully click on Ok.

Add View In The Database

CREATE VIEW vw_GetEmployeeData AS 
SELECT 
  e.EmployeeId, 
  e.EmployeeName, 
  d.DepartmentName 
FROM 
  Employee e 
  INNER JOIN Department d ON e.DepartmentId = d.DepartmentId

Update Data Source

Add New Screens

Output