如何使用asp.net C#中的复选框删除记录 [英] How to delete records using checkbox in asp.net C#

问题描述

尊敬的专家，
请给我建议C#代码...使用c#.asp中的复选框删除C ...
我也想在这里显示名称和图像.
我尝试了此代码，但未尝试cmg ..
这是我的设计页面...

Dear Experts,
plz can u suggest me C# code...for delete using checkbox in asp.net using c#..
And also i want to display here name and image.
I tried this code but not cmg..
this is my design page...

<div>
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" DataKeyNames="id" DataSourceID="SqlDataSource1">
        <Columns>
        <asp:TemplateField>
        <ItemTemplate>
        <asp:CheckBox ID="chkdelete" runat="server" />

        </ItemTemplate>

        </asp:TemplateField>
        <asp:BoundField DataField="id" HeaderText="id" />
        <asp:BoundField DataField="Name" HeaderText="Name" />
        <asp:BoundField DataField="Image" HeaderText="Image" />
        </Columns>

        </asp:GridView>

        <asp:SqlDataSource ID="SqlDataSource1" Runat="server"

    SelectCommand="SELECT id, Name, image FROM showdetails"

    DeleteCommand="DELETE FROM showdetails WHERE id = @id"

    ConnectionString="<%$ ConnectionStrings:sss %>" >


</asp:SqlDataSource>
    </div>
    <asp:Button ID="btndelete" runat="server" Text="Delete"

        onclick="btndelete_Click" />

    </form>

还有我的asp.cs页面

And My asp.cs page

protected void btndelete_Click(object sender, EventArgs e)
    {
        foreach (GridViewRow row in GridView1.Rows)
        {
            CheckBox checkbox = (CheckBox)row.FindControl("chkdelete");


            if (checkbox.Checked)
            {

                int id = Convert.ToInt32(GridView1.DataKeys[row.RowIndex].Value);
                SqlDataSource1.DeleteParameters["id"].DefaultValue = id.ToString();
                SqlDataSource1.Delete();
            }

}

推荐答案

ConnectionStrings:sss ％> " > < /asp:SqlDataSource > < /div > < asp:Button ID =" runat 服务器" 文本 删除" span> onclick =" btndelete_Click" / < /form >

ConnectionStrings:sss %>" > </asp:SqlDataSource> </div> <asp:Button ID="btndelete" runat="server" Text="Delete" onclick="btndelete_Click" /> </form>

还有我的asp.cs页面

And My asp.cs page

protected void btndelete_Click(object sender, EventArgs e)
    {
        foreach (GridViewRow row in GridView1.Rows)
        {
            CheckBox checkbox = (CheckBox)row.FindControl("chkdelete");


            if (checkbox.Checked)
            {

                int id = Convert.ToInt32(GridView1.DataKeys[row.RowIndex].Value);
                SqlDataSource1.DeleteParameters["id"].DefaultValue = id.ToString();
                SqlDataSource1.Delete();
            }

}

有关类似问题，请参阅答案，
从datgridview和数据库访问中删除行 [ ^ ]
您肯定会从中获得一些帮助.



对于网格中的图像，请看:
在GridView中从数据库Asp.Net显示图像 [ ^ ]
MSDN:在GridView列中显示图像 [在GridView中显示数据库中的图像 [ ^ ]

Please refer answer for similar question,
Delete rows from datgridview and database access[^]
You will get some help from it, for sure.



For image in grid have a look:
Display Images In GridView From DataBase Asp.Net[^]
MSDN: Displaying Images in a GridView Column[^]
Displaying Images from a Database in a GridView[^]

这篇关于如何使用asp.net C#中的复选框删除记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！