Click here to Skip to main content
15,886,805 members
Articles / Database Development / SQL Server

Using SQL Server Metadata and Statistics to Build a Table Explorer Application

Rate me:
Please Sign up or sign in to vote.
5.00/5 (2 votes)
1 Oct 2012CPOL8 min read 22.4K   488   7  
Develops an analogy between database table and file directory information and argues that it could be very useful if it were possible to have a similar application to Windows Explorer for database tables. Demonstrates how to obtain the information from Sql Server system tables and dynamic management
<?xml version="1.0" encoding="utf-8"?>
<root>
  <!-- 
    Microsoft ResX Schema 
    
    Version 2.0
    
    The primary goals of this format is to allow a simple XML format 
    that is mostly human readable. The generation and parsing of the 
    various data types are done through the TypeConverter classes 
    associated with the data types.
    
    Example:
    
    ... ado.net/XML headers & schema ...
    <resheader name="resmimetype">text/microsoft-resx</resheader>
    <resheader name="version">2.0</resheader>
    <resheader name="reader">System.Resources.ResXResourceReader, System.Windows.Forms, ...</resheader>
    <resheader name="writer">System.Resources.ResXResourceWriter, System.Windows.Forms, ...</resheader>
    <data name="Name1"><value>this is my long string</value><comment>this is a comment</comment></data>
    <data name="Color1" type="System.Drawing.Color, System.Drawing">Blue</data>
    <data name="Bitmap1" mimetype="application/x-microsoft.net.object.binary.base64">
        <value>[base64 mime encoded serialized .NET Framework object]</value>
    </data>
    <data name="Icon1" type="System.Drawing.Icon, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
        <value>[base64 mime encoded string representing a byte array form of the .NET Framework object]</value>
        <comment>This is a comment</comment>
    </data>
                
    There are any number of "resheader" rows that contain simple 
    name/value pairs.
    
    Each data row contains a name, and value. The row also contains a 
    type or mimetype. Type corresponds to a .NET class that support 
    text/value conversion through the TypeConverter architecture. 
    Classes that don't support this are serialized and stored with the 
    mimetype set.
    
    The mimetype is used for serialized objects, and tells the 
    ResXResourceReader how to depersist the object. This is currently not 
    extensible. For a given mimetype the value must be set accordingly:
    
    Note - application/x-microsoft.net.object.binary.base64 is the format 
    that the ResXResourceWriter will generate, however the reader can 
    read any of the formats listed below.
    
    mimetype: application/x-microsoft.net.object.binary.base64
    value   : The object must be serialized with 
            : System.Runtime.Serialization.Formatters.Binary.BinaryFormatter
            : and then encoded with base64 encoding.
    
    mimetype: application/x-microsoft.net.object.soap.base64
    value   : The object must be serialized with 
            : System.Runtime.Serialization.Formatters.Soap.SoapFormatter
            : and then encoded with base64 encoding.

    mimetype: application/x-microsoft.net.object.bytearray.base64
    value   : The object must be serialized into a byte array 
            : using a System.ComponentModel.TypeConverter
            : and then encoded with base64 encoding.
    -->
  <xsd:schema id="root" xmlns="" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
    <xsd:import namespace="http://www.w3.org/XML/1998/namespace" />
    <xsd:element name="root" msdata:IsDataSet="true">
      <xsd:complexType>
        <xsd:choice maxOccurs="unbounded">
          <xsd:element name="metadata">
            <xsd:complexType>
              <xsd:sequence>
                <xsd:element name="value" type="xsd:string" minOccurs="0" />
              </xsd:sequence>
              <xsd:attribute name="name" use="required" type="xsd:string" />
              <xsd:attribute name="type" type="xsd:string" />
              <xsd:attribute name="mimetype" type="xsd:string" />
              <xsd:attribute ref="xml:space" />
            </xsd:complexType>
          </xsd:element>
          <xsd:element name="assembly">
            <xsd:complexType>
              <xsd:attribute name="alias" type="xsd:string" />
              <xsd:attribute name="name" type="xsd:string" />
            </xsd:complexType>
          </xsd:element>
          <xsd:element name="data">
            <xsd:complexType>
              <xsd:sequence>
                <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />
                <xsd:element name="comment" type="xsd:string" minOccurs="0" msdata:Ordinal="2" />
              </xsd:sequence>
              <xsd:attribute name="name" type="xsd:string" use="required" msdata:Ordinal="1" />
              <xsd:attribute name="type" type="xsd:string" msdata:Ordinal="3" />
              <xsd:attribute name="mimetype" type="xsd:string" msdata:Ordinal="4" />
              <xsd:attribute ref="xml:space" />
            </xsd:complexType>
          </xsd:element>
          <xsd:element name="resheader">
            <xsd:complexType>
              <xsd:sequence>
                <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />
              </xsd:sequence>
              <xsd:attribute name="name" type="xsd:string" use="required" />
            </xsd:complexType>
          </xsd:element>
        </xsd:choice>
      </xsd:complexType>
    </xsd:element>
  </xsd:schema>
  <resheader name="resmimetype">
    <value>text/microsoft-resx</value>
  </resheader>
  <resheader name="version">
    <value>2.0</value>
  </resheader>
  <resheader name="reader">
    <value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
  </resheader>
  <resheader name="writer">
    <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
  </resheader>
  <metadata name="mainMenu.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
    <value>150, 17</value>
  </metadata>
  <metadata name="thePopup.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
    <value>361, 17</value>
  </metadata>
  <metadata name="tbarImages.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
    <value>253, 17</value>
  </metadata>
  <data name="tbarImages.ImageStream" mimetype="application/x-microsoft.net.object.binary.base64">
    <value>
        AAEAAAD/////AQAAAAAAAAAMAgAAAFdTeXN0ZW0uV2luZG93cy5Gb3JtcywgVmVyc2lvbj00LjAuMC4w
        LCBDdWx0dXJlPW5ldXRyYWwsIFB1YmxpY0tleVRva2VuPWI3N2E1YzU2MTkzNGUwODkFAQAAACZTeXN0
        ZW0uV2luZG93cy5Gb3Jtcy5JbWFnZUxpc3RTdHJlYW1lcgEAAAAERGF0YQcCAgAAAAkDAAAADwMAAACS
        HgAAAk1TRnQBSQFMAgEBDgEAAXQBAAF0AQABEAEAARABAAT/ARkBAAj/AUIBTQE2BwABNgMAASgDAAFA
        AwABQAMAAQEBAAEYBgABMEsAJICZAAEQAQABEB4AARABAAEQA4B1AB7FCQAe/wIAAlABAAH/aAABmwIA
        AZsCAAGbIQADxQkAG/8CeAH/AgABrwHvAQAB/2gAAZsCAAGbCQAYxQMAA8UJAAP/DwAD/wLnAf8CQAH/
        AocB/wMAA4BoAAGbDAAG/gPFBv4DxQb+AwADxQkAEv8CxwH/AjAB/wK/BP8DAAOAaQAJxQMAGMUDAAPF
        CQAD/wkAA/8CjwH/AjgB/wLnB/8DAAOAdQAB/gFPAQYB/gFPAQYB/gFPAQYB/gFPAQYB/gFPAQYB/gFP
        AQYB/gFPAQYB/gFPAQYPAAn/AvcB/wJYAf8CcA3/AwADgGYADMUqAAb/AtcB/wI4Af8CpxD/AwADgGYA
        A/4DxQP+A8UG/gPFA/4DAAPFGAAD/wQAAdgB/wLPAf8MAAb/AwADgGYAGMUDAAPFCAABmw8AHv8DAAOA
        ZgAB/gFPAQYB/gFPAQYB/gFPAQYB/gFPAQYB/gFPAQYB/gFPAQYB/gFPAQYB/gFPAQYDAAPFBQABmwIA
        AZsPAAP/FQAG/wMAA4CGAAGbAgABmwIAAZsPAB7/AwADgJkAATABAAEwHgABMAEAATD/AP8AnwAD7wNQ
        OQADEAwAAxADAAMQCQADEFoAA4IDFgM8GAABvQG+Ab0eAAGEAYIBhAH/ASQBAAf/ASQHAAGEAYIBhAP/
        AQAB2wH/AYQBggGEQgAB4gL6AckC3gGfArABcAJ8AWYCcQFpAnUBfAKJAYsCmgMAAzIDAAPCGAABvQG+
        Ab0eAAGEAYIBhAf/ASQBAAP/BgABhAGCAYQG/wEAAdsB/xIAA9cDQA8AA0AYAAHMAuIDAAMjBnQDcwNH
        ATwCQwYAA94bAAG9Ab4BvR4AAYQBggGEAf8B2wFKCf8GAAGEAYIBhAFzAfMH/xUAA0ADaAOAJAABpwK5
        AZUCoAG2ArwJ/wO9AVECVAMEIQABvQG+Ab0eAAGEAYIBhAf/AZIBQgP/BgABhAGCAoQBggKEAYIChAGC
        AYQBMQEwATEVAAOXAyADryEAAX8CjQOHD/8B4wLkAxMbAAG9Ab4BvQMAAb0BvgG9BgABvQG+Ab0VAAGE
        AYIChAGCAoQBggKEAYIChAGCAYQtAAPvA1ADnx4AAXACfAGqAq4D/wwAAeEC4gMTIQABvQG+Ab0JAAG9
        Ab4BvSQAAxAMAAEIAQwBCBsAA4ADCB4AAYICkAOID/8B5ALlAxMeAAG9Ab4BvQ8AAb0BvgG9DAADEAwA
        AxADAAGEAYIBhAEAAf8BSgb/AYQBggGEGwAD1wNAA58eAAGlArcBoAKqAcUCygn/Ad8C4gGnAq4DCRUA
        Ab0BvgG9AwABvQG+Ab0SAAG9Ab4BvQwAAYQBggGEA/8CAAT/AYQBggGEBgABhAGCAYQG/wEAAf8BSgP/
        GAADjwMwA8chAAHKAuADAAMwBqEDoANiAYkCmBsAAb0BvgG9GAABvQG+Ab0JAAGEAYIBhAn/AgAB/wYA
        AYQBggGEA/8BAAH/AbUG/xUAA68DUAOAJAAB4gL6AcoC4AGnArkBfgKMAW4CegFzAoABjgKdAbYCyhgA
        Ab0BvgG9JwABhAGCAYQBAAFpCv8GAAGEAYIBhAn/AQAB/wFKEgAD1wMcDwADQBgAAecC/xIAAeMC+0IA
        AYQBggGEBv8CAAT/BgABhAGCAoQBggKEAYIChAGCAoQBggGEASkBLAEpPwAB5wL/AecC/wHnAv8B5wL/
        AecC/wHnAv8B5wL/AecC/0IAAYQBggKEAYIChAGCAoQBggKEAYIBhAExATABMf8A/wADAAHGAccCxgHH
        AsYBxwLGAccCxgHHAsYBxwLGAccCxgHHAsYBxwLGAccCxgHHAsYBxwLGAccBxgkAAcYBxwLGAccCxgHH
        AsYBxwLGAccCxgHHAsYBxwLGAccCxgHHAsYBxwLGAccCxgHHAsYBxwHGCQAkvAwAAc4BzwLOAc8CzgHP
        As4BzwLOAc8CzgHPAs4BzwLOAc8CzgHPAs4BzwHODwADEAMAAYQBggGECQABhAGCAYQJAAGEAYIBhAYA
        AcYBxwHGBgABIAEOAXIBFwEEAWkBZQFRAbYBFwEEAWkBFwEEAWkBFwEEAWkBZQFRAbYBEgEDAVIGAAGE
        AYIBhAYAAcYBxwHGBgADgAMAA7wJAAO8DwADvAkAAYwBigGMAYQBggKEAYIChAGCAoQBggKEAYIChAGC
        AoQBggKEAYIBhAGMAYoBjAHOAc8BzhIAAYQBggKEAYIChAGCAYQDAAGEAYIChAGCAoQBggGEAwABhAGC
        AoQBggKEAYIBhAMAAcYBxwHGBgABFwEEAWkBZQFRAbYBZQFRAbYBZQFRAbYBFwEEAWkBZQFRAbYBZQFR
        AbYBawFcAasDAAGEAYIChAGCAoQBggGEAwABxgHHAcYGAAOAHtgDAAO8CQABhAGCAYQM/wGEAYIBhAn/
        AYQBggGEAc4BzwHODwABhAGCAYQB5wL/AecC/wHnAv8DAAHnAv8B5wL/AecC/wMAAecC/wHnAv8B5wL/
        AYQBggGEAcYBxwHGBgABZQFRAbYBnwGaAf8BnwGaAf8BnwGaAf8BFwEEAWkBnwGaAf8BnwGaAf8BrwGw
        Af8DAAHnAv8B5wL/AecC/wGEAYIBhAHGAccBxgYAA4AD2Bj/A9gDAAO8CQABhAGCAYQM/wGEAYIBhAQA
        AdsE/wGEAYIBhAHOAc8BzhIAAecC/wHnAv8B5wL/AwAB5wL/AecC/wHnAv8BhAGCAYQB5wL/AecC/wHn
        Av8DAAHGAccBxgYAARcBBAFpAZ8BmgH/AZ8BmgH/AZ8BmgH/ARcBBAFpAZ8BmgH/AZ8BmgH/Aa8BsAH/
        AYQBggGEAecC/wHnAv8B5wL/AwABxgHHAcYGAAOAA/8DAAOAAwADgAMAA4ADAAOAA9gDAAO8CQABhAGC
        AYQM/wGEAYIBhAEAAdsB/wEAAdsB/wFjAesB/wFaAaoBvQHOAc8BzhIAAYQBggKEAYIChAGCAYQDAAGE
        AYIChAGCAoQBggGEAwABhAGCAoQBggKEAYIBhAMAAcYBxwHGBgABFwEEAWkBZQFRAbYBZQFRAbYBZQFR
        AbYBFwEEAWkBZQFRAbYBZQFRAbYBawFcAasDAAGEAYIChAGCAoQBggGEAwABxgHHAcYGAAOAA9gY/wPY
        AwADvAkAAYQBggGEDP8BhAGCAYQD/wFjAesB/wGcAfMB/wFKAbYBxgGEAe8B/w8AAYQBggGEAecC/wHn
        Av8B5wL/AYQBggGEAecC/wHnAv8B5wL/AwAB5wL/AecC/wHnAv8DAAHGAccBxgYAAWUBUQG2AZ8BmgH/
        AZ8BmgH/AZ8BmgH/AWUBUQG2AZ8BmgH/AZ8BmgH/Aa8BsAH/AwAB5wL/AecC/wHnAv8DAAHGAccBxgYA
        A4AD/wMAA4AG/wmAA/8D2AMAA7wJAAGEAYIBhAz/AYQBggGEBv8BhAHvAf8BSgG2AcYBpQHzAf8BawHr
        Af8PAAHnAv8B5wL/AecC/wMAAecC/wHnAv8B5wL/AYQBggGEAecC/wHnAv8B5wL/AYQBggGEAcYBxwHG
        BgABFwEEAWkBnwGaAf8BnwGaAf8BnwGaAf8BFwEEAWkBnwGaAf8BnwGaAf8BrwGwAf8BhAGCAYQB5wL/
        AecC/wHnAv8BhAGCAYQBxgHHAcYGAAOAA9gY/wPYAwADvAkAAYQBggGEDP8BhAGCAYQJ/wFaAaoBvQFr
        AesB/wG1AfcB/wFaAesB/wkAAYQBggKEAYIChAGCAoQBggGEAwABhAGCAoQBggKEAYIBhAMAAYQBggKE
        AYIChAGCAoQBggGEAcYBxwHGBgABZQFRAbYBZQFRAbYBZQFRAbYBZQFRAbYBFwEEAWkBZQFRAbYBZQFR
        AbYBawFcAasDAAGEAYIChAGCAoQBggKEAYIBhAHGAccBxgYAA4AJ/wMAA4ADAAn/A9gDAAO8CQABhAGC
        AoQBggKEAYIChAGCAoQBggKEAYIChAGCAoQBggKEAYIChAGCAYQBvQH3Af8BWgHrAf8BxgH3Af8BUgHr
        Af8B1gH7Af8GAAHnAv8B5wL/AecC/wGEAYIBhAHnAv8B5wL/AecC/wMAAecC/wHnAv8B5wL/AwABxgHH
        AcYGAAEXAQQBaQGfAZoB/wGfAZoB/wGfAZoB/wFlAVEBtgGfAZoB/wGfAZoB/wGvAbAB/wMAAecC/wHn
        Av8B5wL/AwABxgHHAcYGAAOAA9gY/wPYAwADvAkAAYQBggGEDP8BhAGCAYQJ/wGEAYIBhAHOAc8BzgMA
        AVIB6wH/AcYB9wH/AYQB7wH/AwABhAGCAYQB5wL/AecC/wHnAv8DAAHnAv8B5wL/AecC/wGEAYIBhAHn
        Av8B5wL/AecC/wMAAcYBxwHGBgABZQFRAbYBnwGaAf8BnwGaAf8BnwGaAf8BFwEEAWkBnwGaAf8BnwGa
        Af8BrwGwAf8BhAGCAYQB5wL/AecC/wHnAv8DAAHGAccBxgYAA4AJ/wMAA4ADAAOABv8D2AMAA7wJAAGE
        AYIBhAz/AYQBggGECf8BhAGCAYQBzgHPAc4GAAGEAe8B/wkAAUIBQQFCAYQBggGECQABhAGCAYQJAAGE
        AYIBhAMAAYQBggGEAcYBxwHGBgABFwEEAWkBPgErAY8BZQFRAbYBFwEEAWkBFwEEAWkBFwEEAWkBZQFR
        AbYBEgEDAVIGAAGEAYIBhAMAAYQBggGEAcYBxwHGBgADgAPYGP8D2AMAA7wJAAGEAYIBhAz/AYQBggGE
        Cf8BhAGCAYQBzgHPAc4SAAHGAccCxgHHAsYBxwHGAwABxgHHAsYBxwLGAccBxgMAAcYBxwLGAccCxgHH
        AcYDAAHGAccBxgYAARcBBAFpAYsBegHdAYsBegHdAYsBegHdARcBBAFpAYsBegHdAYsBegHdAZgBigHY
        AwABxgHHAsYBxwLGAccBxgMAAcYBxwHGBgADgAP/AwADgAYABv8GgAPYAwADvAkAAYQBggGEDP8BhAGC
        AYQJ/wGEAYIBhAHOAc8BzhIAAcYBxwLGAccCxgHHAcYDAAHGAccCxgHHAsYBxwHGAwABxgHHAsYBxwLG
        AccBxgMAAcYBxwHGBgABFwEEAWkBiwF6Ad0BiwF6Ad0BiwF6Ad0BFwEEAWkBiwF6Ad0BiwF6Ad0BmAGK
        AdgDAAHGAccCxgHHAsYBxwHGAwABxgHHAcYGAAOAA9gY/wPYAwADvAkAAZwBmgGcAYQBggKEAYIChAGC
        AoQBggKEAYIChAGCAoQBggKEAYIBhAGcAZoBnBIAAYQBggGEAwABhAGCAYQDAAGEAYIBhAMAAYQBggGE
        CQABhAGCAYQPAAFlAVEBtgEXAQQBaQFlAVEBtgEXAQQBaQFlAVEBtgEXAQQBaQFlAVEBtgESAQMBUgYA
        AYQBggGEDwAGgAO8AwADvAMAA7wJAAO8/wBpAAGEAbYBxgFrAZoBrQFaAYYBnAFKAXUBjAFCAWkBhAFC
        AXEBlAFCAYIBpQFjAZoBvUgAAc4BzwHOAVoBWQFaAxAGAAMIAVIBUQFSAb0BvgG9GwAB5gHlAeYBigGM
        AYoBLQE2ATABFgEfARgBHgEnASABaQFxAWwD1xUAAVIBjgGtAVoBogG9AXsBwwHWAZQB2wHnAYQB3wH3
        AVIBxwHvASEBqgHeAQgBkgHGASEBggGtATEBbQGUQgABnAGeAZwBOQE4ATkBAAF9ASEBAAF9ASEBAAF9
        ASEBAAF9ASEBAAF9ASEBAAF9ASEBQgFBAUIBhAGGAYQVAAPDASMBNQEoAWABcgFlAQABfAEhAQABkQE4
        AQABfQEhAQABfQEhARsBLgEhAZIBlAGSDwABWgGGAZwBQgG+AecBYwHTAfcBjAHjAfcBpQHrAfcBhAHf
        AfcBUgHLAfcBEAG2Ae8BAAGqAe8BAAGiAecBAAGWAdYBOQFdAXs8AAGcAZ4BnAFjAWEBYwEAAX0BIQEA
        AX0BIQEAAX0BIQEAAX0BIQEAAX0BIQEAAX0BIQEAAX0BIQEAAX0BIQF7AXkCewF9AXsPAAO1ASYBQgEt
        AQABfAEhAQABfQEhATsBmwFUATsB/gHFATsBmwFVAQABfQEhAQABfQEhAUsBZwFTAYQBhQGEDAABWgGG
        AZwBQgHHAfcBawHXAfcBjAHjAfcBpQHrAfcBhAHfAfcBUgHLAfcBEAG2Ae8BAAGqAe8BAAGiAecBAAGe
        Ad4BOQFdAXs5AAPnASEBIAEhAQABfQEhAQABfQEhAQABfQEhA/8BAAF9ASEBAAF9ASEBAAF9ASEBAAF9
        ASEBAAF9ASEBAAF9ASEBUgFRAVIBrQGuAa0MAAFBAT8BQQEAAXwBIQEAAX0BIQEAAaQBTgP+Bv8BAAGl
        AU8BAAF9ASEBAAF9ASEBJwFNATEBqQGqAakJAAFjAY4BpQFCAccB7wFrAdcB9wGMAeMB9wGlAesB9wGE
        Ad8B9wFSAcsB9wEQAbYB7wEAAaoB7wEAAaIB5wEAAZ4B3gFCAWkBhDkAAXMBcQFzAQABfQEhAQABfQEh
        AQABfQEhAQAB/wG1A/8BAAF9ASEBAAF9ASEBAAF9ASEBAAF9ASEBAAF9ASEBAAF9ASEBAAF9ASEBSgFJ
        AUoJAAOCATwBawFJAQABfAEhAWIBrwF2AWIB/gHRAf4B/wH+Bv8BYwH/AdEBYgGvAXcBAAF9ASEBAAF9
        ASEDPQkAAWMBjgGlAUIBxwH3AWsB1wH3AYwB4wH3AaUB6wH3AYQB3wH3AVIBywH3ARABtgHvAQABqgHv
        AQABogHnAQABngHeAUIBaQGECQABEAEAARAkAAEQAQABEAYAASEBIAEhAQABfQEhAQABfQEhCf8BAAH/
        AbUBAAH/AbUBAAH/AbUBAAH/AbUBAAH/AbUBAAF9ASEBAAF9ASEDCAkAAU8BTQFPAQABfAEhAQABfQEh
        AYcBwgGXAYgBwgGXAYgB/gHcAf4B/wH+AYgB/wHcAYgBwgGYAYgBwgGXAQABfQEhAQABfQEhAQgBCQEI
        CQABYwGOAaUBQgHHAfcBawHXAfcBjAHjAfcBpQHrAfcBhAHfAfcBUgHLAfcBEAG2Ae8BAAGqAe8BAAGi
        AecBAAGeAd4BQgFpAYQMACT/CQADGAEAAX0BIQEAAf8BtRX/AQAB/wG1AQABfQEhAQABfQEhDAABQgFA
        AUIBAAF8ASEBAAF9ASEBAAF9ASEBAAF9ASEBAAH+AbQB/gH/Af4BAAH/AbUBAAF9ASEBAAF9ASEBAAF9
        ASEBAAF9ASEMAAFrAZYBrQFCAccB9wFrAdcB9wGMAeMB9wGlAesB9wGEAd8B9wFSAcsB9wEQAbYB7wEA
        AaoB7wEAAaIB5wEAAZ4B3gFCAWkBhAwAJP8JAAExATABMQEAAX0BIQEAAX0BIQn/AQAB/wG1AQAB/wG1
        AQAB/wG1AQAB/wG1AQAB/wG1AQABfQEhAQABfQEhAxAJAAFHAUUBRwEAAXwBIQEAAX0BIQEAAX0BIQEA
        AX0BIQEAAf4BtAH+Af8B/gEAAf8BtQEAAX0BIQEAAX0BIQEAAX0BIQEAAX0BIQEEAgUJAAFrAZYBrQFC
        AccB9wFrAdcB9wGMAeMB9wGlAesB9wGEAd8B9wFSAcsB9wEQAbYB7wEAAaoB7wEAAaIB5wEAAZ4B3gFK
        AXUBjAwAJP8BkwH/Af0GAAGMAY4BjAFzAXEBcwEAAX0BIQEAAX0BIQEAAf8BtQP/AQABfQEhAQABfQEh
        AQABfQEhAQABfQEhAQABfQEhAQABfQEhAQABfQEhAWMBYQFjCQABfQF+AX0BSgFvAVQBAAF8ASEBAAF9
        ASEBAAF9ASEBAAH+AbQB/gH/Af4BAAH/AbUBAAF9ASEBAAF9ASEBAAF9ASEBAAF9ASEDOwkAAWsBmgGt
        AUIBxwH3AWsB1wH3AYwB4wH3AaUB6wH3AYQB3wH3AVIBywH3ARABtgHvAQABqgHvAQABogHnAQABngHe
        AUoBdQGMOQAD9wEpASgBKQEAAX0BIQEAAX0BIQEAAX0BIQP/AQABfQEhAQABfQEhAQABfQEhAQABfQEh
        AQABfQEhAQABfQEhASkBKAEpAd4B3wHeCQAB4AHfAeABMgExATIBAAF8ASEBAAF9ASEBAAF9ASEBAAH+
        AbQBOgH/AcUBAAH/AbUBAAF9ASEBAAF9ASEBAAF9ASEBMgFPAToBowGkAaMJAAFrAZoBtQFCAccB9wFr
        AdcB9wGMAeMB9wGlAesB9wGEAd8B9wFSAcsB9wEQAbYB7wEAAaoB7wEAAaIB5wEAAZ4B3gFKAXUBjDAA
        ASgB9wH/CQAB3gHfAd4BMQEwATEBAAF9ASEBAAF9ASEBAAF9ASEBAAF9ASEBAAF9ASEBAAF9ASEBAAF9
        ASEBAAF9ASEBQgFBAUIBtQG2AbUPAAOtATgBSgE9AQABfAEhAQABfQEhAQABkAE3AQABkAE3AQABkAE3
        AQABfQEhAQABfQEhAWcBeQFsAXkBewF5DAABcwGeAbUBQgHHAfcBawHXAfcBjAHjAfcBpQHrAfcBhAHf
        AfcBUgHLAfcBEAG2Ae8BAAGqAe8BAAGiAecBAAGeAd4BUgF9AZQnAAGTAf8B/QMAASgB9wH/AVsBwAH/
        ASgB9wH/CQAB3gHfAd4BMQEwATEBYwFhAWMBAAF9ASEBAAF9ASEBAAF9ASEBAAF9ASEBawFpAWsBIQEg
        ASEBxgHHAcYVAAOsASYBLgEoAQABfAEhAQABfQEhAQABfQEhAQABfQEhAQABfQEhAUsBVAFOAXoBfAF6
        DwABcwGiAb0BawHXAfcBnAHrAfcBtQHzAf8BxgH7Af8BxgH7Af8BxgH3Af8BrQHzAf8BjAHjAfcBawHX
        AfcBOQG6AecBUgF9AZQwAAEoAfcB/xIAAZwBngGcAVoBWQFaAUIBQQJCAUEBQgFKAUkBSgGUAZYBlAP3
        GwAD3gFjAWEBYwMQAwADBwFJAUgBSQGsAa0BrBIAAXMBogG9AcYB+wH/AcYB+wH/AcYB+wH/AcYB+wH/
        AcYB+wH/AcYB+wH/AcYB+wH/AcYB+wH/AcYB+wH/AcYB+wH/AVIBfQGUnwABjAG+Ac4BnAHPAd4BrQHf
        Ae8BvQHvAfcBxgH3Af8BxgH3Af8BvQHvAfcBrQHbAecBlAHHAdYBewGqAb0zAAGTAf8B/W8AAaUBzwHe
        AYwBvgHOAXsBpgG9AWsBmgG1AWsBmgGtAXMBngG1AYQBqgG9AZwBvgHOPAABQgFNAT4HAAE+AwABKAMA
        AUADAAFAAwABAQEAAQEGAAECFgAD/wEAAv8B4AEBBAAC/wHAAQEEAAH8AQABwAEBBAABiAEAAcABAQQA
        AZgBAAHAAQEEAAG4AQABwAEBBAABwAEAAcABAQUAAQEBwAEBBQABAQHAAQEFAAEfAcABAQUAARsBwAEB
        BQABEwHAAQEFAAEjAcABAQQAAv8BwAEDBAAE/wQABP8EAAf/AfgC/wHAAYMC/wHAAQEB/AE/AcABgwL/
        AcABAQH8AT8BwAGDAeABHwHAAQMB/AE/AcABgwHxAZ8BwAEPAfwBPwHAAYMB+AHfAcABDwH4AR8BwAH/
        AfwBfwHAAQ8B+AEPAf8BAwH+AX8BwAEPAfABBwGBAQMB/AF/AcABDwHgAQcBgQEDAfgB3wHAAQ8B4AED
        AYEBAwHxAZ8BwAEPAcABAwGBAQMB4AEfAcABDwL/AYEBAwL/AcABDwL/AYED/wHAAQ8Q/wHAAQEBwAEB
        AcABAwHAAQ8BgAEBAYABAQGAAQMBgAEPAYABAQGAAQEBgAEDAYABDwGAAQEBgAEBAYABAwGAAQ8BgAEB
        AYABAQGAAQMBgAEPAYABAQGAAQEBgAEDAYABDwGAAQEBgAEBAYABAwGAAQcBgAEBAYABAQGAAQMBgAED
        AYABAQGAAQEBgAEDAYABAAGAAQEBgAEBAYABAwGAAQgBgAEBAYABAQGAAQMBgAENAYABAQGAAQEBgAED
        AYABDwGAAQEBgAEBAYABAwGAAQ8BgAEBAYABAQGAAQMBgAEfAYABAwGAAQMBgAEHDv8B8AEPAv8B8AEP
        AfgBDwHgAQcC/wHgAQcB8AEHAcABAwL/AcABAwHgAQMBwAEDAv8BgAEBAeABAQHAAQMC/wGAAQEBwAEB
        AcABAwGAAQEBgAEBAcABAQHAAQMBgAEBAYABAQHAAQEBwAEDAYABAQGAAQEBwAEBAcABAwGAAQEBgAEB
        AcABAQHAAQMBgAEBAYABAQHAAQEBwAEDAf8B/QHAAQMB4AEDAcABAwH/AegB4AEHAfABBwHAAQMB/wH9
        AfgBDwH4AQ8BwAEDBv8B4AEHAf8B/QT/AfABDwL/Cw==
