ASP.NET探寻

itzhiren的Blog

导航

使用VS2005中的GridView中的CommandField进行删除操作时，如何弹出确认对话框?

Posted on 2006-08-24 08:38  itzhiren  阅读(5687)  评论(3)    收藏  举报

在VS2005提供的GridView中我们可以直接添加一个CommandField删除列：<asp:CommandField ShowDeleteButton="True" />，然后在GridView的OnRowDeleting事件中完成删除。但一般情况下我们在做这种删除操作时都需要先让用户确认一下，然后后再删除记录，以避免误操作引起的误删除。

那我们可以通过下面方法给GridView删除前加上一个确认对话框。

首先，在GridView的属性对框话框中点击“Columns”进入它的"字段"设计器;或者在设计窗口直接点击GridView控件右上角的那个小箭头,点击"编辑列",进入"字段"设计器。

接着在"字段"设计器中的左下方"选定的字段"框中,选择以前已加上的那个CommandField“删除”列，这时在右边它的属性列表下会看到一个"将此它段转换为 TemplateFied"的项，点击将它转换为TemplateFied列。

然后退出"字段"设计器，切换到源码视图你会发现该列已由原来的：
<asp:CommandField ShowDeleteButton="True" />
变为了：
<asp:TemplateField ShowHeader="False">
                                <ItemTemplate>
                                    <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False"

CommandName="Delete"  Text="删除"></asp:LinkButton>
 </ItemTemplate>

最后在<asp:LinkButton>中加入：OnClientClick="return confirm('您确认删除该记录吗?');"

这样点击删除时就会先在客户端弹出“您确认删除该记录吗？”对话框,点击"确定",则进行删除;点击"取消",则不删除.
而原来在onRowDeleting事件中写的代码完全不用改变。
这里有个例子,完整源码如下:
<%@ Page Language="VB" Debug ="true"  %>
<%@ Import Namespace="System.Data.OleDb" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">
    Dim connstr As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("rizhi.mdb") & ";User Id=;Password=;"
    Dim sql As String
    Dim mycommand As OleDbCommand
    Dim myread As OleDbDataReader
    Dim conn As OleDbConnection
    Sub page_load(ByVal sender As Object, ByVal e As EventArgs)
        conn = New OleDbConnection(connstr)
        conn.Open()
        sql = "select * from rizhi"
        mycommand = New OleDbCommand(sql, conn)
        myread = mycommand.ExecuteReader()
       
        GridView1.DataSource = myread
        GridView1.DataBind()
        conn.Close()
    End Sub

    Protected Sub GridView1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs)

    End Sub
    Protected Sub GridView1_RowDeleting(ByVal sender As Object, ByVal e As GridViewDeleteEventArgs)
        Dim id As Integer = GridView1.DataKeys(e.RowIndex).Value
        Dim j As Integer = 0
        conn = New OleDbConnection(connstr)
        conn.Open()
        sql = "delete from rizhi where id=" & id
       
        mycommand = New OleDbCommand(sql, conn)
        Try
            j = mycommand.ExecuteNonQuery
            Response.Write("共删除了" & j & "条记录!")
            sql = "select * from rizhi"
            mycommand = New OleDbCommand(sql, conn)
            myread = mycommand.ExecuteReader()
       
            GridView1.DataSource = myread
            GridView1.DataBind()

        Catch ex As Exception
            Throw ex
        Finally
            conn.Close()
        End Try
       
       
    End Sub
</script>

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>无标题页</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <center>
    <a href ="rizhi_add.aspx" style ="font-size :12px;">增加新日志</a>
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" Width ="60%" Font-Size="12px" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" OnRowDeleting="GridView1_RowDeleting" DataKeyNames="id" >
        <Columns>
        <asp:BoundField DataField="id" HeaderText="序号" >
            <ItemStyle Font-Size="12px" HorizontalAlign="Left" />
            <HeaderStyle BackColor="BurlyWood" Font-Size="12px" HorizontalAlign="Center" />
        </asp:BoundField>
       
        <asp:BoundField DataField="rq" HeaderText="日期" >
    <ItemStyle Font-Size="12px" HorizontalAlign="Left" />
    <HeaderStyle BackColor="BurlyWood" Font-Size="12px" HorizontalAlign="Center" />
</asp:BoundField>

        <asp:BoundField DataField="n_je" HeaderText="金额" >
            <ItemStyle Font-Size="12px" HorizontalAlign="Right" />
            <HeaderStyle BackColor="BurlyWood" Font-Size="12px" HorizontalAlign="Center" />
        </asp:BoundField>
       
        <asp:BoundField DataField="title" HeaderText="标题" >
            <ItemStyle Font-Size="12px" HorizontalAlign="Left" />
            <HeaderStyle BackColor="BurlyWood" Font-Size="12px" HorizontalAlign="Center" />
        </asp:BoundField>
       
        <asp:BoundField DataField="content" HeaderText="内容" >
            <ItemStyle Font-Size="12px" HorizontalAlign="Left" />
            <HeaderStyle BackColor="BurlyWood" Font-Size="12px" HorizontalAlign="Center" />
        </asp:BoundField>
       
        <asp:HyperLinkField DataTextField="id" DataNavigateUrlFields ="id"

DataNavigateUrlFormatString="rizhi_edit.aspx?id={0}" HeaderText ="操作" DataTextFormatString ="修改" >
        <ItemStyle Font-Size="12px" HorizontalAlign="Center" />
        <HeaderStyle BackColor ="BurlyWood" Font-Size="12px" HorizontalAlign="Center" />
        </asp:HyperLinkField>
            <asp:TemplateField HeaderText="操作" ShowHeader="False">
                <ItemTemplate>
                    <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Delete"
                        Text="删除" OnClientClick="return confirm('您确认删除该记录吗?');"></asp:LinkButton>
                </ItemTemplate>
            </asp:TemplateField>
        </Columns>
        </asp:GridView>
    </center>      
    </div>
    </form>
</body>
</html>