GridView如何更新批量数据和单条记录？

后台代码段

        Members#region Members
        protected GridView GVList;
        public string PreUrl = Agronet.Common.Framework.Util.Globals.MemberUserPath + "Product" + @"/";

        protected Agronet.Common.Framework.Util.Pager pager;
        protected TextBox txtSearchTxt;
        protected Button btnSearch;
        protected HyperLink cmdAdd;
        protected LinkButton cmdDel;
        protected LinkButton cmdRecommend;
        protected LinkButton cmdUnPublish;
        protected TextBox txtWords;
        protected DropDownList ddlType;
        protected Label TradeTypeID;
        protected Label NoResult;
        private int _page = 1;
        public int _sort = 0;
        /**//// <summary>
        /// 关键字
        /// downmoon 2007年12月12日
        /// </summary>
        private string _word
        ...{
            get
            ...{
                object o = ViewState["strWords"];
                return (o == null) ? "" : o.ToString();
            }
            set
            ...{
                ViewState["strWords"] = value;
            }
        }

        // 审核状态
        public short CheckState
        ...{
            get
            ...{
                object o = ViewState["CheckState"];
                return SQLParser.ShortParse(o);
            }
            set ...{ ViewState["CheckState"] = value; }
        }
        #endregion
        Events#region Events

        protected override void OnLoad(EventArgs e)
        ...{
            base.OnLoad(e);
            Check#region Check
            CheckSiteUser();
            #endregion

            initPage#region initPage
            _page = SQLParser.IntParse(Page.Request.QueryString["page"]);
            _word = SQLParser.StringParse(Page.Request.QueryString["word"]);
            CheckState = SQLParser.ShortParse(Page.Request.QueryString["st"]);

            if (txtSearchTxt != null)
            ...{
                txtSearchTxt.Attributes.Add("maxlength", "20");
                txtSearchTxt.Text = _word;
            }
            if (this.ddlType != null)
            ...{
                this.ddlType.SelectedValue = this.CheckState.ToString();
                this.ddlType.SelectedIndexChanged += new EventHandler(ddlType_SelectedIndexChanged);

            }
            if (cmdAdd != null) ...{ cmdAdd.NavigateUrl = PreUrl + "Insert.aspx"; }
            if (cmdDel != null) ...{ cmdDel.Click += new EventHandler(cmdDel_Click); }
            if (cmdRecommend != null) ...{ cmdRecommend.Click += new EventHandler(cmdRecommend_Click); }
            if (cmdUnPublish != null) ...{ cmdUnPublish.Click += new EventHandler(cmdUnPublish_Click); }
            pager.PageIndex = _page;
            pager.PageSize = Agronet.Common.Framework.Util.Globals.PageSize;
            if (GVList != null)
            ...{
                GVList.RowDataBound += new GridViewRowEventHandler(GVList_RowDataBound);
                GVList.RowCommand += new GridViewCommandEventHandler(GVList_RowCommand);
                GVList.RowUpdating += new GridViewUpdateEventHandler(GVList_RowUpdating);
            }
            if (NoResult != null) ...{ NoResult.Text = GetCurStateByID(CheckState) + "列表"; }
            if (btnSearch != null) ...{ btnSearch.Click += new EventHandler(btnSearch_Click); }

            #endregion
            BindList#region BindList
            if (!IsPostBack)
            ...{
                BindList();
            }
            pager.UrlFormat = PreUrl + "?page={0}&sort=0&dvid=2&word=" + _word + "&st=" + CheckState.ToString();
            #endregion
        }
        Serarch#region Serarch
        private void btnSearch_Click(object sender, EventArgs e)
        ...{
            string strurl = PreUrl + "?dvid=2&sort=0&st={0}&word={1}";
            this.CheckState = SQLParser.ShortParse(this.ddlType.SelectedItem.Value);
            strurl = string.Format(strurl, CheckState.ToString(), txtSearchTxt.Text.Trim());
            PageLocation(strurl);
        }
        #endregion
        ddlType#region ddlType
        private void ddlType_SelectedIndexChanged(object sender, EventArgs e)
        ...{
            if (this.ddlType != null && ddlType.SelectedValue.Trim() != "")
            ...{
                this.CheckState = SQLParser.ShortParse(this.ddlType.SelectedItem.Value);
                string strurl = PreUrl + "?dvid=2&page=1&st=" + CheckState.ToString() + "&word=" + this.txtSearchTxt.Text.Trim(); ;
                PageLocation(strurl);
            }
        }
        #endregion
        protected void cmdDel_Click(object sender, EventArgs e)
        ...{
            执行批量操作#region 执行批量操作
            UpdateMultiRecordsByWhere(pager.PageSize, -4, 1);
            #endregion
        }
        private void cmdUnPublish_Click(object sender, EventArgs e)
        ...{
            执行批量操作#region 执行批量操作
            UpdateMultiRecordsByWhere(pager.PageSize, -2, 1);
            #endregion;
        }
        private void GVList_RowCommand(object sender, GridViewCommandEventArgs e)
        ...{
            执行批量操作#region 执行批量操作
            if (e.CommandName == "Update")
            ...{
                try
                ...{
                    int days = 0;
                    if (muser.ClientClass > 0) ...{ days = Globals.ProductinfoUpdatePerDays; }
                    long pid = SQLParser.LongParse(GVList.DataKeys[SQLParser.IntParse(e.CommandArgument)].Value);
                    //GridView a = (GridView)sender;
                    if (pid > 0)
                    ...{
                        int retValue = Agronet.Product.Framework.Data.DataDTOProvider.ProducyUpdateModifyTime(pid, days, muser.LoginID);
                        switch (retValue)
                        ...{
                            case -1:
                                Debug("产品更新失败，原因：产品未通过审核！", "Error");
                                break;
                            case 0:
                                Debug("产品更新失败，原因：未知！", "Error");
                                break;
                            case 1:
                                Index#region Index
                                 Debug("产品更新成功！", "Succeed");
                                #endregion
                                break;
                            case 2:
                                Debug("尊敬用户" + user.LoginID + @"您好， 您选择的产品暂时还不能被更新,原因：单位时间内更新过与频繁，二十分钟之内不能连续更新！", "Error");
                                break;
                            default:
                                break;
                        } 
                    }
                }
                catch(Exception ex)
                ...{
                    return;
                }
            }
            #endregion
        }
        private void GVList_RowUpdating(object sender, GridViewUpdateEventArgs e)
        ...{
            //BindList();
        }
        private void cmdRecommend_Click(object sender, EventArgs e)
        ...{
            执行批量操作#region 执行批量操作
            UpdateMultiRecordsByWhere(pager.PageSize, 1, 2);
            #endregion

        }
        protected void GVList_RowDataBound(object sender, GridViewRowEventArgs e)
        ...{
            if (e.Row.RowType == DataControlRowType.DataRow)
            ...{
                HyperLink cmdMod = (HyperLink)e.Row.FindControl("cmdMod");
                if (cmdMod != null) ...{ cmdMod.NavigateUrl = PreUrl + "Modify.aspx?dvid=2&PKID=" + DataBinder.Eval(e.Row.DataItem, "P_ID"); }
                LinkButton lbUpdate = (LinkButton)e.Row.FindControl("cmdUpdate");
                if (lbUpdate != null) ...{ lbUpdate.CommandArgument = e.Row.RowIndex.ToString(); }
            }
        }
        #endregion
        Methods#region Methods
        BindList#region BindList

        private void BindList()
        ...{
            string strWhere = string.Empty;
            strWhere = " (LoginID='" + muser.LoginID + "') ";
            Agronet.Product.Framework.Components.ProductCollection sc = Agronet.Product.Framework.Data.DataDTOProvider.GetProductReturnCollection(_word.Trim(), strWhere, pager.PageIndex, pager.PageSize, _sort, CheckState);
            this.GVList.DataSource = sc;
            this.GVList.DataBind();
            if (sc.MaxItems > 0)
            ...{ pager.ItemCount = sc.MaxItems; }
            else
            ...{
                pager.Visible = false;
                this.NoResult.Text = "无符合条件的记录!";
            }

        }
        Multiple Record Update Method#region Multiple Record Update Method
        private void UpdateMultiRecordsByWhere(int mCount, short mState, short updateType)
        ...{
            Check#region Check
            CheckSiteUser();
            #endregion
            执行批量操作#region 执行批量操作
            try
            ...{
                StringBuilder sb = new StringBuilder();
                string strTemp = string.Empty;
                string PKName = string.Empty;
                int tempCount = 0;
                if (GVList == null || GVList.Rows.Count == 0) ...{ return; }
                PKName = GVList.DataKeyNames[0].ToString();
                sb.Append(" where  ");
                sb.Append(" LoginID= '");
                sb.Append(muser.LoginID);
                sb.Append("' AND  ");
                sb.Append(PKName);
                sb.Append(" in (");
                for (int i = 0; i < GVList.Rows.Count; i++)
                ...{
                    CheckBox chk = (CheckBox)GVList.Rows[i].FindControl("chkDelServer");
                    if (chk != null && chk.Checked)
                    ...{
                        sb.Append(GVList.DataKeys[i].Value.ToString());
                        sb.Append(",");
                        tempCount++;
                    }
                }
                if (tempCount == 0) return;
                if (tempCount > mCount) ...{ Debug("超出批量操作的最大允许数量!", this.ClientID, true); return; }
                strTemp = sb.ToString();
                if (strTemp.EndsWith(",")) ...{ strTemp = strTemp.Remove(strTemp.Length - 1); }
                strTemp += ") ";
                if (updateType == 1)
                ...{
                    Agronet.Product.Framework.Data.DataDTOProvider.ProductUpdateStatusByWhere(strTemp, mState, muser.LoginID);
                }
                else
                ...{
                    Agronet.Product.Framework.Data.DataDTOProvider.ProductUpdateRecommendStatusByWhere(strTemp, mState, muser.LoginID);
                }
                BindList();
            }
            catch (Exception ex)
            ...{
                Debug(ex.Message, this.ClientID, true);
                return;
            }
            #endregion
        }

        #endregion
        #endregion
        #endregion

 

