datagrid里删除数据

最新推荐文章于 2024-04-17 09:51:17 发布

原创最新推荐文章于 2024-04-17 09:51:17 发布 · 294 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#datagrid #dataset #delete #asp #object #sql

DataGrid实例总汇专栏收录该内容

3 篇文章

订阅专栏

本文介绍如何在ASP.NET中使用DataGrid控件实现数据的删除操作，并更新DataGrid显示的内容。通过C#代码实现了从数据库中删除指定记录的功能，并重新加载数据以更新DataGrid的显示。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

    public void People_Delete(Object sender, DataGridCommandEventArgs e)
    {
        SqlConnection connDel = Operate.createCon();
        connDel.Open();
        String sql_Del = "DELETE FROM dkh WHERE dkh_autoid = " + e.Item.Cells[0].Text;

        SqlCommand sqlCommandDel = new SqlCommand(sql_Del, connDel);
        sqlCommandDel.ExecuteNonQuery();
        connDel.Close();
        SqlConnection conn = Operate.createCon();

        SqlDataAdapter sda = new SqlDataAdapter();
        sda.SelectCommand = new SqlCommand("select * from dkh", conn);
        DataSet ds = new DataSet();
        sda.Fill(ds, "per");
        this.DataGrid1.DataSource = ds.Tables["per"];
        this.DataGrid1.DataBind();

}

前台    <asp:DataGrid ID="DataGrid1" runat="server" AutoGenerateColumns="False" Width="434px" OnDeleteCommand="People_Delete" OnItemDataBound="grid_ReceiptList1_ItemDataBound">//添加的按钮名,和删除对话框
        <Columns>
            <asp:BoundColumn DataField="dkh_autoid" HeaderText="ID"></asp:BoundColumn>
            <asp:BoundColumn DataField="dkh_name" HeaderText="名子"></asp:BoundColumn>
            <asp:BoundColumn DataField="dkh_sex" HeaderText="性别"></asp:BoundColumn>
            <asp:ButtonColumn CommandName="Delete" HeaderText="删除" Text="删除"></asp:ButtonColumn>
        </Columns>
    </asp:DataGrid>

    protected void grid_ReceiptList1_ItemDataBound(object sender, DataGridItemEventArgs e)
    {
        if (e.Item.ItemIndex != -1)
        {
            //setDelMsg(e, "Delete", "真的要删除吗？");

LinkButton lb = (LinkButton)e.Item.Cells[6].Controls[0];

lb.Attributes.Add("onclick", "return confirm('真的要删除吗？')");
//Response.Write(e.Item.Cells[6].Controls[0].ToString());

}
}