SQLDataAdapter + Generate XML 檔案

 

   SQLDataAdapter + Generate XML 檔案
 
   private void Write_XML_Data()
   {
 
      SqlConnectionStringBuilder connectionString1 = new SqlConnectionStringBuilder();
      connectionString1.DataSource = "VECTUS\\SQLEXPRESS";
      connectionString1.InitialCatalog = "Soccer";
      connectionString1.UserID = "sa";
      connectionString1.Password = "tammylau";
 
      SqlConnection con1 = new SqlConnection();
      con1.ConnectionString = connectionString1.ConnectionString;
      con1.Open();
 
      String SqlString1 = "SELECT * FROM dbo.Player";
 
      SqlDataAdapter Adapter = new SqlDataAdapter(SqlString1.ToString(), con1);
      DataSet ds = new DataSet();
 
      Adapter.Fill(ds);
      ds.WriteXml("C:\\Player.xml");
 
      ds.Dispose();
      con1.Dispose();
 
   }