Generic methods for xml serialization

Serialization XML

 

       public static string Serialize<T>(T param) where T:class

        {

            try

            {

                XmlSerializer ser = new XmlSerializer(typeof(T));

                StringWriter sw = new StringWriter();

                XmlSerializerNamespaces ns = new XmlSerializerNamespaces();

                ns.Add("", "");

                ser.Serialize(sw, param, ns);

                return sw.ToString();

            }

            catch

            {

                return string.Empty;

            }

        }

 

Deserialization XML

 

        public static T Deserialize<T>(string xml) where T : class

        {

            MemoryStream stream = new MemoryStream(Encoding.UTF8.GetBytes(xml));

            try

            {

                XmlSerializer ser = new XmlSerializer(typeof(T));

                StreamReader sw = new StreamReader(stream);

                var dto = (T)ser.Deserialize(sw);

                return dto;

            }

            catch

            {

                return null;

            }

            finally

            {

                stream.Flush();

                stream.Dispose();

            }

        }

Create XML using C#

using (System.Xml.XmlWriter writer = System.Xml.XmlWriter.Create(Server.MapPath("~/employees.xml")))

            {

                writer.WriteStartDocument();

                writer.WriteStartElement("Employees");

                DataTable DT = new DataTable();

               

                for (int i = 0; i < DT.Rows.Count; i++)

                {

                   writer.WriteStartElement("Employee");

                   writer.WriteElementString("ID", DT.Rows[i]["ID"].ToString());

                   writer.WriteElementString("FirstName", DT.Rows[i]["Name"].ToString());

                   writer.WriteElementString("Surname", DT.Rows[i]["Surname"].ToString());

                   writer.WriteElementString("Mobile", DT.Rows[i]["Mobile"].ToString());

                    writer.WriteEndElement();

                }

                writer.WriteEndElement();

                writer.WriteEndDocument();

            }

Generate XML from Dataset

   protected void generateXML_Click(object sender, EventArgs e)

        {

            // Define Connection with connection string

            SqlConnection con = new SqlConnection("Add ConnectionString");

            // write query to retrieve data.

            SqlCommand cmd = new SqlCommand("select * from DetailMaster", con);

            SqlDataAdapter da = new SqlDataAdapter(cmd);

            DataSet ds = new DataSet();   // Take Dataset

            da.Fill(ds);

            ds.WriteXml("D:/textXML.xml");  // Path to create XML

        }