erotik film
bodyheat full moves www xxx kajal video la figa che sborra ver video de sexo porno
Luxury replica watches
escort antalya

** THIS SITE IS AN ARCHIVE ** - New Content is at:

Apr 12

Written by: Michael Washington
4/12/2013 6:31 AM  RssIcon

The LightSwitch HTML Client allows you to easily create a server side search.


We start with a simple Browse screen.



First, we add a property.



We create a Search property.



The property will be added to the View Model on the Screen.

We now select Edit Query.



We create a query that takes a parameter.



We click on the parameter and in its Properties we make it Optional.



We bind the Search property to the SearchParameter.



The line shows that the Search property is bound to the SearchParameter.



We drag and drop the Search property to the Screen layout.



We switch the Search element to a Text Box.



When we run the application and enter a search term and hit the Enter key (or Tab or click away) a server side paged search is executed.

11 comment(s) so far...

is an option to use a grid in html client like we do in silverlight ?
any third party can html5 grid ?
the most important control is missinig...

By alon on   4/15/2013 8:25 AM

@alon - You would have to use a 3rd party control.

By Michael Washington on   4/15/2013 8:27 AM

I think that becuase grid control is the most missing for all lightswitch developers,
sample of third party grid (like wijmo, telerik, devexpress) with dynamic tabs. (like we do in silverlight) is all wish

when we can combine controls from Third party, we can Eventually say Goodbye to silverlight....
with great hope that microsoft will deliver more and more JS controls to lightswitch.

before 3 or 4 years, silverlight was the best - but now - all developers want html5 + JS.

Thanks for all !!!

By alon on   4/19/2013 6:45 AM

I encountered a small issue when adding a search to my app, and am hoping there's an answer. My data resides on an Oracle 10 db, so all of the queries are case sensitive. Is there any way to tell Lightswitch to add a lower() or upper() to the generated query as well as to convert the input text the same way?



By Michael Whitis on   8/1/2013 5:25 AM

@Michael Whitis - Sorry I have no code samples. You will want to post to the official LightSwitch Forums at:

By Michael Washington on   8/1/2013 5:37 AM

Good post, the only thing is, after searching you delete all characters from the Search textbox and press Enter, no records are displayed (opposite of what's expected). I'm sure you fixed it already. (I'm using VS2013 HTML Client)

By Nicolas Lope de Barrios on   3/5/2014 10:14 AM

I forgot to mark the parameter as Optional in the query. My bad! sorry about that.

By Nicolas Lope de Barrios on   3/5/2014 10:19 AM

Is there a solution available for the issue of Michael Whitis? I am encountering the same problem.

By Rob Vaes on   11/24/2014 2:15 PM

@Rob Vaes - Sorry I have never encountered that problem because I don't use Oracle :( You will want to post to the official LightSwitch Forums at:

By Michael Washington on   11/24/2014 3:15 PM

Thank you so much for this Michael. I am also working my way through your book as I am new to LS. I did note that after following this procedure the search button is rendered at the bottom of the page and clicking it produces a second search textbox. That i believe will be confusing to the users of the app I am writing(my first LS). Is there a way I can avoid this duplication?

By Doyle Johnson on   1/4/2015 8:15 PM

@Doyle Johnson - On the properties for the table (in the server project) you should be able to unselect the box "Is Searchable"

By Michael Washington on   1/4/2015 8:31 PM
Microsoft Visual Studio is a registered trademark of Microsoft Corporation / LightSwitch is a registered trademark of Microsoft Corporation