SIGN UP MEMBER LOGIN:    
ARTICLE

Sort and Filter Data on a Screen in a LightSwitch Application

Posted by Vineet Kumar Saini Articles | VS LightSwitch 2011 November 06, 2011
Using this article one can sort and filter business application data. In this article I tell you how to sort and filter data on screen in LightSwitch application.
Reader Level:

Introduction

LightSwitch is a Microsoft application which is used for create the business application. Using this article one can sort and filter business application data. In this article I will tell you how to sort and filter data on screen in a LightSwitch application.

Sort and Filter Data on a Screen in a LightSwitch Application step by step.

Step 1. First of all we created a table(Customer) in LightSwitch likes below image.

faltu.gif

Step 2. Screen-> Right click-> Add screen-> Editable grid screen-> Select Customer-> Ok.

image1.gif

Step 3. Now run application-> Click editable customer grid-> Click + sign-> Fill data-> Ok-> Save-> Refresh-> Close page.

image2.gif

Step 4. Click edit query.

image3.gif

Step 5. Add sort-> Save.

image4.gif

Step 6. Customer table-> Right click-> Add query.

image5.gif

Step 7. Change query name (SortCustomer)-> Add sort-> Save.

image6.gif

Step 8. Screen-> Right click-> Editable grid screen-> Select screen data (sort Customer)-> Ok.

image7.gif

Step 9. Customer table-> Right click-> Add query-> Change query name (filter Customer)-> Add filter (write query)-> Select source (sortcustomer)-> Save.

image8.gif

Step 10. Screen-> Click editable sort customer-> Add data item-> Click query-> Select filter Customer-> Ok.

image10.gif

Step 11. Now add-> Filter Customer.

filter.gif

Step 12. Now run application-> Click editable Customer grid-> Click + sign-> Fill data-> Ok-> Save-> Refresh.

image12.gif

Summary

So this article is very useful for sorting and filtering data on a screen in LightSwitch application. Using this article one can easily understand how to sorting and filtering data on screen in LightSwitch application.

Login to add your contents and source code to this article
share this article :
post comment
 
6 Months Free & No Setup Fees ASP.NET Hosting!
Become a Sponsor
PREMIUM SPONSORS
  • ceTE software specializes in components for dynamic PDF generation and manipulation. The DynamicPDF™ product line allows you to dynamically generate PDF documents, merge PDF documents and new content to existing PDF documents from within your applications.
    The leading .NET charting control now features PDF, Flash and Silverlight export, visualization of large datasets and more. Deliver true charting functionality to your BI, Scorecard, Presentation or Scientific apps. Download evaluation now.
6 Months Free & No Setup Fees ASP.NET Hosting!
Become a Sponsor