Monthly Archives: April 2011

LightSwitch – Add non existent records using AutoCompleteBox

Overview of Article The LightSwitch AutoCompleteBox allows you select records using a dropdown list or to enter some text into the control. Typing into the AutoCompleteBox filters down the selectable records. If a non existent record entered, it’s likely that … Continue reading

Posted in LightSwitch | 23 Comments

LightSwitch – In What Order do Screen Events Fire?

Overview of Article There are various screen events available in LightSwitch. At the moment, there isn’t very much documentation specifying the order in which these events fire. The following post documents my findings in relation to the ordering of events. … Continue reading

Posted in LightSwitch | 3 Comments

LightSwitch – Displaying Web Pages / HTML on a Screen

Overview of Article Continuing with our earlier post on adding custom controls from the System.Windows.Controls namespace, the following article describes how to add a WebBrowser control onto a LightSwitch Screen. This will allow us to display HTML or load web … Continue reading

Posted in LightSwitch | 17 Comments

LightSwitch – Creating a Masked Password TextBox Part 2

Overview of Article Here’s an update to my previous post on creating a masked textbox. The previous sample used the LostFocus event to save the password data into the entity. After a prompt from Yann Duran, the code has now … Continue reading

Posted in LightSwitch | 3 Comments

LightSwitch – Creating a Masked Password TextBox Control

Overview of Article The following article explains a method for entering passwords using masked textboxes in LightSwitch. Data The data used in this example will be very basic. We’ll simply create a Customer table with ‘Customer Name’ and ‘Password’ fields. … Continue reading

Posted in LightSwitch | Leave a comment

LightSwitch – Formatting Decimal Values

Stephen Weatherford posted a sample custom control for formatting decimal values on the following thread. http://social.msdn.microsoft.com/Forums/en-US/lightswitchgeneral/thread/563c07df-7641-4a54-a0ba-8d5bb675cb7a An interesting part of his suggestion was adding the custom control into the LightSwitch ‘Client Project’ rather than creating a Silverlight Custom Control project.  A … Continue reading

Posted in LightSwitch | Leave a comment

LightSwitch – Fill AutoCompleteBox with Database values

Overview of Article LightSwitch automatically creates dropdown boxes if relationships are correctly set up between tables. It steers you towards creating correct data relationships which is a good thing. However, there are exceptional circumstances when relationships have not or can … Continue reading

Posted in LightSwitch | 24 Comments

LightSwitch – Nested AutoCompleteBox for data entry Part 2

Overview of Article The previous article demonstrated a method for creating a pair of nested pair of dropdown boxes.http://dotnettim.wordpress.com/2011/03/20/lightswitch-nested-autocompletebox-for-data-entry/ A slight problem with nested controls is that the process will vary depending upon the schema of the database. The following … Continue reading

Posted in LightSwitch | 4 Comments

SQL Server – Run Scheduled Scripts without SQL Agent

Here’s a really useful article on how to schedule backups and to run SQL scripts without using SQL Agent. http://www.diaryofaninja.com/blog/2011/02/14/howto-quick-amp-dirty-sql-express-scheduled-backup This is particularly relevant for SQL Server Express installations where agent isn’t available. The pertinent part of this is using … Continue reading

Posted in SQL Server | Leave a comment

LightSwitch – Microsoft MSDN newsletter article

This months UK MSDN Flash newsletter features an article that I’ve written on LightSwitch. The content can be found here: http://blogs.msdn.com/b/ukmsdn/archive/2011/03/23/featured-article-turning-on-the-lightswitch.aspx I’d like to thank Ben Hayatt and Garth Henderson for their assistance in proof reading this.

Posted in LightSwitch | Leave a comment