default.aspx.cs

asp.net數據庫程序范例

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

namespace DbDemo
{
	/// <summary>
	/// Summary description for WebForm1.
	/// </summary>
	public class WebForm1 : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DataGrid DbGrid;
		protected System.Web.UI.WebControls.Panel Panel1;
		protected System.Data.OleDb.OleDbCommand oleDbSelectCommand1;
		protected System.Data.OleDb.OleDbCommand oleDbInsertCommand1;
		protected System.Data.OleDb.OleDbCommand oleDbUpdateCommand1;
		protected System.Data.OleDb.OleDbCommand oleDbDeleteCommand1;
		protected System.Data.OleDb.OleDbDataAdapter oleDbData;
		protected System.Data.OleDb.OleDbConnection oleDbConn;
		protected DbDemo.DataSetDetail dataSetList;
		protected System.Web.UI.WebControls.Panel PanelEdit;
		protected System.Web.UI.WebControls.TextBox txtCustId;
		protected System.Web.UI.WebControls.TextBox txtCompany;
		protected System.Web.UI.WebControls.TextBox txtRelaName;
		protected System.Web.UI.WebControls.TextBox txtTelNum;
		protected System.Web.UI.WebControls.TextBox txtFaxNum;
		protected System.Web.UI.WebControls.TextBox txtZipCode;
		protected System.Web.UI.WebControls.Button btnNew;
		protected System.Web.UI.WebControls.Button btnEdit;
		protected System.Web.UI.WebControls.Button btnCancel;
		protected System.Web.UI.WebControls.Button btnDelete;
		protected System.Web.UI.WebControls.Button btnSave;
		protected System.Web.UI.WebControls.TextBox txtCustAdd;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			if(!IsPostBack)
			{		
				string DbPath=AppDomain.CurrentDomain.SetupInformation.ShadowCopyDirectories;
				oleDbConn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+DbPath+"\\OrderDB.mdb";
				oleDbConn.Open();
				oleDbData.Fill(dataSetList);
				DbGrid.DataSource = dataSetList;
				DbGrid.SelectedIndex = 0;
				Page.DataBind();
				SetTxtState(true);
				ViewState["EditState"] = "New";
				ViewState["iCurrentRow"] = 0;
				ViewState["iCurrentPage"]=0;
			}

		}

		#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.oleDbData = new System.Data.OleDb.OleDbDataAdapter();
			this.oleDbDeleteCommand1 = new System.Data.OleDb.OleDbCommand();
			this.oleDbConn = new System.Data.OleDb.OleDbConnection();
			this.oleDbInsertCommand1 = new System.Data.OleDb.OleDbCommand();
			this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();
			this.oleDbUpdateCommand1 = new System.Data.OleDb.OleDbCommand();
			this.dataSetList = new DbDemo.DataSetDetail();
			((System.ComponentModel.ISupportInitialize)(this.dataSetList)).BeginInit();
			this.DbGrid.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DbGrid_PageIndexChanged);
			this.DbGrid.SelectedIndexChanged += new System.EventHandler(this.DbGrid_SelectedIndexChanged);
			this.btnNew.Click += new System.EventHandler(this.btnNew_Click);
			this.btnEdit.Click += new System.EventHandler(this.btnEdit_Click);
			this.btnDelete.Click += new System.EventHandler(this.btnDelete_Click);
			this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);
			this.btnSave.Click += new System.EventHandler(this.btnSave_Click);
			// 
			// oleDbData
			// 
			this.oleDbData.DeleteCommand = this.oleDbDeleteCommand1;
			this.oleDbData.InsertCommand = this.oleDbInsertCommand1;
			this.oleDbData.SelectCommand = this.oleDbSelectCommand1;
			this.oleDbData.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																								new System.Data.Common.DataTableMapping("Table", "