defaultcs.aspx.cs

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

using Telerik.QuickStart;
using Telerik.QuickStart.Grid;
using Telerik.WebControls;

namespace Telerik.GridExamplesCSharp.GeneralFeatures.Sorting
{
	using System;
	using System.Data;
	using System.Data.OleDb;

	public abstract class DefaultCS : XhtmlPage
	{
		protected System.Web.UI.WebControls.DropDownList DropDownList1;
		protected System.Web.UI.WebControls.DropDownList Dropdownlist2;
		protected System.Web.UI.WebControls.CheckBox CheckBox1;
		protected System.Web.UI.WebControls.Label SortLabel;
		protected System.Web.UI.WebControls.CheckBox CheckBox2;
		protected Telerik.WebControls.RadGrid RadGrid1;

		#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);
		}
		
		///		Required method for Designer support - do not modify
		///		the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{
			this.DropDownList1.SelectedIndexChanged += new System.EventHandler(this.DropDownList1_SelectedIndexChanged);
			this.Dropdownlist2.SelectedIndexChanged += new System.EventHandler(this.Dropdownlist2_SelectedIndexChanged);
			this.RadGrid1.ColumnCreated += new Telerik.WebControls.GridColumnCreatedEventHandler(this.RadGrid1_ColumnCreated);
			this.RadGrid1.NeedDataSource += new Telerik.WebControls.GridNeedDataSourceEventHandler(this.RadGrid1_NeedDataSource);
			this.RadGrid1.SortCommand += new Telerik.WebControls.GridSortCommandEventHandler(this.RadGrid1_SortCommand);
			this.CheckBox2.CheckedChanged +=new EventHandler(CheckBox2_CheckedChanged);
		}
		#endregion

		private void RadGrid1_NeedDataSource(object source, Telerik.WebControls.GridNeedDataSourceEventArgs e)
		{
			string select = "SELECT TOP 10 CustomerID, CompanyName, ContactName, ContactTitle, Address, PostalCode FROM Customers";

			if ( !this.RadGrid1.MasterTableView.AllowCustomSorting )
			{
				RadGrid1.DataSource = DataSourceHelperCS.GetDataTable(select);
			}
			else
			{
				string sortString = RadGrid1.MasterTableView.SortExpressions.GetSortString();
				if ( sortString != null )
				{
					this.SortLabel.Text = "Grid sort string: " + sortString;
					string sortClause = " Order By " + sortString;
					RadGrid1.DataSource = DataSourceHelperCS.GetDataTable(select + sortClause);
				}
				else
				{
					this.SortLabel.Text = "Grid sort string: [empty]";
					RadGrid1.DataSource = DataSourceHelperCS.GetDataTable(select);
				}
			}
		}

		private void DropDownList1_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			this.RadGrid1.MasterTableView.AllowMultiColumnSorting = bool.Parse( this.DropDownList1.SelectedItem.Value );
		}

		private void Dropdownlist2_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			this.RadGrid1.MasterTableView.SortExpressions.AllowNaturalSort = bool.Parse( this.Dropdownlist2.SelectedItem.Value );
		}

		private void RadGrid1_SortCommand(object source, Telerik.WebControls.GridSortCommandEventArgs e)
		{
			//Default sort order Descending
			if ( !this.CheckBox1.Checked  )
			{
				return;
			}

			if ( !e.Item.OwnerTableView.SortExpressions.ContainsExpression(e.SortExpression) )
			{
				GridSortExpression sortExpr = new GridSortExpression();
				sortExpr.FieldName = e.SortExpression;
				sortExpr.SortOrder = GridSortOrder.Ascending;

				e.Item.OwnerTableView.SortExpressions.AddSortExpression( sortExpr );
			}
		}

		private void RadGrid1_ColumnCreated(object sender, Telerik.WebControls.GridColumnCreatedEventArgs e)
		{
			if (e.Column is GridBoundColumn && (e.Column as GridBoundColumn).DataField == "CustomerID")
			{
				(e.Column as GridBoundColumn).HeaderText = "Customized";
			}
		}

		private void CheckBox2_CheckedChanged(object sender, EventArgs e)
		{
			this.SortLabel.Text = "";
			RadGrid1.MasterTableView.AllowCustomSorting = CheckBox2.Checked;
			RadGrid1.DataSource = null;
			RadGrid1.Rebind();
		}
	}
}