Articles → LIGHT SWITCH 2011 → Multiple search parameters in lightswitch 2011

Multiple search parameters in lightswitch 2011






























Software requirement











Prerequisite knowledge



















Creation of table



Click to Enlarge




Creation of editable screen



Click to Enlarge




Create query on table



Click to Enlarge





declare @EmployeeName as varchar(max)
  set"@EmployeeName = 'karan'
  select * from Employee where EmployeeName = @EmployeeName




select * from Employee





Add query on editable screen







Click to Enlarge




Click to Enlarge




Click to Enlarge


Add data items for filters





Click to Enlarge




Click to Enlarge


Add filters in popup





Click to Enlarge




Add button to open modal window





Click to Enlarge


Button’s execute events


/// <summary>
/// Method invoked when 
/// Filter button is clicked
/// </summary>
partial void Filter_Execute()
{
    this.OpenModalWindow("Group");
}

/// <summary>
/// Method invoked when Apply Filter
/// button is clicked.
/// </summary>
partial void ApplyFilter_Execute()
{
    this.CloseModalWindow("Group");
}





Bind query parameters with data item





Click to Enlarge




Click to Enlarge




Click to Enlarge


Output





Click to Enlarge




Click to Enlarge




Click to Enlarge




Download



Posted By  -  Karan Gupta
 
Posted On  -  Tuesday, July 10, 2012

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250