TableAdapterTransaction.cs

using (TransactionScope tc = new TransactionScope())
  using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DACL.Properties.Settings.CatalogueConnectionString"].ConnectionString))
  {
    conn.Open();
    attributesTA.Connection = assetTA.Connection = attributeValueTA.Connection = tag2AssetTA.Connection = conn;
    assetTA.Update(mainDataSet1.Asset);
    attributesTA.Update(mainDataSet1.Attributes);
    attributeValueTA.Update(mainDataSet1.AttributeValue);
    tag2AssetTA.Update(mainDataSet1.Tag2Asset);
    tc.Complete();
  }