Everything SQL Server Compact: SQL Compact 3rd party tools

Everything SQL Server Compact: SQL Compact 3rd party tools: This is an attempt at a comprehensive list of SQL Server Compact 3rd party tools, both commercial and non-commercial. Please let me know if ...

Good link!

MSI - Installer Datbase Programming

Good References:
1. MSI Analyzer
http://www.c-sharpcorner.com/uploadfile/satisharveti/enhanced-msi-analyzer-in-net-using-c-sharp-and-windows-forms/

2.For tables in Installer db
  http://msdn.microsoft.com/en-us/library/windows/desktop/aa372860(v=vs.85).aspx

Saving content of a dynamically created Page

You can use this to get most of the HTML for the page:

var htmlSource = document.getElementsByTagName('html')[0].innerHTML;

However it'll lack the opening and closing HTML tags and doctype, which probably won't matter to you as you could recreate that very easily back on the server.

Ref: http://stackoverflow.com/questions/604303/saving-raw-html-of-a-dynamically-created-page

..I would add later complete code on how to save page completely soon using the hint above..

Charge your Visual Studio with extensions

Charge your Visual Studio with extensions add extensions like
a) productivity power tools by microsoft
b)vs commands 10
 and so on

ValueConvertor & MultivalueConvertors in WPF with Example

Value convertor code and usage


usage

Multivalue convertor code and usage

/// <summary>/// First one should be Result and the next value should be isWarning/// </summary>public class BoolToImageURLConverter : IMultiValueConverter{

{


{



{public object Convert(object[] values, Type targetType, object parameter, CultureInfo culture)string imagepath = string.Empty; if (values != null && values.Length == 2)bool? resultValue = values[0] as bool?;bool? isWarning = values[1] as bool?;if (resultValue.HasValue & isWarning.HasValue)//TODO:move the path to Resources// or try how to change style of the image to change the image itselfimagepath = (resultValue ==


imagepath =
}true ?"../Images/bullet_ball_glass_green.png" : "../Images/bullet_ball_glass_red.png");if (resultValue == true && isWarning == true)"../Images/bullet_ball_glass_yellow.png";else{
imagepath =
}
}"../Images/bullet_ball_glass_grey.png";else{
imagepath =
}

}

{

}
}"../Images/bullet_ball_glass_grey.png";return new System.Windows.Media.Imaging.BitmapImage(new Uri(imagepath,UriKind.Relative));public object[] ConvertBack(object value, Type[] targetTypes, object parameter, CultureInfo culture)return null;

usage

<Window.Resources><!--ValueConvertors-->
</Window.Resources>
...
<Image Width="20" Height="20" ><Image.Source><MultiBinding Converter="{StaticResource BoolToImageURLConverter}"><!--ConverterParameter="parameter value" goes inside MultiBinding tag--><Binding Path="Result" /><Binding Path="IsWarning" /></MultiBinding></Image.Source></Image><cmn:BoolToImageURLConverter x:Key="BoolToImageURLConverter"/>

 

<Window.Resources><!--ValueConvertors--><cmn:BoolToImageURLConverter x:Key="BoolToImageURLConverter"/></Window.Resources> .......
<Image Source="{Binding Path=Result, Converter={StaticResource BoolToImageURLConverter}}" Width="20" Height="20" />

public class BoolToImageURLConverter : IValueConverter{


{



{public object Convert(object value, Type targetType,object parameter, CultureInfo culture)string imagepath;bool? boolValue = value as bool?;if (boolValue.HasValue)//TODO:move the path to Resources// or try how to change style of the image to change the image itselfimagepath = boolValue ==


}true ?"../Images/bullet_ball_glass_green.png" :"../Images/bullet_ball_glass_red.png";else{
imagepath =
}

}


{

}
}"../Images/bullet_ball_glass_grey.png";return imagepath;public object ConvertBack(object value, Type targetType,object parameter, CultureInfo culture)return null;

MSI Validation using Custom ICE checks using C# ( in progress.. formatting issues)

1. The below post explains how you can perform MSI Validation using Custom ICE checks using C# code

             Ref: http://blog.deploymentengineering.com/2009/02/msi-tip-authoring-ice-using-c-dtf.html

    2. Prerequisites to use the above code are :-

           a)You would need Microsoft visual studio to open the project.

           b)Download the 'WiX Toolset v3.5 ' and install it for Visual studio from location  to open all the projects
                  given  http://wix.codeplex.com/releases/view/60102

   3.Now below are the steps to add your own ICE rules to the Cub file (using downloaded code from step 1)
      
     Step 1 : Goto Tests project .Copy paste the ICE_DE_20_Properties folder in the and rename folder and
                   files  to suite your test name accordingly Eg:ICE_CUS01.

     Step 2: Write code for own functionality properties to validate the msi. Create an appropriate filename based
                on the same.

     Step 3: Goto "CustomActions.cs" add call to your custom method eg shown below
 

[CustomAction]public static ActionResult ICE_CUS_01(Session session)new ICE_CUS_01(session).RunTests(); //Assuming you name the class same same as test namereturn ActionResult.Success;

     Step 4: Goto Cub project and add your test to the file "Cub.wxs"  under the existing custom actions           

<CustomAction Id="ICE_CUS_01" BinaryKey="ICE" DllEntry="ICE_CUS_01"/>

  Step 5: In "Cub.wxs"  under the CustomTable  tag  add your test to the list by using a code shown below

</Row>Data Column="Action">ICE_CUS_01</Data>Data Column="Condition"></Data>Data Column="Sequence">31</Data>Row>

    Step 6: Right click on Cub project and select its Project properties -> Tool Settings tab
        Add your test to the existing ICE tests in the textbox separted by semi colin
        Supress specific ICE validation : ICE_DE_10;ICE_DE_20;ICE_CUS_01


   Step 7 : Now Build the solution

   Step 8 : you are ready to use the cub file from the debug output location of the Cub project
                 "......\DTF_ICE\Cub\bin\Debug" with the file name Cub.Cub

   Step 9: now you are ready with your cub file.

....Comming soon another post on how to add your new rules to existing cub files.


References :
A good reference for people working on packages
1) http://www.installsite.org/pages/en/msi/tips.htm

2)May help : Using WIX 3.5 with Visual Studio 2010
http://blogs.planetsoftware.com.au/paul/archive/2011/02/05/using-wix-3.5-with-visual-studio-2010.aspx

An Excellent WPF TaskBar Application

Ref:
WPF TAskbar application
http://www.codeproject.com/Articles/36788/WPF-XAML-NotifyIcon-and-Taskbar-System-Tray-Popup#usingTheCode

Kinect Migration to release version of Feb 1

An excellent reference which can be referred for Kinect Code Migration to release version of Feb 1
from nov release is given below

Ref: http://robrelyea.wordpress.com/2012/02/01/k4w-code-migration-from-beta2-to-v1-0-managed/

Some good Silverlight Stuff

References

1) http://www.vectorlight.net/silverlight/tutorials.aspx   or demos.aspx

How to Check What's Using Port 80 or 443

Step1: In the Command Prompt window. type netstat -aon.

Step 2: Open up the Windows Task Manager (CTRL-ALT-DEL). In order to see the PID numbers of the various processes so you can identify which process is using Port 80, click on the Processes tab, then choose View-->Select Columns from the menu. Check the box next to PID (Process Identifier). You'll now be able to see which process matches up with the PID number you noted earlier. If you used fport, you'll already know which program it is

ref:http://www.tonerdesign.biz/web-design/46-learning-about-netstat.html