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