Click here to Skip to main content
15,893,588 members
Articles / Programming Languages / XML

Create Data Classes

Rate me:
Please Sign up or sign in to vote.
4.88/5 (31 votes)
4 Mar 2011CPOL10 min read 135.8K   2.5K   167  
An application that creates a C# class to read/write data to/from an Access, SQLite, or XML database.
<?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=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
  </resheader>
  <resheader name="writer">
    <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
  </resheader>
  <assembly alias="System.Drawing" name="System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
  <data name="btnEditSQLiteConversions.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
    <value>
        iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8
        YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAAAAlwSFlzAAALCQAA
        CwkBEvpHPgAAAh1JREFUOE+lkd9LU2EYx+t/6O/YnRJeCHURtCAp1oUXddF+SAoShQleaBA5QevC0hTT
        0qOnKJ3iji6NoSucrjQmkXOt7ah1LKbb8rhac6tvz/uenY0hGOQLD+/7Xnw/3+/zPEcBHDnUEcYXMCS9
        gTjxlt+DTh+E8Xn0j3nxyPEavcMe9DybQfdTNx6IL9ExOIX7wgvcG3CRN5kzwL9OJvsHqXQGanIPse8p
        fInuotRo0QBDki+vtwo26DUizebflgEb1B972Cbx5lYSHzfiBcBBCbLZ30j9ypI4nRfLyk4x4PHoHE9g
        vSnxarnbCWHsFex0N1OpSRInNGdZUbEqJ7AciqL0tFlr4eFzz74RaM5azzx2lIl3EJDj8Ae34F3eRIkx
        B+h64uYA5hyIxLnzSjiG5juduN3WUeTsD27D9/4bpufXCgC2Fv1w5zT1zJ1/QsnH1pwXSOxZVDDiDtEQ
        cwly+4S1SYKF6gO5mxudOWcWm3omMXP2LCmY8q6j37lSSMAAGe5MPdOqYmxgvGcVgU9hvAvImF2KYHIu
        guGZCMTpEISJVZToQ2QAbWDFqzJVNaHicgOMF2/gVOV1nLxQi/LzNSg7W4XjZ6wFAJEMLV0OhD8nsP6V
        XOUYKmtuobXHxXsVXUECXEN9qwPtoh/2vkUdYOBrJMAxBrnS0A5zXRsuXbUzusFk0xPU8f8JEyU4V80T
        sD8Tc4D++N/70IC/LhDwVy0ytuIAAAAASUVORK5CYII=
</value>
  </data>
  <data name="btnEditADOConversions.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
    <value>
        iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8
        YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAAAAlwSFlzAAALCQAA
        CwkBEvpHPgAAAh1JREFUOE+lkd9LU2EYx+t/6O/YnRJeCHURtCAp1oUXddF+SAoShQleaBA5QevC0hTT
        0qOnKJ3iji6NoSucrjQmkXOt7ah1LKbb8rhac6tvz/uenY0hGOQLD+/7Xnw/3+/zPEcBHDnUEcYXMCS9
        gTjxlt+DTh+E8Xn0j3nxyPEavcMe9DybQfdTNx6IL9ExOIX7wgvcG3CRN5kzwL9OJvsHqXQGanIPse8p
        fInuotRo0QBDki+vtwo26DUizebflgEb1B972Cbx5lYSHzfiBcBBCbLZ30j9ypI4nRfLyk4x4PHoHE9g
        vSnxarnbCWHsFex0N1OpSRInNGdZUbEqJ7AciqL0tFlr4eFzz74RaM5azzx2lIl3EJDj8Ae34F3eRIkx
        B+h64uYA5hyIxLnzSjiG5juduN3WUeTsD27D9/4bpufXCgC2Fv1w5zT1zJ1/QsnH1pwXSOxZVDDiDtEQ
        cwly+4S1SYKF6gO5mxudOWcWm3omMXP2LCmY8q6j37lSSMAAGe5MPdOqYmxgvGcVgU9hvAvImF2KYHIu
        guGZCMTpEISJVZToQ2QAbWDFqzJVNaHicgOMF2/gVOV1nLxQi/LzNSg7W4XjZ6wFAJEMLV0OhD8nsP6V
        XOUYKmtuobXHxXsVXUECXEN9qwPtoh/2vkUdYOBrJMAxBrnS0A5zXRsuXbUzusFk0xPU8f8JEyU4V80T
        sD8Tc4D++N/70IC/LhDwVy0ytuIAAAAASUVORK5CYII=
