delete.aspx.cs

《圣殿祭司的ASP.NET 2.0开发详解——使用C#》光盘内容.包含了书籍所含的源代码.非常经典的一本asp.net2.0的书籍

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Drawing;

public partial class Delete : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
		if (!IsPostBack)
		{
			//txtColumn.Text = "请选择任何意一行";
			setGridViewStyle();
			setFields();
		}

		//设置SqlDataSource连接及Select命令
		sqlDS.ConnectionString = ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString;
		sqlDS.SelectCommand = "select EmployeeID,LastName,City,Address from Employees";
		sqlDS.DeleteCommand = "delete from Employees where EmployeeID=@EmployeeID ";
		//设置GridView数据源ID
		gviewEmployee.DataSourceID = sqlDS.ID;
    }

	//设置GridView外观样式
	private void setGridViewStyle()
	{
		gviewEmployee.AutoGenerateColumns = false;
		string[] KeyNames = new string[] { "EmployeeID" };
		gviewEmployee.DataKeyNames = KeyNames;

		//设置GridView属性
		gviewEmployee.AllowPaging = true;	//设置分页
		gviewEmployee.AllowSorting = true;	//设置排序
		gviewEmployee.Font.Size = 10;		//设置字号大小
		gviewEmployee.GridLines = GridLines.Both;	//设置网格线
		gviewEmployee.PageSize = 5;
		gviewEmployee.PagerSettings.Position = PagerPosition.TopAndBottom; //分页位置
		gviewEmployee.PagerStyle.HorizontalAlign = HorizontalAlign.Center; //分页对齐

		gviewEmployee.HeaderStyle.BackColor = Color.Tan;
		gviewEmployee.RowStyle.BackColor = Color.LightGoldenrodYellow;
		gviewEmployee.AlternatingRowStyle.BackColor = Color.PaleGoldenrod;
		gviewEmployee.HeaderStyle.ForeColor = Color.Black;
		gviewEmployee.PagerStyle.BackColor = Color.Goldenrod;
	}

	//创建及设置Fields字段
	private void setFields()
	{
		//创建命令字段
		CommandField deleteField = new CommandField();
		deleteField.ButtonType = ButtonType.Button;
		deleteField.ShowDeleteButton = true;
		deleteField.DeleteText = "删除行";
		//deleteField.ControlStyle.BackColor = Color.LightPink;
		deleteField.ItemStyle.Wrap = false;
		//创建数据绑定字段
		BoundField employeeidField = new BoundField();
		BoundField lastnameField = new BoundField();
		BoundField cityField = new BoundField();
		BoundField addressField = new BoundField();

		employeeidField.DataField = "EmployeeID";	//指定数据源字段
		employeeidField.HeaderText = "EmployeeID";	//设置字段头名称
		//employeeidField.SortExpression = "EmployeeID";	//指定排序字段名称
		employeeidField.ItemStyle.Wrap = false;
		employeeidField.ItemStyle.HorizontalAlign = HorizontalAlign.Center;
		lastnameField.DataField = "LastName";
		lastnameField.HeaderText = "LastName";
		//lastnameField.SortExpression = "LastName";
		lastnameField.ItemStyle.Wrap = false;
		cityField.DataField = "City";
		cityField.HeaderText = "City";
		//cityField.SortExpression = "City";
		cityField.ItemStyle.Wrap = false;
		addressField.DataField = "Address";
		addressField.HeaderText = "Address";
		addressField.ItemStyle.Wrap = false;
		//将字段加入到GridView
		gviewEmployee.Columns.Add(deleteField);
		gviewEmployee.Columns.Add(employeeidField);
		gviewEmployee.Columns.Add(lastnameField);
		gviewEmployee.Columns.Add(cityField);
		gviewEmployee.Columns.Add(addressField);
	}

	//删除GridView数据行
	protected void gviewEmployee_RowDeleting(object sender, GridViewDeleteEventArgs e)
	{
		string txtEmployee = gviewEmployee.Rows[e.RowIndex].Cells[2].Text;
		if (txtEmployee != "江华")
		{
			e.Cancel = true;
			Literal txtMsg = new Literal();
			txtMsg.Text = "<script>alert('已执行删除" + txtEmployee + "命令，但为确保数据完整性，数据不予删除')</script>";
			Page.Controls.Add(txtMsg);
		}
	}
}