Re: Serialize an object to insert into a Access table

SGWellens — Tue, 30 Jun 2009 23:10:21 GMT

You could try serializing it to an XML string using these functions:

    /// ---- SerializeAnObject -----------------------------
    /// <summary>
    /// Serialize an object
    /// </summary>
    /// <param name="AnObject">The Object to serialize</param>
    /// <returns>XML</returns>
    
    public static string SerializeAnObject(object AnObject)
    {
        XmlDocument XmlDoc = new XmlDocument();
        XmlSerializer Xml_Serializer = new XmlSerializer(AnObject.GetType()); 
        MemoryStream MemStream = new MemoryStream();
        try
        { 
            Xml_Serializer.Serialize(MemStream, AnObject); 
            MemStream.Position = 0; 
            XmlDoc.Load(MemStream); 
            return XmlDoc.InnerXml; 
        }      
        finally 
        { 
            MemStream.Close(); 
        }
    }

    /// ---- DeSerializeAnObject ------------------------------
    /// <summary>
    /// DeSerialize an object
    /// </summary>
    /// <param name="XmlOfAnObject"> The XML</param>
    /// <param name="ObjectType">The type of object</param>
    /// <returns>The deserialized object...must be cast to correct type</returns>
    
    public static Object DeSerializeAnObject(string XmlOfAnObject, Type ObjectType)
    {       
        StringReader StrReader = new StringReader(XmlOfAnObject);
        XmlSerializer Xml_Serializer = new XmlSerializer(ObjectType);
        XmlTextReader XmlReader = new XmlTextReader(StrReader);
        try
        {
            Object AnObject = Xml_Serializer.Deserialize(XmlReader);
            return AnObject;
        }
        finally
        {
            XmlReader.Close();
            StrReader.Close();
        }
    }

Serialize an object to insert into a Access table

FCP_88 — Tue, 30 Jun 2009 19:21:51 GMT

Hi.

I have an application connected to an access database. I am using a Table Adapter to insert/get data from the table.

I have an object that represents a specific table from the db with more that 50 fields that i need to insert in the database.

How can i serialize that object into something like this (attrib1,atrib2 ...) so i can use the insert method of table adapter?

I can get all the attributes of the object one by one but that would be very time consuming.

Access Databases and AccessDataSource Control

Re: Serialize an object to insert into a Access table

Serialize an object to insert into a Access table