Csharp/C Sharp/Database ADO.net/Database to XML

Use the ExecuteXmlReader() method to run a SELECT statement that returns XML

<source lang="csharp"> using System; using System.Data; using System.Data.SqlClient; using System.Xml; class ExecuteXmlReader {

 public static void Main()
 {
   SqlConnection mySqlConnection =new SqlConnection("server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI;");
   SqlCommand mySqlCommand = mySqlConnection.CreateCommand();
   mySqlCommand.rumandText = "SELECT TOP 5 ID, FirstName, LastName " +
     "FROM Employee " +
     "ORDER BY ID " +
     "FOR XML AUTO";
   mySqlConnection.Open();
   XmlReader myXmlReader = mySqlCommand.ExecuteXmlReader();
   myXmlReader.Read();
   while (!myXmlReader.EOF) {
     Console.WriteLine(myXmlReader.ReadOuterXml());
   }
   myXmlReader.Close();
   mySqlConnection.Close();
 }

}

      </source>

Write data in database table to XML file

<source lang="csharp"> 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();
        }
     }
  }

      </source>