using System;
using System.Collections;
using System.ComponentModel;
using System.Configuration;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

using ColaReport;

namespace ColaReportDemo
{
	/// <summary>
	/// Demonstrates:
	/// Using RowAlternateAttributes
	/// Boxing in the header
	/// </summary>
	public class demo2 : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label lblReport;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			CellColumn oCol;
			Report oReport;
			DataSet dsRpt;
			string sQuery;

			OleDbConnection oConn;
			OleDbDataAdapter daRpt;

			// Get connection string
			oConn = new OleDbConnection (ConfigurationSettings.AppSettings["gsConn"]);
			
			sQuery = "SELECT CustomerName, Phone1, Fax" +
				" FROM Customer";

			daRpt = new OleDbDataAdapter (sQuery, oConn);  
			dsRpt = new DataSet();
			daRpt.Fill(dsRpt);

			// Define Report 
			oReport = new Report ();
			oReport.LinesPerPage = 33;
			oReport.Style.Add ("font-family", "Verdana");
			oReport.Attributes["border"] = "0";

			oReport.FirstPageHeader.Text = "<h2>Demo: demo2.aspx</h2>";
			oReport.FirstPageHeader.Style.Add ("font-family", "Verdana");
			oReport.PageHeader.Text = "<h3>Demo: demo2.aspx</h3>";
			oReport.PageHeader.Style.Add ("font-family", "Verdana");

			oReport.HeaderRowAttributes.Attributes["bgcolor"] = "#efefdf";
			oReport.RowAttributes.Attributes["bgcolor"] = "#efefef";
			oReport.RowAlternateAttributes.Attributes["bgcolor"] = "#ffffff";
	
			oCol = oReport.CreateCellColumn ("CustomerName", "Name"); 
			oCol.HeaderCell.Text = CellColumn.csBoxAndBoldStart 
				+ oCol.HeaderCell.Text + CellColumn.csBoxAndBoldEnd;

			oCol = oReport.CreateCellColumn ("Phone1", "Phone"); 
			oCol.HeaderCell.Text = CellColumn.csBoxAndBoldStart 
				+ oCol.HeaderCell.Text + CellColumn.csBoxAndBoldEnd;

			oCol = oReport.CreateCellColumn ("Fax", "Fax"); 
			oCol.HeaderCell.Text = CellColumn.csBoxAndBoldStart 
				+ oCol.HeaderCell.Text + CellColumn.csBoxAndBoldEnd;
			
			//Bind dataset
			oReport.Bind (dsRpt);

			//Set label text to report output
			lblReport.Text = oReport.Execute();
		}
	}
}