从gridview删除与数据表绑定的记录 [英] delete record from gridview which bind with datatable

问题描述

晚上好，

我从网格视图中删除与数据表绑定的记录时遇到问题，
我在网格视图中有一个链接按钮，当我单击删除"按钮然后删除相应的记录时，我需要.

我的aspx文件在下面给出.

Good evening,

I have issue with deleting record from gridview which is bind with Datatable,
I have one link button in grid view,i need when i click on remove button then corresponding record deleted.

my aspx file is given below.

<asp:GridView ID="GriDisplay" runat="server"

                   onrowdeleting="GriDisplay_RowDeleting"

                   Height="162px" onselectedindexchanged="GriDisplay_SelectedIndexChanged" >
          <Columns>
          <asp:TemplateField>
          <ItemTemplate>
           <asp:LinkButton ID="LinkAssetDelete" runat="server"   OnClick="LinkAssetDelete_OnClick" CausesValidation="false" >Remove</asp:LinkButton>
          </ItemTemplate>
          </asp:TemplateField>
          </Columns>
        </asp:GridView>

我的aspx.cs文件在下面给出.

and my aspx.cs file is given below.

protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            
            DataTable dtToGrid = new DataTable();
            dtToGrid.Columns.Add("Asset", typeof(System.Int16));
            dtToGrid.Columns.Add("Employee", typeof(string));
            dtToGrid.Columns.Add("Location", typeof(string));
            dtToGrid.Columns.Add("Supplier", typeof(string));
            dtToGrid.Columns.Add("IssuedDate", typeof(string));
            Session["dtToGrid"] = dtToGrid;
        }
    }
 protected void btnAdd_Click(object sender, EventArgs e)
    {

        DataTable dtToGrid = (DataTable)Session["dtToGrid"];
        DataRow drToGrid = dtToGrid.NewRow();
        drToGrid["Asset"] = ddlAssetID.SelectedValue;
        drToGrid["Employee"] = ddlEmployeeID.SelectedItem;
        drToGrid["Location"] = ddlLocationID.SelectedItem;
        drToGrid["Supplier"] = ddlSupplierID.SelectedItem;
        drToGrid["IssuedDate"] = txtIssuedReceivedDate.Text.Trim();
        dtToGrid.Rows.Add(drToGrid);
        GriDisplay.DataSource = dtToGrid;
        GriDisplay.DataBind();
}
  protected void LinkAssetDelete_OnClick(object sender, EventArgs args)
    {
        LinkButton link = (LinkButton)sender;
        GridViewRow gv = (GridViewRow)(link.Parent.Parent);
        DataSet ds = new DataSet();
        DataTable dtToGrid = (DataTable)Session["dtToGrid"];
        DataTable dt = ds.Tables["tToGrid"];
        DataRow dr = dt.Rows[0];
        dr.Delete();
        ds.AcceptChanges();

       
    }

但它不起作用.

请任何人给我一些解决方法的想法.

在此先感谢您.

but its not working.

Please anyone give me ideas how to solve it.

Thanks in advance.

推荐答案

您需要处理Gridview Item命令事件而不是按钮单击事件.因此，请按照以下步骤操作:

1:提供链接按钮属性的命令名称，例如"Delete"
2:添加Gridview项目命令事件.在这种情况下，请检查命令名称是否为"Delete"，然后根据您的要求执行操作.

谢谢

You need to handle Gridview Item command event instead of button click event. So follow the below steps:

1: Provide command name of link button property like "Delete"
2: Add Gridview Item Command event. In this event check if command name is "Delete" then perform operation according to your requirement.

Thanks

看看此链接如何在Gridview中编辑，更新，删除
[ ^ ]


希望对您有所帮助.

Take a look at this link How to Edit,Update,Delete in Gridview
[^]


I hope this will help you well.

在gridview中放入datakeysnames ="some col"并处理gridview删除事件

int no = convert.toint16(gridview1.datakeys [e.rowindex] .value.tostring());

现在删除带有条件的语句

put datakeysnames="some col" in gridview and handle gridview deleting event

int no=convert.toint16(gridview1.datakeys[e.rowindex].value.tostring());

now delete statement as your wish with where condition

这篇关于从gridview删除与数据表绑定的记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！