</value>
  </data>
  <metadata name="timerConnecting.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
    <value>17, 17</value>
  </metadata>
  <metadata name="$this.TrayHeight" type="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
    <value>105</value>
  </metadata>
  <assembly alias="System.Drawing" name="System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
  <data name="$this.Icon" type="System.Drawing.Icon, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
    <value>
        AAABAAIAEBAAAAEAGABoAwAAJgAAACAgAAABACAAqBAAAI4DAAAoAAAAEAAAACAAAAABABgAAAAAAAAA
        AAAAAAAAAAAAAAAAAAAAAAAAzpyczpyczpyczpyczpyczpyczpyczpyczpyczpyczpyczpyczpyczpyc
        zpyczpyczpyc////////////////hLbGa5qtWoacQmmEQoKlY5q9////////////////zpyczpyczpyc
        zpyc////Uo6tWqK9e8PWlNvnUsfvEJLGIYKtMW2U////////zpyczpyczpyc////////WoacQr7nY9P3
        jOP3pev3Usv3AKrvAKLnCJbWOV17////////zpyczpyczpyc////WoacQsf3a9f3jOP3pev3Usv3AKrv
        AKLnAJ7eOV17////zpyczpyczpyc////////Y46lQsfva9f3jOP3pev3Usv3AKrvAKLnAJ7eQmmE////
        ////zpyczpyczpyc////Y46lQsf3a9f3jOP3pev3Usv3AKrvAKLnAJ7eQmmE////zpyczpyczpyc////
        ////a5qtQsf3a9f3jOP3pev3Usv3AKrvAKLnAJ7eSnWM////////zpyczpyczpyc////c561Qsf3a9f3
        jOP3pev3Usv3AKrvAKLnAJ7eUn2U////zpyczpyczpyc////////c6K9a9f3nOv3tfP/xvv/xvf/jOP3
        a9f3ObrnUn2U////////zpyczpyczpyc////c6K9xvv/xvv/xvv/xvv/xvv/xvv/xvv/xvv/Un2U////
        zpyczpyczpyc////////////jL7OnM/erd/vve/3xvf/rdvnlMfWe6q9////////////zpyczpyczpyc
        zpyczpyc////pc/ejL7Oe6a9a5qthKq9nL7O////zpyczpyczpyczpyczpyc////////////////////
        ////////////////////////////////////zpyck5ORk5ORwBQUxR4eySkozjMy0z082EdG3VFQ4lta
        52Vk7G9u8Hp49YSCk5ORk5ORk5ORk5ORwBQUxR4eySkozjMy0z082EdG3VFQ4lta52Vk7G9u8Hp49YSC
        k5ORk5ORAACcQQAAnEEAAJxBAACcQQAAnEEAAJxBAACcQQAAnEEAAJxBAACcQQAAnEEAAJxBAACcQQAA
        nEEAAJxBAACcQSgAAAAgAAAAQAAAAAEAIAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADOnJz/zpyc/86c
        nP/OnJz/zpyc/86cnP/OnJz/zpyc/86cnP/OnJz/zpyc/86cnP/OnJz/zpyc/86cnP/OnJz/zpyc/86c
        nP/OnJz/zpyc/86cnP/OnJz/zpyc/86cnP/OnJz/zpyc/86cnP/OnJz/zpyc/86cnP/OnJz/zpyc/86c
        nP/OnJz/zpyc/86cnP/OnJz/zpyc/86cnP/OnJz/zpyc/86cnP/OnJz/zpyc/86cnP/OnJz/zpyc/86c
        nP/OnJz/zpyc/86cnP/OnJz/zpyc/86cnP/OnJz/zpyc/86cnP/OnJz/zpyc/86cnP/OnJz/zpyc/86c
        nP/OnJz/zpyc/86cnP///////////////////////////////////////////4S2xv+Etsb/a5qt/2ua
        rf9ahpz/Woac/0JphP9CaYT/QoKl/0KCpf9jmr3/Y5q9////////////////////////////////////
        ////////zpyc/86cnP/OnJz/zpyc////////////////////////////////////////////hLbG/4S2
        xv9rmq3/a5qt/1qGnP9ahpz/QmmE/0JphP9CgqX/QoKl/2Oavf9jmr3/////////////////////////
        ///////////////////OnJz/zpyc/86cnP/OnJz/zpyc/86cnP/OnJz/zpyc////////////Uo6t/1KO
        rf9aor3/WqK9/3vD1v97w9b/lNvn/5Tb5/9Sx+//Usfv/xCSxv8Qksb/IYKt/yGCrf8xbZT/MW2U////
        ///////////////////OnJz/zpyc/86cnP/OnJz/zpyc/86cnP/OnJz/zpyc/86cnP/OnJz/////////
        //9Sjq3/Uo6t/1qivf9aor3/e8PW/3vD1v+U2+f/lNvn/1LH7/9Sx+//EJLG/xCSxv8hgq3/IYKt/zFt
        lP8xbZT//////////////////////86cnP/OnJz/zpyc/86cnP/OnJz/zpyc////////////////////
        //9ahpz/Woac/0K+5/9Cvuf/Y9P3/2PT9/+M4/f/jOP3/6Xr9/+l6/f/Usv3/1LL9/8Aqu//AKrv/wCi
        5/8Aouf/CJbW/wiW1v85XXv/OV17///////////////////////OnJz/zpyc/86cnP/OnJz/////////
        /////////////1qGnP9ahpz/Qr7n/0K+5/9j0/f/Y9P3/4zj9/+M4/f/pev3/6Xr9/9Sy/f/Usv3/wCq
        7/8Aqu//AKLn/wCi5/8Iltb/CJbW/zlde/85XXv//////////////////////86cnP/OnJz/zpyc/86c
        nP/OnJz/zpyc////////////Woac/1qGnP9Cx/f/Qsf3/2vX9/9r1/f/jOP3/4zj9/+l6/f/pev3/1LL
        9/9Sy/f/AKrv/wCq7/8Aouf/AKLn/wCe3v8Ant7/OV17/zlde////////////86cnP/OnJz/zpyc/86c
        nP/OnJz/zpyc/86cnP/OnJz///////////9ahpz/Woac/0LH9/9Cx/f/a9f3/2vX9/+M4/f/jOP3/6Xr
        9/+l6/f/Usv3/1LL9/8Aqu//AKrv/wCi5/8Aouf/AJ7e/wCe3v85XXv/OV17////////////zpyc/86c
        nP/OnJz/zpyc/86cnP/OnJz//////////////////////2OOpf9jjqX/Qsfv/0LH7/9r1/f/a9f3/4zj
        9/+M4/f/pev3/6Xr9/9Sy/f/Usv3/wCq7/8Aqu//AKLn/wCi5/8Ant7/AJ7e/0JphP9CaYT/////////
        /////////////86cnP/OnJz/zpyc/86cnP//////////////////////Y46l/2OOpf9Cx+//Qsfv/2vX
        9/9r1/f/jOP3/4zj9/+l6/f/pev3/1LL9/9Sy/f/AKrv/wCq7/8Aouf/AKLn/wCe3v8Ant7/QmmE/0Jp
        hP//////////////////////zpyc/86cnP/OnJz/zpyc/86cnP/OnJz///////////9jjqX/Y46l/0LH
        9/9Cx/f/a9f3/2vX9/+M4/f/jOP3/6Xr9/+l6/f/Usv3/1LL9/8Aqu//AKrv/wCi5/8Aouf/AJ7e/wCe
        3v9CaYT/QmmE////////////zpyc/86cnP/OnJz/zpyc/86cnP/OnJz/zpyc/86cnP///////////2OO
        pf9jjqX/Qsf3/0LH9/9r1/f/a9f3/4zj9/+M4/f/pev3/6Xr9/9Sy/f/Usv3/wCq7/8Aqu//AKLn/wCi
        5/8Ant7/AJ7e/0JphP9CaYT////////////OnJz/zpyc/86cnP/OnJz/zpyc/86cnP//////////////
        ////////a5qt/2uarf9Cx/f/Qsf3/2vX9/9r1/f/jOP3/4zj9/+l6/f/pev3/1LL9/9Sy/f/AKrv/wCq
        7/8Aouf/AKLn/wCe3v8Ant7/SnWM/0p1jP//////////////////////zpyc/86cnP/OnJz/zpyc////
        //////////////////9rmq3/a5qt/0LH9/9Cx/f/a9f3/2vX9/+M4/f/jOP3/6Xr9/+l6/f/Usv3/1LL
        9/8Aqu//AKrv/wCi5/8Aouf/AJ7e/wCe3v9KdYz/SnWM///////////////////////OnJz/zpyc/86c
        nP/OnJz/zpyc/86cnP///////////3Oetf9znrX/Qsf3/0LH9/9r1/f/a9f3/4zj9/+M4/f/pev3/6Xr
        9/9Sy/f/Usv3/wCq7/8Aqu//AKLn/wCi5/8Ant7/AJ7e/1J9lP9SfZT////////////OnJz/zpyc/86c
        nP/OnJz/zpyc/86cnP/OnJz/zpyc////////////c561/3Oetf9Cx/f/Qsf3/2vX9/9r1/f/jOP3/4zj
        9/+l6/f/pev3/1LL9/9Sy/f/AKrv/wCq7/8Aouf/AKLn/wCe3v8Ant7/Un2U/1J9lP///////////86c
        nP/OnJz/zpyc/86cnP/OnJz/zpyc//////////////////////9zor3/c6K9/2vX9/9r1/f/nOv3/5zr
        9/+18///tfP//8b7///G+///xvf//8b3//+M4/f/jOP3/2vX9/9r1/f/Obrn/zm65/9SfZT/Un2U////
        ///////////////////OnJz/zpyc/86cnP/OnJz//////////////////////3Oivf9zor3/a9f3/2vX
        9/+c6/f/nOv3/7Xz//+18///xvv//8b7///G9///xvf//4zj9/+M4/f/a9f3/2vX9/85uuf/Obrn/1J9
        lP9SfZT//////////////////////86cnP/OnJz/zpyc/86cnP/OnJz/zpyc////////////c6K9/3Oi
        vf/G+///xvv//8b7///G+///xvv//8b7///G+///xvv//8b7///G+///xvv//8b7///G+///xvv//8b7
        ///G+///Un2U/1J9lP///////////86cnP/OnJz/zpyc/86cnP/OnJz/zpyc/86cnP/OnJz/////////
        //9zor3/c6K9/8b7///G+///xvv//8b7///G+///xvv//8b7///G+///xvv//8b7///G+///xvv//8b7
        ///G+///xvv//8b7//9SfZT/Un2U////////////zpyc/86cnP/OnJz/zpyc/86cnP/OnJz/////////
        ////////////////////////jL7O/4y+zv+cz97/nM/e/63f7/+t3+//ve/3/73v9//G9///xvf//63b
        5/+t2+f/lMfW/5TH1v97qr3/e6q9/////////////////////////////////86cnP/OnJz/zpyc/86c
        nP////////////////////////////////+Mvs7/jL7O/5zP3v+cz97/rd/v/63f7/+97/f/ve/3/8b3
        ///G9///rdvn/63b5/+Ux9b/lMfW/3uqvf97qr3/////////////////////////////////zpyc/86c
        nP/OnJz/zpyc/86cnP/OnJz/zpyc/86cnP/OnJz/zpyc////////////pc/e/6XP3v+Mvs7/jL7O/3um
        vf97pr3/a5qt/2uarf+Eqr3/hKq9/5y+zv+cvs7////////////OnJz/zpyc/86cnP/OnJz/zpyc/86c
        nP/OnJz/zpyc/86cnP/OnJz/zpyc/86cnP/OnJz/zpyc/86cnP/OnJz///////////+lz97/pc/e/4y+
        zv+Mvs7/e6a9/3umvf9rmq3/a5qt/4Sqvf+Eqr3/nL7O/5y+zv///////////86cnP/OnJz/zpyc/86c
        nP/OnJz/zpyc/86cnP/OnJz/zpyc/86cnP//////////////////////////////////////////////
        ////////////////////////////////////////////////////////////////////////////////
        ////////////////////////zpyc/86cnP/OnJz/zpyc////////////////////////////////////
        ////////////////////////////////////////////////////////////////////////////////
        ///////////////////////////////////OnJz/zpyc/5OTkf+Tk5H/k5OR/5OTkf/AFBT/wBQU/8Ue
        Hv/FHh7/ySko/8kpKP/OMzL/zjMy/9M9PP/TPTz/2EdG/9hHRv/dUVD/3VFQ/+JbWv/iW1r/52Vk/+dl
        ZP/sb27/7G9u//B6eP/wenj/9YSC//WEgv+Tk5H/k5OR/5OTkf+Tk5H/k5OR/8b7//8Azv//k5OR/8AU
        FP/AFBT/xR4e/8UeHv/JKSj/ySko/84zMv/OMzL/0z08/9M9PP/YR0b/2EdG/91RUP/dUVD/4lta/+Jb
        Wv/nZWT/52Vk/+xvbv/sb27/8Hp4//B6eP/1hIL/9YSC/5OTkf8AAAD/k5OR/5OTkf+Tk5H/xvv//wDO
        //+Tk5H/wBQU/8AUFP/FHh7/xR4e/8kpKP/JKSj/zjMy/84zMv/TPTz/0z08/9hHRv/YR0b/3VFQ/91R
        UP/iW1r/4lta/+dlZP/nZWT/7G9u/+xvbv/wenj/8Hp4//WEgv/1hIL/k5OR/5OTkf8AAAD/k5OR/5OT
        kf+Tk5H/k5OR/5OTkf/AFBT/wBQU/8UeHv/FHh7/ySko/8kpKP/OMzL/zjMy/9M9PP/TPTz/2EdG/9hH
        Rv/dUVD/3VFQ/+JbWv/iW1r/52Vk/+dlZP/sb27/7G9u//B6eP/wenj/9YSC//WEgv+Tk5H/k5OR/5OT
        kf+Tk5H/AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
        AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
        AAAAAAAAAAAAAAAAAAA=
</value>
  </data>
</root>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
United Kingdom United Kingdom
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions