为DataGrid添加确认删除的对话框

在删除数据前进行确认是一个非常友好的做法。在本文里，我们就讨论利用TemplateColumn和Button服务端控件实现这种功能的方法。

DeleteIt.ASPx

<%@ Page Language="<a href="http://dev.21tx.com/language/vb/" target="_blank">VB</a>" AutoEventWireup="false" Codebehind="DeleteIt.aspx.vb" Inherits="aspx<a href="http://dev.21tx.com/web/" target="_blank">Web</a>.DeleteIt"%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<HTML>

<HEAD>

<title>WebForm1</title>

</HEAD>

<body>

<asp:label id="Label1" runat="Server"></asp:label>

<asp:DataGrid id="myDataGrid" OnItemCreated="DataGrid_ItemCreated"

DataKeyField="Title" AutoGenerateColumns="False" runat="server">

<asp:TemplateColumn>

<asp:Button id="btnDelete" runat="Server"></asp:Button>

</ItemTemplate>

</asp:TemplateColumn>

<asp:BoundColumn DataField="Title"></asp:BoundColumn>

<asp:BoundColumn DataField="CreateDate" DataFormatString="{0:yyyy-M-d}"></asp:BoundColumn>

</Columns>

</asp:DataGrid>

</form>

</body>

</HTML>

后代码：DeleteIt.aspx.vb

Imports System.Web

Imports System.Collections

Imports System

Imports System.Data

Imports System.Data.OleDb

Imports System.Web.UI.WebControls

Public Class DeleteIt

Inherits System.Web.UI.Page

Protected WithEvents Label1 As System.Web.UI.WebControls.Label

Protected WithEvents myDataGrid As System.Web.UI.WebControls.DataGrid

#Region " Web 窗体设计器生成的代码 "

'该调用是 Web 窗体设计器所必需的。

<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()

End Sub

Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init

'CODEGEN: 此方法调用是 Web 窗体设计器所必需的

'不要使用代码编辑器修改它。

InitializeComponent()

End Sub

#End Region

Sub Page_Load(ByVal Sender As Object, ByVal e As EventArgs) Handles MyBase.Load

myDataGrid.HeaderStyle.Font.Bold = True

myDataGrid.HeaderStyle.HorizontalAlign = HorizontalAlign.Center

myDataGrid.Columns(0).HeaderText = "操作"

myDataGrid.Columns(1).HeaderText = "标题"

myDataGrid.Columns(2).HeaderText = "发布日期"

If Not IsPostBack Then

Dim strCn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("Test.mdb")

Dim strSql As String

strSql = "SELECT Top 15 objectGuid,Title,CreateDate FROM Document Order By CreateDate Desc"

Dim cn As New OleDbConnection(strCn)

cn.Open()

Dim cmd As New OleDbCommand(strSql, cn)

myDataGrid.DataSource = cmd.ExecuteReader(CommandBehavior.CloseConnection)

myDataGrid.DataBind()

cmd.Dispose()

cmd = Nothing

cn.Close()

cn.Dispose()

cn = Nothing

End If

End Sub

Sub DataGrid_ItemCreated(ByVal Sender As Object, ByVal e As DataGridItemEventArgs)_

Handles myDataGrid.ItemCreated

Select Case e.Item.ItemType

Case ListItemType.Item, ListItemType.AlternatingItem, ListItemType.EditItem

Dim myDeleteButton As Button

myDeleteButton = e.Item.FindControl("btnDelete")

myDeleteButton.Text = "删除此行"

myDeleteButton.Attributes.Add("onclick", "return confirm('您真的要删除第 "_

+ e.Item.ItemIndex.ToString + " 行吗？');")

End Select

End Sub

Private Sub myDataGrid_ItemCommand(ByVal source As Object, _

ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs)_

Handles myDataGrid.ItemCommand

Response.Write("您要删除的是：<font color=red>" + e.Item.Cells(1).Text + "</font>")

e.Item.BackColor = System.Drawing.Color.Ivory

End Sub

End Class

在DataGrid里添加确认删除的对话框，第二个办法就是利用ButtonColumn，这个办法与第一个方法不同的是：我们不能使用FindControl方法来引用Button控件，这是因为，我们不知道由ButtonColumn产生的每个Button控件的ID，我们这里可以使用TableCell来引用TableCell里的Button控件，一旦引用了Button控件，我们就可以用Attributes集合来添加Onclick事件。源代码如下：

DeleteIt2.ASPx

<%@ Page Language="<a href="http://dev.21tx.com/language/vb/" target="_blank">VB</a>" AutoEventWireup="false" Codebehind="DeleteIt2.aspx.vb"

Inherits="aspx<a href="http://dev.21tx.com/web/" target="_blank">Web</a>.DeleteIt2"%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<HTML>

<HEAD>

<title>DeleteIt2</title>

</HEAD>

<asp:Label id="Label1" runat="server"></asp:Label>

<asp:DataGrid id="myDataGrid" OnItemCreated="DataGrid_ItemCreated" runat="server"

OnDeleteCommand="MyDataGrid_Delete" DataKeyField="Title" AutoGenerateColumns="False">

<asp:ButtonColumn CommandName="Delete" />

<asp:TemplateColumn>

<asp:Label runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "Title") %>' />

</ItemTemplate>

</asp:TemplateColumn>

<asp:TemplateColumn>

<asp:Label runat="server" Text='<%# DataBinder.Eval(Container.DataItem,_

"CreateDate","{0:yyyy-M-d}") %>'

[1] [2] [3] 下一页