Write data in database table to XML file : Database to XML « Database ADO.net « C# / C Sharp

1. C# / C Sharp
2. Database ADO.net
3. Database to XML

Write data in database table to XML file

using System;
using System.Data;
using System.Data.SqlClient;

   class WriteXML {
      static void Main(){
         string connString = "server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI";
         string qry = @"select * from employee";
         SqlConnection conn = new SqlConnection(connString);

         try{
            SqlDataAdapter da = new SqlDataAdapter();
            da.SelectCommand = new SqlCommand(qry, conn);
            conn.Open();

            DataSet ds = new DataSet();   
            da.Fill(ds, "employee");

            ds.WriteXml(@"employee.xml");
         } catch(Exception e) {
            Console.WriteLine("Error: " + e);
         } finally {
            conn.Close();
         }
      }
   }


           
       

Related examples in the same category