前台html

<script language="JavaScript">...

            <!--
            function CheckAll(val)
              ...{
                for (var i=0;i<document.forms[0].elements.length;i++)
                ...{
                  var e = document.forms[0].elements[i];
                  if(e.Type="checkbox" && e.name!="_ctl2:_ctl0:radioSortDesc")
                  ...{
                e.checked=val;
                  }
                }
              }             
            //-->

</script>
<table width="95%" border="0" cellpadding="0" cellspacing="0" align="center">
    <tr>
        <td height="25" align="right" bgcolor="#EFEFEF" class="tab_font_right">
            <strong>产品搜索</strong>：
            <asp:TextBox ID="txtSearchTxt" runat="server" />
            <asp:Button ID="btnSearch" runat="server" Text="搜索"></asp:Button>
            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;转到
            <asp:DropDownList ID="ddlType" runat="server" CssClass="maintext" AutoPostBack="True">
                <asp:ListItem Value="10000">所有产品</asp:ListItem>
                <asp:ListItem Value="2">已推荐</asp:ListItem>
                <asp:ListItem Value="1">当前发布</asp:ListItem>
                <asp:ListItem Value="0">等待审核</asp:ListItem>
                <asp:ListItem Value="-1">未通过审核</asp:ListItem>
                <asp:ListItem Value="-2">未发布</asp:ListItem>
            </asp:DropDownList>
        </td>
    </tr>
