defaultcs.aspx.cs

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

using System;
using System.Data;
using System.Data.OleDb;
using Telerik.QuickStart;
using Telerik.WebControls;

namespace Telerik.GridExamplesCSharp.Programming.Sort
{

	public class DefaultCS : XhtmlPage
	{
		protected Telerik.WebControls.RadGrid RadGrid1;
		protected System.Web.UI.WebControls.DropDownList DropDownList1;
		protected System.Web.UI.WebControls.TextBox TextBox1;
		protected System.Web.UI.WebControls.DropDownList DropDownList2;
		protected System.Web.UI.WebControls.Button btnAddExpression;
		protected System.Web.UI.WebControls.Button Clear;
		protected System.Web.UI.WebControls.DropDownList DropDownList3;
		protected System.Web.UI.WebControls.Button btnPostBack;

		#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.btnAddExpression.Click += new System.EventHandler(this.btnAddExpression_Click);
			this.DropDownList1.SelectedIndexChanged += new System.EventHandler(this.DropDownList1_SelectedIndexChanged);
			this.RadGrid1.NeedDataSource += new Telerik.WebControls.GridNeedDataSourceEventHandler(this.RadGrid1_NeedDataSource);
			this.Clear.Click += new System.EventHandler(this.Clear_Click);
		}
		#endregion

		private void RadGrid1_NeedDataSource(object source, Telerik.WebControls.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, Country, City, CompanyName, ContactName, ContactTitle, PostalCode FROM Customers", MyOleDbConnection);

			DataSet MyDataSet = new DataSet();

			MyOleDbConnection.Open();
			MyOleDbDataAdapter.Fill(MyDataSet);
			MyOleDbConnection.Close();

			RadGrid1.DataSource = MyDataSet.Tables[0];
		}

		private void btnAddExpression_Click(object sender, System.EventArgs e)
		{
			GridSortExpression expression = new GridSortExpression();
			expression.FieldName = DropDownList3.SelectedItem.Value;
			expression.SetSortOrder( DropDownList2.SelectedItem.Value );
			this.RadGrid1.MasterTableView.SortExpressions.AddSortExpression( expression );
			this.RadGrid1.MasterTableView.Rebind();
		}

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

		private void Clear_Click(object sender, System.EventArgs e)
		{
			this.RadGrid1.MasterTableView.SortExpressions.Clear();
			this.RadGrid1.MasterTableView.Rebind();
		}
	}
}