为什么所选行没有删除 [英] Why selected row is not deleting

问题描述

为什么选定的行未在gridview中删除?

我的CS代码在下面给出

Why selected row is not deleting in gridview ?

my cs code is given below

protected void Button1_Click(object sender, EventArgs e)
    {
        //Loop through all the rows in gridview
        foreach (GridViewRow gvrow in gv1.Rows)
        {
            //Finiding checkbox control in gridview for particular row
            CheckBox chkdelete = (CheckBox)gvrow.FindControl("chkdelete");
            //Condition to check checkbox selected or not
            if (chkdelete.Checked)
            {
                //Getting email of particular row using datakey value
                //int mail = Convert.ToInt32(gv1.DataKeys[gvrow.RowIndex].Value);
                string email = gv1.DataKeys[gvrow.RowIndex]["mail"].ToString();
                AccessDataSource1.DeleteParameters["mail"].DefaultValue = email;
                AccessDataSource1.Delete();
            }
        }

    }

我的GridView的html部分在下面给出

My html part of gridview is given below

<asp:GridView ID="gv1" runat="server" DataSourceID="AccessDataSource1"

DataKeyNames="mail" CssClass="Gridview" AutoGenerateColumns="False"

HeaderStyle-BackColor="#61A6F8" HeaderStyle-Font-Bold="true"

HeaderStyle-ForeColor="White" AllowPaging="True">
<Columns>
<asp:TemplateField>
<ItemTemplate>
<asp:CheckBox ID="chkdelete" runat="server"/>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="cname" HeaderText="NAME" />
<asp:BoundField DataField="dob" HeaderText="DOB" />
<asp:BoundField DataField="city" HeaderText="CITY" />
<asp:BoundField DataField="mail" HeaderText="EMAIL" />
<asp:BoundField DataField="occu" HeaderText="OCCUPATION" />
</Columns>
</asp:GridView>
                        <asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Delete" />
                        <br />
                        <asp:AccessDataSource ID="AccessDataSource1" runat="server"

                            DataFile="~/Rabiya.mdb"

                            SelectCommand="SELECT [cname], [dob], [city], [mail], [occu] FROM [joining]" DeleteCommand="Delete from joining where mail=@mail">
            <DeleteParameters>
            <asp:Parameter Name="mail" Type="Int32" />
            </DeleteParameters>
                        </asp:AccessDataSource>

我的Java脚本部分在下面给出

My Java Script part is given below

<script type="text/javascript">
    function Confirmationbox() {
        var result = confirm('Are you sure you want to delete selected User(s)?');
        if (result) {
            return true;
        }
        else {
            return false;
        }
    }
</script>

推荐答案

你好Mr.janardan
在这种情况下，您需要检查将数据绑定到gridview的位置.
检查您是否在其中绑定(如果不发回)或绑定在外面.
我认为您正在绑定而不检查是否不回发.

如果查询解决了，则将其标记为已回答.

Hello Mr.janardan
In such kind of issue you firs check where you are binding data to gridview.
check wether you are binding in( if not post back) or out side that.
I think you are binding without checking if not postback.

Mark Answered if it solved you query.

检查您是否绑定(如果不发回)或绑定在此之外.
我认为您正在绑定而不检查是否不发回.

Check whether you are binding in (if not post back) or outside that.
I think you are binding without checking if not post back.

这篇关于为什么所选行没有删除的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！