If you are having a problem in filtering a many-to-many related data in your Microsoft Lightswitch project, don’t worry I have a simple solution for you. Here it goes. Lets say you have a table structure like the one above and you want to filter off the Task (sysTask) of a chosen User (mstUser). As… Read More How to filter many-to-many related data in Microsoft Lightswitch?
I receive tons of question on how to set a default value on an unbound Auto Complete Box, my initial response to this question is to bound it and equate the data binding to the FirstOrDefault property of a LINQ statement. Because I really don’t know how to do it on an unbound Auto Complete… Read More How to set a default value on an unbound Auto Complete Box?
First and foremost let me define what is multitenancy: Multitenancy refers to a principle in software architecture where a single instance of the software runs on a server, serving multiple client organizations (tenants). – wiki Multitenancy is one basic attribute of true cloud computing. To implement it in Lightswitch just follow the steps below: STEP… Read More My first attempt to create a multi-tenant Ligthswitch application.
Most report requires a Prepared By notation at the Page Footer to signify who prepared the report. Furthermore, the Prepared By notation requires the current user to be the default value. To do this you need to follow the step below: 1. Add a public property in the application class, a class use to contain… Read More How to print the current user as Prepared By in your DevExpress report?
There is actually no change in creating a WCF RIA Service in Lightswitch 2012, just follow the guide I did in Lightswitch 2011 (How to create a VB WCF RIA Services for Microsoft Lightswitch to aggregate or join tables at the same time pass a parameter?). Just be very careful on the framework version. As seen… Read More How to create and consume a WCF RIA Service in Microsoft Lightswitch 2012?
There is only one reason why you need to upgrade your DevExpress Xtrareort 1.11 to 1.12, the older version has bugs, for example, your print button is sometimes disabled even if the report is ready to print. Before you upgrade you need to download the components at http://www.devexpress.com/, then install it. The first thing I… Read More How to upgrade your current DevExpress Xtrareport 1.11 to 1.12 version?
In this example we will be using the dialog box similar to what we used in exporting a CSV File. The first step is to add a handler to a button. To add a handler you need to modify the created method of the screen to which the button resides. The second step is to… Read More How to import a CSV file using Microsoft Lightswitch?
I am proud to share to everyone that the first Innosoft’s Web-POS application using Microsoft Lightswitch is now accepted by the client. Acceptance for the application means that it now has the features needed in order for it to be used in production using live data, it is the final step of the entire development… Read More Innosoft’s first Web-POS (Sales/Inventory) application using Microsoft Lightswitch is now accepted.
Whenever there is a requirement to edit records by batch in my Microsoft Lightswitch project I would normally make a grid, and from the grid the records get edited. But you can edit the records directly using the DataWorkspace object, see the code below. The above code extract a set of record in the Sales… Read More How to directly edit a record in your Microsoft Lightswitch data source?
One of my clients requires me to synchronize their Oracle database to the MS SQL database that is used by the Microsoft Ligthswitch application. Since the record for synchronization is more than 10,000 I have no choice but to merge the two database using WCF RIA Service. Notice below that we have two datasources, oracle… Read More How to merge Oracle with Microsoft SQL using WCF RIA Service?