ADO Net C# Tutorial

  1. Home
  2. C# Tutorial
  3. ADO Net
  4. Transform Data
using System;
using System.Data;
using System.Data.SqlClient;
using System.Xml;
using System.Xml.Xsl;
public class MainClass{
  public static void Main(string [] args) {
    DataSet dataSet = new DataSet("Product");
    
    SqlConnection connection = new SqlConnection("Initial Catalog=Product; Integrated Security=SSPI; User ID=sa");
    
    SqlDataAdapter customersAdapter = new SqlDataAdapter("SELECT * FROM customers", connection);
    SqlDataAdapter couponsAdapter = new SqlDataAdapter("SELECT * FROM coupons", connection);
    SqlDataAdapter couponRedemptionsAdapter = new SqlDataAdapter("SELECT * FROM coupon_redemptions", connection);
    
    customersAdapter.Fill(dataSet, "customers");
    couponsAdapter.Fill(dataSet, "coupons");
    couponRedemptionsAdapter.Fill(dataSet, "coupon_redemptions");
    XmlDataDocument doc = new XmlDataDocument(dataSet);
    
    XmlTextWriter writer = new XmlTextWriter(Console.Out);
    writer.Formatting = Formatting.Indented;
    
    XslTransform transform = new XslTransform();
    transform.Load("Coupons.xsl");
    transform.Transform(doc, null, writer);
  }
}