</value>
  </data>
  <metadata name="toolStrip1.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">
    <value>127, 17</value>
  </metadata>
  <data name="tsbtnNew.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
    <value>
        iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8
        YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAAAZ9JREFUOE+NkktL
        AlEUx4eglbRqG/QBWrWoTdS+x6Z1y/oSQdAHyE2FQk/CCnqAkAahkL0hk4iwYkxLRE1MzUea47z+3VHn
        OjE5euFwLnfu/3fu+Z9hmPpKp6c4QZhkscYAfgaCMB6Oxyd49bthlliTg58lQliAY5JfavvqWXH4oCVE
        ZE33VLBFREdMTUwgucAQ7J4n7LsesOP0YtvpXdABeTO5bCGxqIiUtVd7ySqJPfUMWD88x+DYjB4SfmGE
        18tuGUu1/vHeCZyRzPUD0Z46lNTYccF981SF2By3ZvoSUZzw0RaUiqQ69QTzFLBsO6mK1WgAiiMXVLBB
        AKGOholYoQBBlKBAVNAfL+R035wU7LLCTgCxXiAzSyawRsWyLKNU5pHMlKqAgdFp/DudTfsVFWk3FV7E
        V76MSCJvDFjd9+gAoiSjUKrgI1XEa+TLGGDddesAZU5AKvuDcDwHfzBlDFD60y7FuNw3h2iyADacge85
        0T5Aa1womsVj4BPXD7H2AVrjnt/S8Po/cHoXaQ+gzrtZbjpGdcbKhVah/Ae/K1Q3Rcsf2rwAAAAASUVO
        RK5CYII=
</value>
  </data>
  <data name="tsbtnSave.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
    <value>
        iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8
        YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAAAi1JREFUOE+tk91L
        k3EUx/0XvO8m8KLbmhrDtVgNnnIOZdkwrIhSn/A1TZf5QoqladTyBbIVLp20Wk3CSUW+gCliIoulaGXm
        iqY4fEUngsG33/lFzy/TuskfnMvP5zznnO8TFrYT78XzEKg87Stocy/jkXMBLc1B3LPNoKH+G6y3/Lhe
        NYnyso8oLhpDQf4ILuT4oPQmsKcbqK9bx7/e2voGDEk9OJH0jJcicD9d4oKa6sW/8gQHF9Zw0PQSKpUM
        83GXEDgfznNBedn0toJf8OfAEiKNHhRdnsIxU6sQ2JtmueCS5dMWwe/wu4kg9khu5OWOIyHeLgSNdwJc
        kJ01sknwJzzgC2CXzglZHobRaBOCutqvXCCnDSuC7eDuoS8Ij2nGyVOvERvbIAQ3aqbQ1Ql2SuDMuTcw
        n+7n26aF0cz02dT5J9yLRPMrSJJVCK5WTKDDA5YBoNXxnd19FVWVc3yptDCaOTPDp8BxCe3Q66uFoKR4
        HK7HwAP7BgtOCIbk3E1lOmtBcnop7xwXz+CjLuh0FUJgKRhlMFB7O8Q7k4CFBJEaCd4PsxidnIOcfw2H
        DW0c1hxyQKstFQKKpe0ulM8mAcHnC2/ivX8e/pllXLxiRZTOweAWRB24D01MoRBkZrxlc6/wmSP0Luze
        J+FJRx88nQPo6h1C/6AXR4xmqLRNiGbwXnUj1Oo8IchK9yampvTxeFLCKCR0ZzoVbZsWRjNTVyqC90dn
        C8H//NE/AEJWOr7cK6XnAAAAAElFTkSuQmCC
</value>
  </data>
  <data name="tsbtnFillListView.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
    <value>
        iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8
        YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAAAGpJREFUOE9jYKAW
        yOve+58UTC17EeYQsj2nc/d/6tuKbCIuF4BszmrbgRI+tHEJugtgNqc3b/mf0rDhf1LtWhq7At0FyDYn
        VK/+D8K08TvMVGQXwPwMsxlGI6uhvmuQTUe3Gd0F1LedEhMBonTKOx1LrIcAAAAASUVORK5CYII=
