Mega Code Archive

 

Categories / C# / ADO Database

 

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();          }       }    }