Here is simple query which shows simple technique to exclude duplicate records from output. In my example I am selecting only first record from duplicate list based on Primary key. Select * into #tmp1 From( select 1 as id,'aaa' as …
I recently had very strange issue and I felt almost lost. With windows phone project I was keep getting ‘System.IO.FileNotFoundException’ at some point after application is launched in Emulator (or Device). However My Build was successful. What I noticed that …
Windows Phone XAP missing dll and Emulator Error ‘System.IO.FileNotFoundException’ Read more »
Windows Phone 8 comes with feature called USB Mass Storage Support. Which means when you plug your phone to USB Port it will start showing up in Drive List/Device list and you can copy/move files just like regular USB drive. …
Windows Phone 8 USB detect issue – not showing up in My Computer Read more »
I just came across need where I wanted to shuffle my dictionary with random order. Here is code snippet which uses Linq to randomize order of key/value pair you added. using System; using System.Linq; namespace MyApp { public class MyClass …
How to randomize sort order in dictionary using Linq Read more »
If you try to define DoubleAnimation on Projection property then you will see lot of challenge. Here is How to fix. First make sure you create Name Attribute on Projection property like below for whatever UI element you want animate. …
WPF Animation on Projection Property using code or XAML Read more »
If you ever noticed then every FrameworkElement in WPF has property called Projection This property is very powerful if you use it right way. You can give 3D effect of any UI including Images in WPF/Silverlight Here is sample code …
Create 3D Effect using Projection in WPF/SilverLight Read more »
In this post I want to share snippet which shows simple technique to implement multiple transformations on same object. You will notice that in order to achieve this I have used TransformationGroup along with StoryBoard and DoubleAnimation private void Rotate_Click(object …
XAML Animation – How to Scale and Rotate Object (Multiple Transformations) Read more »
Sometimes you want to learn XAML tips/tricks without creating full page and don’t want to bother with Visual Studio at all then I use simple tool called kaxaml You can Download zip file from here … Or use XAMLPad another …
Quick way to edit and preview XAML Snippets using Kaxaml Read more »
How many times you felt that XAML designer was too slow for you to handle??? If you using code window most of the time for XAML Editing then you can change default edit action for XAML files as below so …
Visual Studio Tips – How to set text edit as default view for XAML file Read more »
Someone recently asked me how to export LightSwitch grid to excel format. Well sounds easy in Desktop Mode coz there is inbuilt option when you publish application in Desktop mode but what about when application is published as web app? …
How to export grid data as excel in LightSwitch Web Application Read more »