I recently came across requirement where user asked to perform complex validation before query is fired to return search screen data. So here is my code snippet you can call inside yourqueryname_ProcessQuery Create stored procedure for validation First thing we …
How to call StoredProcedure in LightSwitch for custom search screen validation Read more »
Recently someone asked me how to change default LightSwitch behavior for Search screen. Which is press enter for search. But what if you want to provide Button which user can Press to search data? Here is step-by-step info on how …
How to provide custom button for search in LightSwitch Read more »
Recently I ran out of disk space on my computer and noticed that my windows folder alone was taking crazy 45GB. I used TreeSize FREE tool Try to run the following command as administrator (Right click on command prompt icon …
How to recover windows disk space by deleting servicepack files Read more »
If you want to ask user before deleting record then write the following code in your screen code editor. Namespace LightSwitchApplication Public Class EditableCustomersGrid Private Sub gridDeleteSelected_Execute() ' Write your code here. If ShowMessageBox("Are you sure you want to delete …
I recently tried to set default values for my search screen parameters but didn’t find any option. But here is an easy way to do. Goto code view of you Search Screen and type the following code. I had 4 …
How to set default values for search screen parameters in LightSwitch Read more »
Recently someone asked me how to pass multiple values as search parameter in LightSwitch ? Well I tried to do some research and looks like there is no in-built control to select multiple items from Filter Dropdown. But after doing …
How to allow comma seperated values for search parameter in LightSwitch Read more »
If you ever store HTML or XML text in SQL Table ? Then in many scenarios you need to encode string before storing to database so when you display that text in browser it shows up correctly. Here is small …
If you ever try to update several millions of record in single Update statement then think several times because it can cause real pain. Disadvantage of single Update statement is … Its considered as single transaction and it doesn’t commit …
Here is reusable function which can be used to format SQL dateTime to any format like C# or VB.net DROP FUNCTION dbo.fnFormatDate GO CREATE FUNCTION dbo.fnFormatDate (@Datetime DATETIME, @FormatMask VARCHAR(100)) RETURNS VARCHAR(100) AS BEGIN DECLARE @StringDate VARCHAR(100) SET @StringDate = …
T-SQL Date Format Function – fnDateFormat like .net Read more »