</value>
  </data>
  <data name="tsbtnDelete.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
    <value>
        iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8
        YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAAAfxJREFUOE9jZgAC
        Ly8vA0VVlSVqKqpPoqOjHx48ePA/SJwoEBoayuzk5Jru6Ojy38nZ+Zu3t3cgSAybZnt7e5agoCAld3fX
        PLg8SNDR0TnJ1t5hm7ml7X8tLa0/7u6eVeiGyMvbc1jaOjp5e3l9t7d3nINiga2tu6S9vYuFg4PLNisb
        +/929g7//X08N7q6unKDFFpYWHC6u7uvkJd3+m1qat4NtIQHq/eAtrI5ObkUyDs4/7azc/oP9M4yc3Mb
        PUtLu8m2Njb/9QxMJispGfMTChtGOzsXTVtbp/Nm5tb/9fX1vxsaG71X09JdJyNjwUlIM1xeX9/YQU/f
        5KelFTBc9I3uychoCRGv2dxcQUVF65KunuE/fQOT/yamFv+1tHVuEWWAoaGhvJq69lU1da0/Gpqaa4SF
        JUxkZVW2GRga/1dR087EawgwdCVk5ZVPySmq/tfWMzgkIyMjJC4uzg3Ccopq0w0MjL8oa2vLYjVE3t6e
        Q0ZRdZGEtPRHLS3DJ1paBlpwhfLyHAwMQnza+gZnJaTkJwHFMROatJyct5iEwn9VNW2gUzVaGRjEwWkA
        CTApK2upKCsr3xcQEJAHijMhS7IJC4u2CgmL/5eXV97Fxsarhq4AqpjZ1NRyMicfpymGvKScshErK/tE
        oIQdEPPiCSwWoBwXUTFCF0UApjJ49evmep0AAAAASUVORK5CYII=
</value>
  </data>
  <data name="tsbtnClose.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
    <value>
        iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8
        YQUAAAAgY0hSTQAAeiYAAICEAAD6AAAAgOgAAHUwAADqYAAAOpgAABdwnLpRPAAAAsBJREFUOE+VU1tI
        k2EYfhUyPEzdPGBZKZpGeJiCIygsSIwomiZdTC/qQoIMbwQr9Sr0ShBaSyEPHS0pOpgjpdg8W2pzTud0
        +91Bt3RTGSrUVRc9fd+/JC/tg4f/+b/3eR7e//3+L4jYAlHwclJSCOd7Xclu968got+i2a9Wa51VVbBX
        VopY3AWBcdtfWNlzgUGorsZaU5OWe8lDFGosLYW5tfW/8LW8HNxLFqKIkcJCGBobMaDRYFinw3BTk/i+
        G3yP17hG1KpU4F6yEkn0+fkYra2FZ3ER29vbEObmMFhfL+5xDDBuM5uxtbUlavje55IScC9NEUX1KRTQ
        V1RgvKEB/tVVrK+vwzo7i4E6Zq6rwbzJBJ/Ph42VFVHDtR+VSnAvjRJJe+Ry9JaViRituQPvkgsejwfW
        GRPmp41wuVz4brdjjNV2dNoiJbiXdEQxr1JS8KagANpLF6C7chGG2zfhFqywM5MgCHBa52G6ewv9KiW6
        zxWgMycHD6Iiwb00SBTbHh6Ge8GEJ9IQdKdKoD2bAcPIEGw2GywWCyYG9PigSMTbBMIjCUHNtGpJOLhX
        DGiLikBzCOFlDOF93iFMDfXD6XTCZTZCME7AxGYwrvuEnhNH0MU0LUyrlkp2BcRGojWU8Do3CQvfJuD1
        erEqzMFfkQX/jUzYTZNwOBywGibxLi8FbWEsIC5qV0BCNNrDCU6jQTwq/7IDvuvZ+FFM+HmZGM/CmsOG
        zc1NuGem0cG09w9E/wtoTZSKHYxcLcLWkh0LKjmcpwkb5wNwnSFYVdlibfRasdiB5rA0EMAn2XHsoPhd
        fAa9SYSxDMKsgiCcCsDM+JdMQl8yoSuWzWA/oTk1PnAK7GfY9+ykXN+SFoeHaTJ0HJfhaaYMnXIZXuQG
        8Jzxx1kytLFaS7oMmvR4aI4m6LlXvL2c8DTe0l7AtTvmP2/DIoiYQJsRAAAAAElFTkSuQmCC
</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
Retired
United Kingdom United Kingdom
I have been a keen hobbyist programmer since getting my first computer - a Vic 20 (you had to be able to write programs then since few programs were available and all were expensive).
Retired and now living in Pewsey, Wiltshire, where I spend (far too much of) my time writing computer programs to keep my mind active.

Comments and Discussions