GridView事件中获取rowIndex值

其实可以用存储过程来实现.在表中加一个sequence(排序)字段.
CREATE PROCEDURE [dbo].[sp_MoveUp_contactinfo]   --向上移动.向下移动跟这差不多.
(
@pkey bigint 
)
AS
BEGIN
declare @sequence as int
select @sequence = sequence from tb_contact_info where 主键 = @pkey

declare @Dpkey as bigint


select @Dpkey = 主键 from 表名 where  sequence = ( select max(sequence) from  表名 where sequence < @sequence)

if exists(select top 1 sequence from 表名 where  sequence < @sequence) 
begin
update tb_contact_info set sequence = (select top 1 sequence from tb_contact_info as a where a.主键 = @Dpkey) where 主键= @pkey;

update 表名 set sequence = sequence + 1 where 主键 = @Dpkey ;
end
END

在GridView中添加两列模板列.里面放两个按钮.在RowCommand事件中写下面的代码.
C# codestring type = ""; ImageButton btn = e.CommandSource as ImageButton; if (btn.ID == "moveDown") { type = "up"; } if (btn.ID == "moveUp") { type = "down"; } GridViewRow row = btn.NamingContainer as GridViewRow; string pkey = dgv_Membership.DataKeys[row.RowIndex].Value.ToString(); string contenttype = row.Cells[5].Text.Replace(" ", "").Trim(); //这里调用执行存储过程的方法 if (errMsg != "") { Response.Write(clsCommon.Msg("Errors:" + errMsg)); }    //这里再绑定一次.

在RowDataBound事件中写
C# code protected void grvNews_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { if (e.Row.RowIndex == 0) { e.Row.FindControl("moveUp").Visible = false; } if (e.Row.DataItemIndex == (dgv_Membership.DataSource as DataView).Count - 1) { e.Row.FindControl("moveDown").Visible = false; }     } }

转载于:https://www.cnblogs.com/huige1004/archive/2008/10/07/1305742.html

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值