defaultcs.aspx.cs

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

using System.Web.UI;
using Telerik.QuickStart;
using Telerik.WebControls;

namespace Telerik.GridExamplesCSharp.Programming.ViewState
{
	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.Button Button1;
		protected System.Web.UI.WebControls.Label Label1;
		protected RadGrid RadGrid1;

		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 Top 600, * FROM Invoices", MyOleDbConnection);

			DataTable myDataTable = new DataTable();

			MyOleDbConnection.Open();
			try
			{
				MyOleDbDataAdapter.Fill(myDataTable);
			}
			finally
			{
				MyOleDbConnection.Close();
			}

			RadGrid1.DataSource = myDataTable;
		}

		#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.Button1.Click += new System.EventHandler(this.Button1_Click);
			this.RadGrid1.NeedDataSource += new Telerik.WebControls.GridNeedDataSourceEventHandler(this.RadGrid1_NeedDataSource);
			this.RadGrid1.PreRender += new System.EventHandler(this.RadGrid1_PreRender);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

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

		private void DropDownList1_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			if ( this.DropDownList1.SelectedItem.Value == "Yes" )
			{
				this.RadGrid1.MasterTableView.DataSourcePersistenceMode = GridDataSourcePersistenceMode.ViewState;
			}
			else
			{
				this.RadGrid1.MasterTableView.DataSourcePersistenceMode = GridDataSourcePersistenceMode.NoPersistence;
			}

			this.RadGrid1.MasterTableView.Rebind();
		}

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

		private void RadGrid1_PreRender(object sender, System.EventArgs e)
		{
			
		}

		protected override void Render(HtmlTextWriter writer)
		{
			this.Label1.Text = "r.a.d.<strong>grid</strong>'s ViewState size is " + RadGrid1.ViewStateSize;

			base.Render (writer);
		}

	}
}