datagrideg.aspx.cs

ASP.NET的一些开发实例,有论坛管理系统等

			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Region", System.Data.SqlDbType.NVarChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Region", System.Data.DataRowVersion.Original, null));
			// 
			// sqlDataAdapter1
			// 
			this.sqlDataAdapter1.DeleteCommand = this.sqlDeleteCommand1;
			this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand1;
			this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
			this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																									  new System.Data.Common.DataTableMapping("Table", "Customers", new System.Data.Common.DataColumnMapping[] {
																																																				   new System.Data.Common.DataColumnMapping("CustomerID", "CustomerID"),
																																																				   new System.Data.Common.DataColumnMapping("CompanyName", "CompanyName"),
																																																				   new System.Data.Common.DataColumnMapping("ContactName", "ContactName"),
																																																				   new System.Data.Common.DataColumnMapping("ContactTitle", "ContactTitle"),
																																																				   new System.Data.Common.DataColumnMapping("Address", "Address"),
																																																				   new System.Data.Common.DataColumnMapping("City", "City"),
																																																				   new System.Data.Common.DataColumnMapping("Region", "Region"),
																																																				   new System.Data.Common.DataColumnMapping("PostalCode", "PostalCode"),
																																																				   new System.Data.Common.DataColumnMapping("Country", "Country"),
																																																				   new System.Data.Common.DataColumnMapping("Phone", "Phone"),
																																																				   new System.Data.Common.DataColumnMapping("Fax", "Fax")})});
			this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
			// 
			// dsCustomers1
			// 
			this.dsCustomers1.DataSetName = "DSCustomers";
			this.dsCustomers1.Locale = new System.Globalization.CultureInfo("zh-CN");
			this.Load += new System.EventHandler(this.Page_Load);
			((System.ComponentModel.ISupportInitialize)(this.dsCustomers1)).EndInit();

		}
		#endregion


		/// <summary>
		/// 绑定显示数据
		/// </summary>
		private void DataGridBind()
		{
			this.dsCustomers1.Clear();
			this.sqlDataAdapter1.Fill(this.dsCustomers1);
			this.DataGrid1.DataSource=this.dsCustomers1;
			this.DataGrid1.DataBind();
			
		}

		/// <summary>
		/// 选择修改记录
		/// </summary>
		/// <param name="source"></param>
		/// <param name="e"></param>
		private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			this.DataGrid1.EditItemIndex = e.Item.ItemIndex;
			DataGridBind();
		}

		/// <summary>
		/// 取消修改
		/// </summary>
		/// <param name="source"></param>
		/// <param name="e"></param>
		private void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			this.DataGrid1.EditItemIndex=-1;
			DataGridBind();
		}

		/// <summary>
		/// 删除记录
		/// </summary>
		/// <param name="source"></param>
		/// <param name="e"></param>
		private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			this.sqlDataAdapter1.Fill(this.dsCustomers1);
			this.dsCustomers1.Tables[0].Rows.Find(this.DataGrid1.DataKeys[e.Item.ItemIndex]).Delete();
			this.DataGrid1.EditItemIndex=-1;
			UpdateDataGrid();
		}

		/// <summary>
		/// 选择页码
		/// </summary>
		/// <param name="source"></param>
		/// <param name="e"></param>
		private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
			this.DataGrid1.CurrentPageIndex=e.NewPageIndex;
			DataGridBind();
		}

		/// <summary>
		/// 修改记录
		/// </summary>
		/// <param name="source"></param>
		/// <param name="e"></param>
		private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			string sql="CustomerID='"+this.DataGrid1.DataKeys[e.Item.ItemIndex]+"'";
			this.sqlDataAdapter1.Fill(this.dsCustomers1);
			int n=this.dsCustomers1.Tables[0].Rows.Count;
			DataRow[] dr=dsCustomers1.Tables[0].Select(sql);
			for(int j=0;j<dr.Length;j++)
			{
				for(int i=0;i<e.Item.Cells.Count-2;i++)
				{
					if(i==0)
					{
						string s=e.Item.Cells[0].Text;
						dr[j][i]=s;
					}
					else
					{
						string s=((TextBox)e.Item.Cells[i].Controls[0]).Text;
						dr[j][i]=s;
					}
				}
			}
			this.DataGrid1.EditItemIndex=-1;
			UpdateDataGrid();
		}

		/// <summary>
		/// 修改记录并重新填充DataGrid
		/// </summary>
		public void UpdateDataGrid()
		{
			DataSet dsUpdate=this.dsCustomers1.GetChanges();
			this.dsCustomers1.Merge(dsUpdate);
			this.sqlDataAdapter1.Update(dsUpdate);
			DataGridBind();
		}

		private void LinkButton1_Click(object sender, System.EventArgs e)
		{
			this.Panel1.Visible=true;
		}

		/// <summary>
		/// 增加记录
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void Button1_Click(object sender, System.EventArgs e)
		{
			this.sqlDataAdapter1.Fill(this.dsCustomers1);
			DataRow dr=this.dsCustomers1.Tables[0].NewRow();
			int colcount=this.dsCustomers1.Tables[0].Columns.Count;
			for(int i=0;i<colcount;i++)
			{
				TextBox tb=(TextBox)(this.Panel1.FindControl("TextBox"+(i+1).ToString()));
				dr[i]=tb.Text;
			}
			this.dsCustomers1.Tables[0].Rows.Add(dr);;
			this.DataGrid1.EditItemIndex=-1;
			UpdateDataGrid();
			this.Panel1.Visible=false;
		}
	}
}