See this example:
SqlCommand cmd = new SqlCommand("select zip_code,state_abbrev,city from zip_codes", your connection);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
ds.WriteXml("C:\\your_file.xml");
your connection.Close();
Regards..