Skip to main content

Posts

Showing posts from 2014

.Net Serialize and Deserialize Objects to XML and database

Serialization Create an empty instance of your object Dim Obj as New MYOBJECT Dim cn As New SqlConnection(ConnectionString.Text_) Dim cmd As New SqlCommand Dim Trans As SqlTransaction   With cmd                 .Connection = cn                 .Transaction = Trans                 .CommandType = CommandType.StoredProcedure                 .CommandText = "somestoredprocedure"             Dim xMLSerialiser_ As New System.Xml.Serialization.XmlSerializer ( Obj.GetType )                 Dim sWriter As New System.IO.StringWriter                 xMLSerialiser_.Serialize(sWriter, Obj )                 'add xml to database                 .Parameters.AddWithValue("@persistxml", sWriter.ToString) End With cmd.ExecuteNonQuery() Trans.Commit()   DeSerialization Dim Obj as New MYOBJECT cn.Open()             With cmd                 .Connection = cn                 .CommandType = CommandType.Text