ASP.NET GridView控件的删除行

Question

简便的方法
http://dotnet.aspx.cc/article/a8efc285-f0b1-4f8f-8e73-2b7d8724a47c/read.aspx得到主键id然后使用SQL删除数据库数据

Answer 1

你可以在DataTable的数据行状态设置一下 deleted状态为true  这样标识下先

Answer 2

如果用数据库存储，那多个用户不能同时操作，而增加删除操作在这里用得频繁。
“你可以在DataTable的数据行状态设置一下 deleted状态为true   ”
这样子的话，那GridView上 显示的不是还没改变？

Answer 3

    /// <summary>
    /// 视图
    /// </summary>
    private DataTable GridViewSource
    {
        get
        {
            if (ViewState["List"] == null)
            {
                DataTable dt = new DataTable();
                dt.Columns.Add(new DataColumn("StockName", typeof(string)));
                dt.Columns.Add(new DataColumn("GoodsNO", typeof(string)));
                dt.Columns.Add(new DataColumn("_Name", typeof(string)));
                dt.Columns.Add(new DataColumn("Spec", typeof(string)));
                dt.Columns.Add(new DataColumn("ProductBrand", typeof(string)));
                dt.Columns.Add(new DataColumn("Unit", typeof(string)));
                dt.Columns.Add(new DataColumn("Qty", typeof(decimal)));
                dt.Columns.Add(new DataColumn("Price", typeof(decimal)));
                dt.Columns.Add(new DataColumn("Dis", typeof(decimal)));
                dt.Columns.Add(new DataColumn("Total", typeof(decimal)));
                dt.Columns.Add(new DataColumn("SN", typeof(string)));
                dt.Columns.Add(new DataColumn("MainTenancePeriod", typeof(string)));
                dt.Columns.Add(new DataColumn("PeriodEnd", typeof(string)));
                dt.Columns.Add(new DataColumn("Re", typeof(string)));
                dt.Columns.Add(new DataColumn("StockID", typeof(int)));
                dt.Columns.Add(new DataColumn("GoodsID", typeof(int)));
                dt.Columns.Add(new DataColumn("UnitID", typeof(int)));
                ViewState["List"] = dt;
            }            return (DataTable)ViewState["List"];
        }
        set
        {
            ViewState["List"] = value;
        }
    }
    /// <summary>
    /// 绑定
    /// </summary>
    private void BindData()
    {
        GridView1.DataSource = GridViewSource;
        GridView1.DataBind();
    }    
/// <summary>
    /// 删除行
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        GridViewSource.Rows[e.RowIndex].Delete();
BindData();
    }