|
|
-
|
|
This is very interesting feature in Silverlight 5. PivotViewer control will be helpful in viewing large collections of data. This control reminds the look and feel like Excel pivot. By using this control, large collections of data can be filtered by usi...
|
|
-
|
|
We often use In-Built markup extensions such as Binding, Static Resource, Template Binding and Relative Source. We will use these markup extensions with curly braces {}. Now in Silverlight 5, we can also write our own Custom Markup Extensions.
Implem...
|
|
-
|
|
Data Templates provides great level of flexibility to controls. Once a template is created, we can use it for any control, which makes control to use the layout defined in data template.
Now in Silverlight 5, implicit data templates has been added, whi...
|
|
-
|
|
In Silverlight, few times we will get into trouble in binding, because of wrongly spelled properties. Suppose, in your viewmodel, you might have a property, "Customers", But in view, if we bind "Customer", it is very difficult to trace.
Now in silverl...
|
|
-
|
|
In WPF, when datacontext of a control changes, it will provide an explicit event, so we can track changes when the datacontext changes. But until silverlight 4, we don't have this event. Silverlight 5, now provides the datacontext changed event. When da...
|
|
-
|
|
Silverlight 5 now supports,multiple clicks events like double click, triple clicks etc. MouseLeftButtonDown event exposes a property, "ClickCount", which indicates how many times mouse has been clicked.
In below example, when you click on mouse multipl...
|
|
-
|
|
When we have a lot of items in list box/combo box, it is difficult to scroll through and find the items. Now Silverlight 5 provides type-ahead search for both combo box and list box. As you type the items in list box/combo box, scroll will proceed to th...
|
|
-
|
|
Until SQL Server 2012, LOG() function used to support only Natural Log. From SQL Server 2012 onwards, LOG() function used to accept logarithmic value of any base. Now LOG() function will accepts base value as second parameter.
SELECT LOG(10) as R...
|
|
-
|
|
When SQL Server chooses seek over scan while retrieving record details, it will compare key value with search input, based on comparison result, Query engine will move to appropriate page. Suppose, index has multiple columns, if we don't want all key co...
|
|
-
|
|
Often while tuning stored procedures, we will see tables have the "seek" operator. Few times one of reason for slow performance is wrong estimates on number of rows. Because of that, there are more chances that query optimizer choose "SEEK" over "SCAN"....
|
|