defaultcs.aspx.cs

Telerik是很大的第三方软件制造商

using System;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Web.UI.WebControls;
using Telerik.QuickStart;
using Telerik.WebControls;

namespace Telerik.GridExamplesCSharp.Programming.Appearance
{
	public class DefaultCS : XhtmlPage
	{
		protected System.Web.UI.WebControls.DropDownList DropDownList1;
		protected System.Web.UI.WebControls.Button btnApply;
		protected System.Web.UI.WebControls.DropDownList DropDownList4;
		protected System.Web.UI.WebControls.Button Button1;
		protected RadGrid RadGrid1;

		protected ColorPicker ColorPicker1;
		protected ColorPicker ColorPicker2;

		private void Page_Load(object sender, EventArgs e)
		{
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		///		Required method for Designer support - do not modify
		///		the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{
			this.btnApply.Click += new System.EventHandler(this.btnApply_Click);
			this.RadGrid1.NeedDataSource += new Telerik.WebControls.GridNeedDataSourceEventHandler(this.RadGrid1_NeedDataSource);
			this.RadGrid1.DetailTableDataBind += new Telerik.WebControls.GridDetailTableDataBindEventHandler(this.RadGrid1_DetailTableDataBind);
			this.Button1.Click += new System.EventHandler(this.Button1_Click);
			this.RadGrid1.PreRender += new EventHandler(RadGrid1_PreRender);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void RadGrid1_NeedDataSource(object source, GridNeedDataSourceEventArgs e)
		{
			OleDbConnection MyOleDbConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("~/Grid/Data/Access/Nwind.mdb"));
			OleDbDataAdapter MyOleDbDataAdapter = new OleDbDataAdapter();
			MyOleDbDataAdapter.SelectCommand = new OleDbCommand("SELECT CustomerID, CompanyName, ContactName, ContactTitle, Address, PostalCode FROM Customers", MyOleDbConnection);

			DataTable customersTable = new DataTable("Customers");

			MyOleDbConnection.Open();
			try
			{
				MyOleDbDataAdapter.Fill(customersTable);
			}
			finally
			{
				MyOleDbConnection.Close();
			}
			
			RadGrid1.DataSource = customersTable;
		}

		private void RadGrid1_DetailTableDataBind(object source, Telerik.WebControls.GridDetailTableDataBindEventArgs e)
		{
			GridDataItem parentItem = e.DetailTableView.ParentItem as GridDataItem;
			if ( parentItem.Edit )
			{
				return;
			}

			if ( e.DetailTableView.DataMember == "OrderDetails" )
			{
				OleDbConnection MyOleDbConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("~/Grid/Data/Access/Nwind.mdb"));
				OleDbDataAdapter MyOleDbDataAdapter = new OleDbDataAdapter();

				DataTable orderDetailsTable = new DataTable("Customers");
				MyOleDbConnection.Open();
				try
				{
					MyOleDbDataAdapter.SelectCommand = new OleDbCommand(@"SELECT CustomerID, OD.* from Orders, 
						[Order Details] OD Where Orders.OrderID = OD.OrderID and CustomerID = '" + 
						parentItem["CustomerID"].Text + "'", MyOleDbConnection);
					MyOleDbDataAdapter.Fill(orderDetailsTable);
				}
				finally
				{
					MyOleDbConnection.Close();
				}

				orderDetailsTable.Columns.Add("Price", typeof(double), "(UnitPrice * Quantity) - Discount");

				e.DetailTableView.DataSource = orderDetailsTable;
			}
		}

		private void RadGrid1_PreRender(object sender, System.EventArgs e)
		{
			RadGrid1.MasterTableView.GetColumn( "CustomerID" ).Visible = false;			
		}

		private void btnApply_Click(object sender, System.EventArgs e)
		{
			GridTableView targetTableView = null;
			switch( DropDownList1.SelectedItem.Value )
			{
				case "Customers":
					targetTableView = RadGrid1.MasterTableView;
					break;
				case "OrderDetails":
					targetTableView = RadGrid1.MasterTableView.DetailTables[0];
					break;
			}

			if ( targetTableView == null )
			{
				return;
			}

			TableItemStyle targetStyle = null;

			switch( DropDownList4.SelectedItem.Value )
			{
				case "ItemStyle":
					targetStyle = targetTableView.ItemStyle;
					break;
				case "HeaderStyle":
					targetStyle = targetTableView.HeaderStyle;
					break;
				case "AlternatingItemStyle":
					targetStyle = targetTableView.AlternatingItemStyle;
					break;
				case "GroupHeaderItemStyle":
					targetStyle = targetTableView.GroupHeaderItemStyle;
					break;
			}

			if ( targetStyle == null )
			{
				return;
			}

			targetStyle.ForeColor = ColorPicker1.SelectedColor;
			targetStyle.BackColor = ColorPicker2.SelectedColor;
		}

		private void Button1_Click(object sender, System.EventArgs e)
		{
			//try PostBack
		}
	}
}