</table>
<table width="95%" border="0" align="center" cellpadding="0" cellspacing="1">
    <tr>
        <td>
            <asp:GridView ID="GVList" runat="server" ShowFooter="true" AutoGenerateColumns="False"
                BorderStyle="Solid" BorderColor="#ffffff" GridLines="Horizontal" CellSpacing="1"
                Width="100%" HorizontalAlign="NotSet" BorderWidth="0px" EnableViewState="true"
                DataKeyNames="P_ID">
                <HeaderStyle CssClass="InfoHeaderText" ForeColor="#000000" HorizontalAlign="center"
                    Height="22px" />
                <AlternatingRowStyle BackColor="#f7f7f7" />
                <RowStyle HorizontalAlign="center" Height="20px" BackColor="#E3EAEB" />
                <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
                <Columns>
                    <asp:TemplateField>
                        <HeaderStyle Width="60px" BackColor="#1C5E55" ForeColor="White" />
                        <HeaderTemplate>
                            编号</HeaderTemplate>
                        <ItemTemplate>
                            <asp:Label ID="PKID" Text='<%# DataBinder.Eval(Container.DataItem,"P_ID")%>' runat="server" />
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField Visible="False">
                        <HeaderTemplate>
                            <asp:Label ID="Image_Head" runat="server" Text="产品图片" />
                        </HeaderTemplate>
                        <HeaderStyle Width="120" />
                        <ItemTemplate>
                            <asp:HyperLink ID="P_SmallImage" runat="server" />
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField>
                        <HeaderTemplate>
                            &nbsp; 产品名称</HeaderTemplate>
                        <ItemStyle HorizontalAlign="left" />
                        <HeaderStyle HorizontalAlign="Left" />
                        <ItemTemplate>
                            &nbsp;·<asp:Label ID="P_Name" Text='<%# DataBinder.Eval(Container.DataItem,"P_Name")%>'
                                runat="Server" /><img src='<%# "/Resource/images/Check"+DataBinder.Eval(Container, "DataItem.CurState")+".gif" %>' /></ItemTemplate>
                    </asp:TemplateField>
                    <asp:BoundField DataField="ModTime" HeaderText="修改时间" DataFormatString="{0:yyyy-MM-dd HH:mm}"
                        HtmlEncode="false" />
                    <asp:BoundField DataField="ModUser" HeaderText="修改者" />
                    <asp:TemplateField>
                        <HeaderTemplate>
                            状态</HeaderTemplate>
                        <ItemTemplate>
                            <asp:Label ID="CurState" Text='<%# GetCurStateByID(DataBinder.Eval(Container.DataItem,"CurState"))%>'
                                runat="Server" />
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField>
                        <HeaderStyle Width="60px" />
                        <HeaderTemplate>
                            编辑</HeaderTemplate>
                        <ItemTemplate>
                            <asp:HyperLink ID="cmdMod" CssClass="ElementNavigation" Text="编辑" runat="server" />
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField>
                        <HeaderStyle Width="60px" />
                        <HeaderTemplate>
                            更新</HeaderTemplate>
                        <ItemTemplate>
                            <asp:LinkButton ID="cmdUpdate" CommandName="Update" CssClass="ElementNavigation" Text="快速更新" runat="server"  OnClientClick="return confirm('您确认快速更新该记录吗?');"/>
                        </ItemTemplate>
                    </asp:TemplateField>
                    <asp:TemplateField>
                        <HeaderStyle Width="40px" />
                        <HeaderTemplate>
                            <input type="checkbox" name="allbox" value="Check All" onclick="CheckAll(allbox.checked);" />
                        </HeaderTemplate>
                        <ItemTemplate>
                            <asp:CheckBox ID="chkDelServer" runat="server" />
                        </ItemTemplate>
                    </asp:TemplateField>
                </Columns>
            </asp:GridView>
        </td>
    </tr>
    <tr>
        <td align="right">
            <asp:HyperLink ID="cmdAdd" ForeColor="Red" Text="新增" CssClass="ElementNavigation"
                runat="server" />
            &nbsp;&nbsp;<asp:LinkButton ID="cmdRecommend" runat="server" CssClass="ElementNavigation"
                Text="推荐" CommandName="ReCommend" CausesValidation="false" OnClientClick="javascript:return confirm('确定推荐或(取消推荐)已选择的数据吗？')"></asp:LinkButton>
            &nbsp;&nbsp;<asp:LinkButton ID="cmdUnPublish" runat="server" CssClass="ElementNavigation"
                Text="取消发布" CommandName="UnPublish" CausesValidation="false" OnClientClick="javascript:return confirm('确定取消发布已选择的数据吗？')"></asp:LinkButton>
            &nbsp;&nbsp;<asp:LinkButton ID="cmdDel" ForeColor="Red" Text="删除" CssClass="ElementNavigation"
                CausesValidation="false" runat="server" CommandName="Delete" OnClientClick="javascript:return confirm('确定删除已选择的数据吗？')" />
        </td>
    </tr>
    <tr>
        <td>
            <Agronet:Pager ID="pager" runat="server" CssClass="Pager" LinkFormatActive='<a href="{0}" class="Current">{1}</a>'
                PrefixText="页码:" UseSpacer="False" />
        </td>
    </tr>
</table>

值处注意的是：
必须添加这个事件，即使它什么也不干

 private void GVList_RowUpdating(object sender, GridViewUpdateEventArgs e)
        ...{
            //BindList();
        }

否则会提示“未处理的RowUpdating事件”

Trackback: http://tb.blog.csdn.net/TrackBack.aspx?PostId=1935654