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

最新推荐文章于 2021-08-05 15:26:52 发布
最新推荐文章于 2021-08-05 15:26:52 发布
阅读量123 收藏
点赞数
文章标签： javascript ViewUI

后台代码段

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

 protected Agronet.Common.Framework.Util.Pagerpager;
 protected TextBoxtxtSearchTxt;
 protected ButtonbtnSearch;
 protected HyperLinkcmdAdd;
 protected LinkButtoncmdDel;
 protected LinkButtoncmdRecommend;
 protected LinkButtoncmdUnPublish;
 protected TextBoxtxtWords;
 protected DropDownListddlType;
 protected LabelTradeTypeID;
 protected LabelNoResult;
 private int _page = 1 ;
 public int _sort = 0 ;
 /**/ /// <summary>
/// 关键字
 /// downmoon2007年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(EventArgse)
 ... {
 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,EventArgse)
 ... {
 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,EventArgse)
 ... {
 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,EventArgse)
 ... {
 执行批量操作 #region 执行批量操作
UpdateMultiRecordsByWhere(pager.PageSize, - 4 , 1 );
 #endregion
}
private void cmdUnPublish_Click( object sender,EventArgse)
 ... {
 执行批量操作 #region 执行批量操作
UpdateMultiRecordsByWhere(pager.PageSize, - 2 , 1 );
 #endregion ;
}
private void GVList_RowCommand( object sender,GridViewCommandEventArgse)
 ... {
 执行批量操作 #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);
 // GridViewa=(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 (Exceptionex)
 ... {
 return ;
}
}
#endregion
}
private void GVList_RowUpdating( object sender,GridViewUpdateEventArgse)
 ... {
 // BindList();
}
private void cmdRecommend_Click( object sender,EventArgse)
 ... {
 执行批量操作 #region 执行批量操作
UpdateMultiRecordsByWhere(pager.PageSize, 1 , 2 );
 #endregion

}
protected void GVList_RowDataBound( object sender,GridViewRowEventArgse)
 ... {
 if (e.Row.RowType == DataControlRowType.DataRow)
 ... {
HyperLinkcmdMod = (HyperLink)e.Row.FindControl( " cmdMod " );
 if (cmdMod != null ) ... {cmdMod.NavigateUrl = PreUrl + " Modify.aspx?dvid=2&PKID= " + DataBinder.Eval(e.Row.DataItem, " P_ID " );}
LinkButtonlbUpdate = (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.ProductCollectionsc = 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 = " 无符合条件的记录! " ;
}

}
MultipleRecordUpdateMethod #region MultipleRecordUpdateMethod
private void UpdateMultiRecordsByWhere( int mCount, short mState, short updateType)
 ... {
 Check #region Check
CheckSiteUser();
 #endregion
执行批量操作 #region 执行批量操作
try
... {
StringBuildersb = 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 ++ )
 ... {
CheckBoxchk = (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 (Exceptionex)
 ... {
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-ddHH: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 ="returnconfirm('您确认快速更新该记录吗?');" />
</ ItemTemplate >
</ asp:TemplateField >
< asp:TemplateField >
< HeaderStyle Width ="40px" />
< HeaderTemplate >
< input type ="checkbox" name ="allbox" value ="CheckAll" 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:returnconfirm('确定推荐或(取消推荐)已选择的数据吗？')" ></ asp:LinkButton >
&nbsp;&nbsp; < asp:LinkButton ID ="cmdUnPublish" runat ="server" CssClass ="ElementNavigation"
Text ="取消发布" CommandName ="UnPublish" CausesValidation ="false" OnClientClick ="javascript:returnconfirm('确定取消发布已选择的数据吗？')" ></ asp:LinkButton >
&nbsp;&nbsp; < asp:LinkButton ID ="cmdDel" ForeColor ="Red" Text ="删除" CssClass ="ElementNavigation"
CausesValidation ="false" runat ="server" CommandName ="Delete" OnClientClick ="javascript:returnconfirm('确定删除已选择的数据吗？')" />
</ 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,GridViewUpdateEventArgse)
 ... {
 // BindList();
}


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

iteye_20474
关注
在ASP.NET 2.0中操作数据之六十二：GridView批量更新数据
10-22
GridView控件内置的编辑功能只能对每行进行编辑，做不到批量编辑。为此，我们需要将GridView里的列转换为TemplateFields，通过一个单独的“Update All”按钮，在按钮的事件中批量处理每一行。
在ASP.NET 2.0中操作数据之六十四：GridView批量添加数据
01-03
导言： 　　在前面的第62章《GridView批量更新数据》里，我们用GridView控件里定制了一个批编辑界面，同样的我们也可以定制一个批添加界面.假设有这种情况，我们接受一批从Tokyo(东京)发过来的货物：6种不同的tea 和 coffee，如果用户在一个DetailsView控件里一次输入一个产品，他将会重复的输入很多相同的值，比如相同的种类(Beverages),相同的供应商(Tokyo Traders),相同的discontinued值(False),以及相同的order值(0).重复性的输入这些相同的值不仅累，还很容易出错.只需额外多做一些工作，我们就可以创建一个批添加界面。用户
ASP.NET DEMO 16: 通过GridView布局实现的多行批量更新
weixin_33834910的博客
05-22 183
  特点： 一次可批量提交多行数据 客户端由CheckBox实现切换浏览/编辑状态，不需要回发 服务器端实现维护编辑状态视图 源码下载  &lt;%@ Page Language="C#" %&gt; &lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtm...
GridView动态新增行 删除行 适合多数据批量修改保存 新增数据验证
diehe5608的博客
11-27 161
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Demo.aspx.cs" Inherits="Demo" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/...
GridView的批量更新
风过无声
12-14 893
摘自：http://topic.youkuaiyun.com/t/20061219/15/5241441.html GridView多行编辑
GridView控件批量更新
a683712的博客
07-23 157
GridView控件批量更新CS代码: protected void ButtontBatchPrice_Click(object sender, EventArgs e) { CheckBox cb=new CheckBox(); for (int i = 0; i < GridView1.Rows.Count;i++ ) {...
Gridview批量修改
zyaccp30的专栏
09-15 1660
<br />前台代码：<br /><head runat="server"><br />    <title>无标题页</title><br /></head><br /><body><br />    <form id="form1" runat="server"><br />    <div><br />    <br />    </div><br />    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
GridView布局实现的多行批量更新
流程管理软件
05-22 629
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">http://topic.youkuaiyun.com/u/20080521/15/a2da7051-4c1b-490d-ab28-1f01323aba47.html?seed=1952824859 --%>void ShowProductData(GridView grid){DataTable
批量处理GridView中的数据
weixin_30315723的博客
06-15 98
页面代码 <asp:GridView ID="gvw_Task" runat="server" AutoGenerateColumns="False" Width="772px"> <Columns> <asp:Template...
Yii2 GridView实现列表页直接修改数据的方法
10-22
主要介绍了Yii2 GridView实现列表页直接修改数据的方法的相关资料，小编认为非常具有参考价值，特此分享到脚本之家平台,需要的朋友可以参考下
SQL快速操作技巧2_datatable批量更新到数据表
weixin_30527423的博客
06-20 271
(为了给您节省时间，您可以只看高亮部分内容) 要将datatable 批量更新到数据表其实是两步： （1）将datatable快速存入一个表中； （2）根据一个数据表更新另外一个数据表； 下面细说： （1）将datatable快速存入一个表中； 1)insert循环插入；2)sqldataadapter.update(dataset,tablename);3)sqlb...
如何在GridView中一次性批量更新多行数据
aadjseb4024的博客
11-17 235
假定有一个Product表，字段有（Id,Name,Quantity,...）我们要一次批量更新Quantity的值 首先在Gridview中，Quantity列以TemplateField显示，其他的列属性设为只读，把显示格式设为TextBox<asp:TemplateField HeaderText="Quantity"> <ItemTemplate...
ajax异步刷新gridview,如何刷新Gridview的内容(ajax)
weixin_33040687的博客
08-05 507
前台部分:使用 ajax，局部刷新 GridView 进行数据绑定的简单实现function GetData(p) {document.getElementById("d").innerHTML = "正在读取数据……";h = window.XMLHttpRequest ? new window.XMLHttpRequest() : new ActiveXObject("MSXML2.XMLHT...
gridview添加checkbox批量处理
shenzhenzhao的博客
09-05 533
//初始化表格添加checkbox列，默认值为false（不选中），绑定到gridcontrol private void Form1_Load(object sender, EventArgs e) { DataTable dt = new DataTable("个人简历"); dt.Co...
ASP.NET 2.0 GridView实现批量数据更新教程
在ASP.NET 2.0中，批量更新数据是一个常见的需求，特别是在GridView控件中，用户可能希望同时编辑多行数据并一次性提交到数据库。本文主要讲解如何在GridView中实现批量更新功能，而不是像传统的添加编辑和取消按钮...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值