删除数据集中的一行 [英] Delete a row in Dataset

问题描述

我正在使用Datatable绑定一个数据网格.我在数据网格中给出了一个删除按钮.如果单击，则要删除整个行.我该怎么办.

我创建了如下表，并用它来绑定数据网格:

数据表dTable;

Hi,

I am using Datatable to bind a datagrid. I gave a delete button in the datagrid. If I clicked that I want to delete that entire row. How can I do this.

I created Table as below and used this to bind the data grid:

DataTable dTable;

dTable = new DataTable();
dTable.Columns.Add("KitName");
dTable.Columns.Add("OrderQuantity");
dTable.Columns.Add("Discount");
dTable.Columns.Add("DiscountScheme");
dTable.Columns.Add("DiscountType");
dTable.Columns.Add("DiscountedValue");
dTable.Columns.Add("DiscountSchemeVal");
dTable.Columns.Add("DiscountTypeVal");

dRow["KitName"] = strKitName;
dRow["OrderQuantity"] = strKitQuant;
dRow["Discount"] = strDiscount;
dRow["DiscountScheme"] = strDisScheme;
dRow["DiscountSchemeVal"] = strDisSchemeVal;
dRow["DiscountType"] = strDisType;
dRow["DiscountTypeVal"] = strDisTypeVal;
dRow["DiscountedValue"] = strDisVal;
dTable.Rows.Add(dRow);

推荐答案

Maajanes这段代码可能会对您有所帮助.


您的gridView:

Hi Maajanes This code might help you.


Your gridView:

<asp:GridView ID="gridView1" runat="server" DataKeyNames="KitName"

            onrowdeleting="gridView1_RowDeleting">
            <Columns>
                <asp:BoundField HeaderText="KitName" DataField="KitName"></asp:BoundField>
                <asp:BoundField HeaderText="OrderQuantity" DataField="OrderQuantity"></asp:BoundField>
                <asp:BoundField HeaderText="Discount" DataField="Discount"></asp:BoundField>
                <asp:BoundField HeaderText="DiscountScheme" DataField="DiscountScheme"></asp:BoundField>
                <asp:BoundField HeaderText="DiscountType" DataField="DiscountType"></asp:BoundField>
                <asp:BoundField HeaderText="DiscountedValue" DataField="DiscountedValue"></asp:BoundField>
                <asp:BoundField HeaderText="DiscountSchemeVal" DataField="DiscountSchemeVal"></asp:BoundField>
                <asp:BoundField HeaderText="DiscountTypeVal" DataField="DiscountTypeVal"></asp:BoundField>
            </Columns>
        </asp:GridView>

和代码:

And the Code:

DataTable dTable;
        
        protected void Page_Load(object sender, EventArgs e)
        {

            dTable = new DataTable();
            dTable.Columns.Add("KitName");
            dTable.Columns.Add("OrderQuantity");
            dTable.Columns.Add("Discount");
            dTable.Columns.Add("DiscountScheme");
            dTable.Columns.Add("DiscountType");
            dTable.Columns.Add("DiscountedValue");
            dTable.Columns.Add("DiscountSchemeVal");
            dTable.Columns.Add("DiscountTypeVal");

            DataRow dRow = dTable.NewRow();
            dRow["KitName"] = strKitName;
            dRow["OrderQuantity"] = strKitQuant;
            dRow["Discount"] = strDiscount;
            dRow["DiscountScheme"] = strDisScheme;
            dRow["DiscountSchemeVal"] = strDisSchemeVal;
            dRow["DiscountType"] = strDisType;
            dRow["DiscountTypeVal"] = strDisTypeVal;
            dRow["DiscountedValue"] = strDisVal;
            dTable.Rows.Add(dRow);

            gridView1.DataSource = dTable;
            gridView1.DataBind();
        }

        protected void gridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            DataRow row = dTable.Select("KitName=" + gridView1.DataKeys[e.RowIndex]["KitName"])[0];
            row.Delete();
            dTable.AcceptChanges();
            dTable.DataSource = dTable;
            dTable.DataBind();
        }

这篇关于删除数据集中的一行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！