Articles → Light Switch 2011 → Queries in light switch 2011

Queries in light switch 2011




























Software requirement













Prerequisite knowledge











What is a query?





Steps of execution





















Create a new project




Picture showing the project structure of the lightswitch application

Click to Enlarge


Create a new table




Picture showing the schema of the student table in the lightswitch table designer

Click to Enlarge


Add data in the table




Picture showing the editable grid screen with data

Click to Enlarge


Add query on the table






Picture showing the add query option in the context menu of the table

Click to Enlarge



Picture showing the new query added in the solution explorer

Click to Enlarge




Add parameters in query








Picture showing the button for adding the filters in the query

Click to Enlarge













Picture showing the filters added in the query

Click to Enlarge



Picture showing adding the value to the filters

Click to Enlarge



Picture showing the filters added in the query

Click to Enlarge











Picture showing marking the parameter as optional in the query

Click to Enlarge


Bind grid with query








Picture showing creating the new Editable Grid screen with query as data source

Click to Enlarge





Picture showing creating a new data field to be used as query parameter

Click to Enlarge



Picture showing the data in the grid bound with the query

Click to Enlarge


Bind drop down with query






Picture showing adding the new data item in the project

Click to Enlarge





Picture showing selecting the the query as data source of the data item

Click to Enlarge



Picture showing the query parameter data source in the property window

Click to Enlarge




Posted By  -  Karan Gupta
 
Posted On  -  Tuesday, August 6, 2013

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250