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