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