GridView 自定义列，删除时给出提示：如 “ 确信要删 除 - 张三 - 吗？ ” ，其中张三为当前行的姓名

 

<div>
   
        <asp:SqlDataSource ID="SqlDataSource1" runat="server"
            ConnectionString="<%$ ConnectionStrings:SchoolConnectionString %>"
            DeleteCommand="DELETE FROM [T_sanguoban] WHERE [id] = @id"
            InsertCommand="INSERT INTO [T_sanguoban] ([Name], [Age], [Image], [Gender]) VALUES (@Name, @Age, @Image, @Gender)"
            SelectCommand="SELECT * FROM [T_sanguoban]"
            UpdateCommand="UPDATE [T_sanguoban] SET [Name] = @Name, [Age] = @Age, [Image] = @Image, [Gender] = @Gender WHERE [id] = @id">
            <DeleteParameters>
                <asp:Parameter Name="id" Type="Int32" />
            </DeleteParameters>
            <InsertParameters>
                <asp:Parameter Name="Name" Type="String" />
                <asp:Parameter Name="Age" Type="Int32" />
                <asp:Parameter Name="Image" Type="String" />
                <asp:Parameter Name="Gender" Type="String" />
            </InsertParameters>
            <UpdateParameters>
                <asp:Parameter Name="Name" Type="String" />
                <asp:Parameter Name="Age" Type="Int32" />
                <asp:Parameter Name="Image" Type="String" />
                <asp:Parameter Name="Gender" Type="String" />
                <asp:Parameter Name="id" Type="Int32" />
            </UpdateParameters>
        </asp:SqlDataSource>
        <br />
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
            DataKeyNames="id" DataSourceID="SqlDataSource1"
            onrowcommand="GridView1_RowCommand" onrowdatabound="GridView1_RowDataBound1">
            <Columns>
                <asp:BoundField DataField="id" HeaderText="编号" InsertVisible="False"
                    ReadOnly="True" SortExpression="id" />
                <asp:BoundField DataField="Name" HeaderText="姓名" SortExpression="Name" />
                <asp:BoundField DataField="Age" HeaderText="年龄" SortExpression="Age" />
                <asp:ImageField DataImageUrlField="Image" HeaderText="图片">
                    <ControlStyle Height="70px" Width="70px" />
                </asp:ImageField>
                <asp:BoundField DataField="Gender" HeaderText="性别" SortExpression="Gender" />
                <asp:ButtonField CommandName="delete" Text="删除" />
                <asp:ButtonField CommandName="edit" Text="编辑" />
                <asp:ButtonField CommandName="update" Text="更新" />
                <asp:ButtonField CommandName="chushihua" Text="初始化密码" />
            </Columns>
        </asp:GridView>
   
    </div>

 

后台:

后台需要用gridview属性的一个方法    RowDataBound

 

protected void GridView1_RowDataBound1(object sender, GridViewRowEventArgs e)
        {
           
            if (e.Row.RowType != DataControlRowType.DataRow) {
                return;              
            }
            string name = e.Row.Cells[1].Text;
            LinkButton lbtn = (LinkButton)e.Row.Cells[5].Controls[0];  // 这就是找到这个单元格里第一个控件
            if (lbtn != null)
            {
                lbtn.Attributes.Add("onclick", "return confirm('你确定要删除-"+name+"-么？');");
            }
           
        }