asp.net中GridView编辑,更新,合计用法示例

本文实例讲述了asp.net中GridView编辑,更新,合计用法。分享给大家供大家参考，具体如下：

前台代码:

  
  
    
      
      
    
    
      
 '>
      
      
      
 
      
      
    
    
      
 '>
      
      
      
 
      
      
    
    
      
 '>
  ' />
  ' />
  ' />
  ' />
      
      
      
 
      
      
    
    
      
 '>
      
      
  '
   Style="text-align: right" Width="100px"
   onKeyPress="if (event.keyCode!=46 && event.keyCode!=45 && (event.keyCode<48 || event.keyCode>57)) event.returnValue=false">
      
      
      
 
      
      
    
    
      
 '>
      
      
  '
   Style="text-align: right" Width="100px"
    onKeyPress="if (event.keyCode!=46 && event.keyCode!=45 && (event.keyCode<48 || event.keyCode>57)) event.returnValue=false">
      
      
      
 
      
      
    
    
      
  '>
      
      
  ' Width="100px">
      
      
    
    
      
 
 
      
      
 '
   Text='<%#eval("childFlag").ToString()== "0" ? "锁定":"编辑"%>'>
      
      
    
  

注意:

1、通过设置 Readonly="True" 表示此列不可以编辑;
2、通过Text='<%# Bind("tzhysMoney", "{0:N2}") %>'进行金额格式化;
3、重点的编辑显示合计

  
    '>
  
  
     '
      Style="text-align: right" Width="100px"
>
  
  
  
    
  
  

后台代码:

行绑定时的操作:

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
    GridViewRow gr = e.Row;
    if (gr.RowType == DataControlRowType.DataRow)
    {
      HiddenField hdnysYear = (HiddenField)e.Row.FindControl("hdnysYear");
      HiddenField hdngsHkrno = (HiddenField)e.Row.FindControl("hdngsHkrno");
      HiddenField hdnChildFlag = (HiddenField)e.Row.FindControl("hdnChildFlag");
      Hyperlink hy = (Hyperlink)e.Row.FindControl("Hyp_gsName");
      if (hdnChildFlag.Value!="1")
      {
      //设置连接地址参数
 hy.NavigateUrl = "ys_edit_right.aspx?gsHkrno=" + hdngsHkrno.Value + "&sysObjNo=" + sysObjNo + "&ysYear=" + hdnysYear.Value;
 hy.Font.Underline = true;
 hy.ForeColor = System.Drawing.Color.Blue;
 hy.Target = "mainframe";
      }
      else
      {
 hy.ForeColor = System.Drawing.Color.Black;
      }
      //计算合计
      Label labgsMoney = (Label)(e.Row.FindControl("labgsMoney"));
      if (labgsMoney != null || labgsMoney.Text != "")
      {
 gsMoneytotal += Convert.ToDecimal(labgsMoney.Text);
      }
      Label labkgzsndwcGsMoney = (Label)(e.Row.FindControl("labkgzsndwcGsMoney"));
      if (labkgzsndwcGsMoney != null || labkgzsndwcGsMoney.Text != "")
      {
 footMoneytotal += Convert.ToDecimal(labkgzsndwcGsMoney.Text);
      }
      //编辑状态时,不然点击编辑时会出错,找不到控件
      if ((e.Row.RowState & DataControlRowState.Edit) == DataControlRowState.Edit)
      {
 TextBox txttzqysMoney = (TextBox)(e.Row.FindControl("txttzqysMoney"));
 if (txttzqysMoney != null || txttzqysMoney.Text != "")
 {
   tzqysMoneytotal += Convert.ToDecimal(txttzqysMoney.Text);
 }
 TextBox txttzhysMoney = (TextBox)(e.Row.FindControl("txttzhysMoney"));
 if (txttzhysMoney != null || txttzhysMoney.Text != "")
 {
   tzhysMoneytotal += Convert.ToDecimal(txttzhysMoney.Text);
 }
      }
      else //非编辑状态时
      {
 Label labtzqysMoney = (Label)(e.Row.FindControl("labtzqysMoney"));
 if (labtzqysMoney != null || labtzqysMoney.Text != "")
 {
   tzqysMoneytotal += Convert.ToDecimal(labtzqysMoney.Text);
 }
 Label labtzhysMoney = (Label)(e.Row.FindControl("labtzhysMoney"));
 if (labtzhysMoney != null || labtzhysMoney.Text != "")
 {
   tzhysMoneytotal += Convert.ToDecimal(labtzhysMoney.Text);
 }
      }
    }
}
//取消编辑
protected void tabgv_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
    tabgv.EditIndex = -1;
    string strysYear = (Convert.ToInt32(ysYear) - 1).ToString();
    GvDataBind(gsHkrno, "0002", ysYear, "1900-01-01 00:00:00", strysYear + "-12-25 00:00:00");
}
//编辑
protected void tabgv_RowEditing(object sender, GridViewEditEventArgs e)
{
      tabgv.EditIndex = e.NewEditIndex;
      string strysYear = (Convert.ToInt32(ysYear) - 1).ToString();
      GvDataBind(gsHkrno, "0002", ysYear, "1900-01-01 00:00:00", strysYear + "-12-25 00:00:00");
}
//更新
protected void tabgv_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
    string sqlstr = "update ys_ysitem_list set tzqysMoney=@tzqysMoney,tzhysMoney=@tzhysMoney,remark=@remark where ysId=@ysId";
    SqlParameter[] para ={new SqlParameter("@tzqysMoney",SqlDbType.VarChar),
    new SqlParameter("@tzhysMoney",SqlDbType.VarChar),
    new SqlParameter("@remark",SqlDbType.VarChar),
    new SqlParameter("@ysId",SqlDbType.VarChar)
    };
    para[0].Value = ((TextBox)(tabgv.Rows[e.RowIndex].FindControl("txttzqysMoney"))).Text.ToString().Trim();
    para[1].Value = ((TextBox)(tabgv.Rows[e.RowIndex].FindControl("txttzhysMoney"))).Text.ToString().Trim();
    para[2].Value = ((TextBox)(tabgv.Rows[e.RowIndex].FindControl("txtremark"))).Text.ToString().Trim();
    para[3].Value = tabgv.DataKeys[e.RowIndex].Value.ToString();
    pms.SqlHelper.ExecuteNonQuery(CommandType.Text, sqlstr, para);
    tabgv.EditIndex = -1;
    string strysYear = (Convert.ToInt32(ysYear) - 1).ToString();
    GvDataBind(gsHkrno, "0002", ysYear, "1900-01-01 00:00:00", strysYear + "-12-25 00:00:00");
}

更多关于asp.net相关内容感兴趣的读者可查看本站专题：《asp.net操作json技巧总结》、《asp.net字符串操作技巧汇总》、《asp.net操作XML技巧总结》、《asp.net文件操作技巧汇总》、《asp.net ajax技巧总结专题》及《asp.net缓存操作技巧总结》。

希望本文所述对大家asp.net程序设计有所帮助。