求用vs.net的datagrid中模板列编辑删除更新数据的方法,最好是vb版的(初学)

解决方案 »

  1.   

    C#:1. *.aspx页面中代码
      <asp:EditCommandColumn ButtonType="LinkButton" UpdateText="更新" CancelText="取消" EditText="編輯">
    <HeaderStyle ></HeaderStyle>
    </asp:EditCommandColumn>
    <asp:ButtonColumn Text="刪除" CommandName="delete">
    <HeaderStyle ></HeaderStyle>
    </asp:ButtonColumn>2. *.cs中的代码
       private void grdSellGoods_UpdateCommand(object source, DataGridCommandEventArgs e)
    {if(this.ViewState["dtSaleGoods"] != null)
    {
    dtSaleGoods = (DataTable)(this.ViewState["dtSaleGoods"]);
    }
    string strAccount  = ((TextBox)e.Item.FindControl("txtEditAccount")).Text.Trim();
    string strPiNumber = ((TextBox)e.Item.FindControl("txtEditPiNumber")).Text.Trim();
    string strRe   = ((TextBox)e.Item.FindControl("txtEditRe")).Text.Trim();if(strGoodsID.Trim().Length == 0)   
    {   
    this.Response.Write("<script language=\"javascript\">alert('" + _GoodsNoNull + "');</script>");
    return;
    }
    if(strAccount.Trim().Length == 0)   
    {   
    this.Response.Write("<script language=\"javascript\">alert('" + _GoodsAccountNoNull + "');</script>");
    return;
    }
    if(!Function.JudgeInteger(strAccount))
    {
    this.divShowPrompt.InnerHtml = this.GetPromptInfoHtml(Xframe.WebUI.EnumPromptInfoType.Warn,Xframe.WebUI.EnumProcType.Other,this._Account + this._MustInteger +"!","",false,0);
    return;
    }            DataSet dsGoodsInf = new DataSet();DataRow drEdit = dtSaleGoods.Rows[e.Item.ItemIndex];
    drEdit["GoodsID" ]  = strGoodsID;
    drEdit["ChiName"]   = dsGoodsInf.Tables[0].Rows[0]["ChiName"].ToString();
    drEdit["Account" ]  = strAccount;
    drEdit["PiNumber"]  = strPiNumber;
    drEdit["Price"]     = decPrice;
    drEdit["sum" ]      = decPrice * decimal.Parse(strAccount);
    drEdit["Re" ]   = strRe;dtSaleGoods.AcceptChanges();this.grdSellGoods.EditItemIndex = -1;
    this.ViewState["dtSaleGoods"] = dtSaleGoods;
    this.FromViewStateBind();
    }private void grdSellGoods_CancelCommand(object source, DataGridCommandEventArgs e)
    {
    this.grdSellGoods.EditItemIndex = -1;
    this.FromViewStateBind();
    }private void grdSellGoods_EditCommand(object source, DataGridCommandEventArgs e)
    {
    this.grdSellGoods.EditItemIndex = e.Item.ItemIndex;
    this.FromViewStateBind();
    }
      

  2.   

    http://dotnet.aspx.cc/ShowDetail.aspx?id=8ADE535F-AD40-4DE3-A962-A64B4FAF12C4