【转载】gridview修改,添加,删除…

本文介绍了一个ASP.NET应用程序中实现的人员培训记录管理功能,包括如何通过GridView控件进行数据展示、编辑、新增、删除等操作,并详细展示了与Oracle数据库交互的代码实现。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >



    /// <summary>
    
/// 查看按钮
    
/// </summary>
    
/// <param name="sender"></param>
    
/// <param name="e"></param>
    protected void ButtonTianJia_Click(object sender, EventArgs e)
    ...{
        if (this.GridViewXinXiLan.SelectedRow != null)
        ...{
            this.MenuCaidan.Items[1].Enabled true;
            MenuCaidan.Items[1].Selected true;
            MultiViewXinXiGuanLi.ActiveViewIndex 1;

            this.LabelZhuJian.Text this.GridViewXinXiLan.DataKeys[this.GridViewXinXiLan.SelectedRow.RowIndex][0].ToString(); ;

            // 初始化默认Gridview的SQL语句
            String querySql "SELECT ID,建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN FROM peixunjinxiu WHERE  ID='" this.LabelZhuJian.Text.Trim() "'";

            fillGridViewTianJia(querySql);

            ButtonChaKan.Visible true;
            ButtonChaKan.Enabled true;
        }
        else
        ...{
            // 错误信息提示
            String tip "请选择行!";
            Response.Write("<script>alert('" tip "')</script>");
        }
    }


    /// <summary>
    
/// 新增
    
/// </summary>
    
/// <param name="sender"></param>
    
/// <param name="e"></param>
    protected void ButtonXinZen_Click(object sender, EventArgs e)
    ...{
        //ButtonBaoCun.Visible true;
        
//ButtonBaoCun.Enabled true;

        
//ButtonQuXiao.Visible true;
        
//ButtonQuXiao.Enabled true;

        DataSet ds new DataSet();
        // 初始化默认Gridview的SQL语句
        String querySql "SELECT ID,建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN FROM peixunjinxiu WHERE  ID='" this.LabelZhuJian.Text.Trim() "'";

        ds GetData(querySql);
        
        // 清空以前的数据源
        GridViewTianJia.DataSource null;
        String jlrq DateTime.Now.ToString("yyyy-MM-dd", DateTimeFormatInfo.InvariantInfo);
        String sn System.Guid.NewGuid().ToString().Replace("-", "");
        String userName "session";
        ds.Tables[0].Rows.Add(this.LabelZhuJian.Text, jlrq, "姓名", "培训类型", "名称", jlrq, jlrq, "取得证书", "无", userName, sn);
        // 将ds作为信息栏GridView的数据源
        GridViewTianJia.DataSource ds;
        
        // 绑定数据
        GridViewTianJia.DataBind();
        // gridview 换行控制
        this.GridViewTianJia.Attributes.Add("style", "word-break:keep-all;word-wrap:normal");
        // 编辑的更新
        GridViewTianJia.EditIndex GridViewTianJia.Rows.Count 1;
        // 设置编辑行的颜色
        GridViewTianJia.EditRowStyle.BackColor System.Drawing.Color.Orange;
        // 绑定数据
        GridViewTianJia.DataBind();
        GridViewTianJia.Rows[GridViewTianJia.Rows.Count 1].FindControl("LinkButton1").Visible false;
        // 编辑的取消
        GridViewTianJia.Rows[GridViewTianJia.Rows.Count 1].FindControl("LinkButton2").Visible false;
        GridViewTianJia.Rows[GridViewTianJia.Rows.Count 1].FindControl("LinkButtonTianJia").Visible true;
        GridViewTianJia.Rows[GridViewTianJia.Rows.Count 1].FindControl("LinkButton3").Visible false;
        GridViewTianJia.Rows[GridViewTianJia.Rows.Count 1].FindControl("LinkButtonQuXiao").Visible true;
    }

    /// <summary>
    
/// 数据绑定
    
/// </summary>
    
/// <param name="sender"></param>
    
/// <param name="e"></param>
    protected void GridViewTianJia_RowDataBound(object sender, GridViewRowEventArgs e)
    ...{
        //为DropDownList绑定值
        if (((DropDownList)e.Row.FindControl("DropDownListLeiXing")) != null)
        ...{
            DropDownList ddlXL (DropDownList)e.Row.FindControl("DropDownListLeiXing");

            // 奖惩类型
            String conn OracleHelper.DatabaseConnStr;
            ddlXL.Items.Clear();
            String queryLeiXing "SELECT 名称 FROM XITONGZIDIAN WHERE ID='03010301' ORDER BY 序号";
            OracleDataReader drLeiXing OracleHelper.ExecuteReader(conn, CommandType.Text, queryLeiXing, null);
            while (drLeiXing.Read())
            ...{
                ddlXL.Items.Add(drLeiXing.GetString(0).Trim());
            }
            drLeiXing.Close();

            //ddlXL.SelectedValue ((HiddenField)e.Row.FindControl("HDLeiXing")).Value.ToString().Trim();
            ddlXL.Items.Remove(((HiddenField)e.Row.FindControl("HDLeiXing")).Value.ToString().Trim());
            ddlXL.Items.Insert(0, ((HiddenField)e.Row.FindControl("HDLeiXing")).Value.ToString().Trim());
        }
        //如果是绑定数据行 
        if (e.Row.RowType == DataControlRowType.DataRow)
        ...{
            if (e.Row.RowState == DataControlRowState.Normal || e.Row.RowState == DataControlRowState.Alternate)
            ...{
                //((LinkButton)e.Row.Cells[12].Controls[0]).Attributes.Add("onclick", "javascript:return confirm('你确认要删除:"" e.Row.Cells[1].Text.Trim() ""吗?')");
                ((LinkButton)e.Row.FindControl("LinkButton3")).Attributes.Add("onclick", "javascript:return confirm('你确认要删除:"" e.Row.Cells[1].Text.Trim() ""吗?')");
            }
        

    }

    /// <summary>
    
/// 删除
    
/// </summary>
    
/// <param name="sender"></param>
    
/// <param name="e"></param>
    protected void GridViewTianJia_RowDeleting(object sender, GridViewDeleteEventArgs e)
    ...{
        String sn GridViewTianJia.DataKeys[e.RowIndex].Values[0].ToString().Trim();

        String delSql "DELETE FROM peixunjinxiu WHERE SN '" sn "'";

        OracleConnection conn new OracleConnection(OracleHelper.DatabaseConnStr);
        conn.Open();
        OracleTransaction trans conn.BeginTransaction(IsolationLevel.ReadCommitted);

        try
        ...{
            OracleHelper.ExecuteNonQuery(trans, CommandType.Text, delSql, null);
            trans.Commit();
        }
        catch (Exception ex)
        ...{
            trans.Rollback();
            ex.ToString();
        }
        finally
        ...{
            conn.Close();
        }

        GridViewTianJia.EditIndex -1;
        // 初始化默认Gridview的SQL语句
        String querySql "SELECT ID,建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN FROM peixunjinxiu WHERE  ID='" this.LabelZhuJian.Text.Trim() "'";

        fillGridViewTianJia(querySql);
    }

    /// <summary>
    
/// 取消
    
/// </summary>
    
/// <param name="sender"></param>
    
/// <param name="e"></param>
    protected void GridViewTianJia_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    ...{

        GridViewTianJia.EditIndex -1;
        // 初始化默认Gridview的SQL语句
        String querySql "SELECT ID,建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN FROM peixunjinxiu WHERE  ID='" this.LabelZhuJian.Text.Trim() "'";

        fillGridViewTianJia(querySql);
    }

    /// <summary>
    
/// 编辑
    
/// </summary>
    
/// <param name="sender"></param>
    
/// <param name="e"></param>
    protected void GridViewTianJia_RowEditing(object sender, GridViewEditEventArgs e)
    ...{
        GridViewTianJia.EditIndex e.NewEditIndex;

        // 初始化默认Gridview的SQL语句
        String querySql "SELECT ID,建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN FROM peixunjinxiu WHERE  ID='" this.LabelZhuJian.Text.Trim() "'";

        fillGridViewTianJia(querySql);
    }

    /// <summary>
    
/// 更新
    
/// </summary>
    
/// <param name="sender"></param>
    
/// <param name="e"></param>
    protected void GridViewTianJia_RowUpdating(object sender, GridViewUpdateEventArgs e)
    ...{

        // 建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN

        String sqlUpdate "UPDATE peixunjinxiu SET 姓名=:xm,类型=:lx,名称=:mc,开始时间=:kssj,结束时间=:jssj,取得证书=:qdzs,备注=:bz"
                            WHERE SN=:sn";

        OracleParameter[] parms ...{
            new OracleParameter(":xm", OracleType.Char, 20),
            new OracleParameter(":lx", OracleType.Char, 10),
            new OracleParameter(":mc", OracleType.VarChar, 255),
            new OracleParameter(":kssj", OracleType.Char, 10),
            new OracleParameter(":jssj", OracleType.Char, 10),
            new OracleParameter(":qdzs", OracleType.VarChar, 255),
            new OracleParameter(":bz", OracleType.VarChar,1024),
            new OracleParameter(":sn", OracleType.Char, 32)
          };

        parms[0].Value ((TextBox)GridViewTianJia.Rows[e.RowIndex].FindControl("TextBoxXinMing")).Text.Trim();
        parms[1].Value ((DropDownList)GridViewTianJia.Rows[e.RowIndex].FindControl("DropDownListLeiXing")).SelectedValue.ToString().Trim();
        parms[2].Value ((TextBox)GridViewTianJia.Rows[e.RowIndex].FindControl("TextBoxMingCheng")).Text.Trim();
        parms[3].Value ((TextBox)GridViewTianJia.Rows[e.RowIndex].FindControl("TextBoxKaiShiShiJian")).Text.Trim();
        parms[4].Value ((TextBox)GridViewTianJia.Rows[e.RowIndex].FindControl("TextBoxJieShuShiJian")).Text.Trim();
        parms[5].Value ((TextBox)GridViewTianJia.Rows[e.RowIndex].FindControl("TextBoxZhengShu")).Text.Trim();
        parms[6].Value ((TextBox)GridViewTianJia.Rows[e.RowIndex].FindControl("TextBoxBeiZhu")).Text.Trim();
        parms[7].Value  GridViewTianJia.DataKeys[e.RowIndex].Values[0].ToString().Trim();

        OracleConnection conn new OracleConnection(OracleHelper.DatabaseConnStr);
        conn.Open();
        OracleTransaction trans conn.BeginTransaction(IsolationLevel.ReadCommitted);

        try
        ...{
            OracleHelper.ExecuteNonQuery(trans, CommandType.Text, sqlUpdate, parms);
            trans.Commit();
        }
        catch (Exception ex)
        ...{
            trans.Rollback();
            ex.ToString();
        }
        finally
        ...{
            conn.Close();
        }
        GridViewTianJia.EditIndex -1;
        // 初始化默认Gridview的SQL语句
        String querySql "SELECT ID,建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN FROM peixunjinxiu WHERE  ID='" this.LabelZhuJian.Text.Trim() "'";

        fillGridViewTianJia(querySql);
    }

    /// <summary>
    
/// 保存
    
/// </summary>
    
/// <param name="sender"></param>
    
/// <param name="e"></param>
    protected void ButtonBaoCun_Click(object sender, EventArgs e)
    ...{
        // 建立日期,姓名,类型,培训名称,进修名称,开始时间,结束时间,取得证书,备注,经办人,SN
        String sqlInsert "INSERT INTO peixunjinxiu(ID,建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN) "
                            "VALUES(:id,:jlrq,:xm,:lx,:mc,:kssj,:jssj,:qdzs,:bz,:jbr,:sn)";

        OracleParameter[] parms ...{
                new OracleParameter(":id", OracleType.Char, 32),
                new OracleParameter(":jlrq", OracleType.Char, 10),
                new OracleParameter(":xm", OracleType.Char, 20),
                new OracleParameter(":lx", OracleType.Char, 10),
                new OracleParameter(":mc", OracleType.VarChar, 255),
                new OracleParameter(":kssj", OracleType.Char, 10),
                new OracleParameter(":jssj", OracleType.Char, 10),
                new OracleParameter(":qdzs", OracleType.VarChar, 255),
                new OracleParameter(":bz", OracleType.VarChar,1024),
                new OracleParameter(":jbr", OracleType.Char, 20),
                new OracleParameter(":sn", OracleType.Char, 32)
              };
        parms[0].Value this.LabelZhuJian.Text.Trim();
        parms[1].Value this.GridViewTianJia.Rows[GridViewTianJia.Rows.Count 1].Cells[1].Text.ToString().Trim();
        parms[2].Value ((TextBox)GridViewTianJia.Rows[GridViewTianJia.Rows.Count 1].FindControl("TextBoxXinMing")).Text.Trim();
        parms[3].Value ((DropDownList)GridViewTianJia.Rows[GridViewTianJia.Rows.Count 1].FindControl("DropDownListLeiXing")).SelectedValue.ToString().Trim();
        parms[4].Value ((TextBox)GridViewTianJia.Rows[GridViewTianJia.Rows.Count 1].FindControl("TextBoxMingCheng")).Text.Trim();
        parms[5].Value ((TextBox)GridViewTianJia.Rows[GridViewTianJia.Rows.Count 1].FindControl("TextBoxKaiShiShiJian")).Text.Trim();
        parms[6].Value ((TextBox)GridViewTianJia.Rows[GridViewTianJia.Rows.Count 1].FindControl("TextBoxJieShuShiJian")).Text.Trim();
        parms[7].Value ((TextBox)GridViewTianJia.Rows[GridViewTianJia.Rows.Count 1].FindControl("TextBoxZhengShu")).Text.Trim();
        parms[8].Value ((TextBox)GridViewTianJia.Rows[GridViewTianJia.Rows.Count 1].FindControl("TextBoxBeiZhu")).Text.Trim();
        parms[9].Value this.GridViewTianJia.Rows[GridViewTianJia.Rows.Count 1].Cells[9].Text.ToString().Trim();
        parms[10].Value GridViewTianJia.DataKeys[GridViewTianJia.Rows.Count 1].Values[0].ToString().Trim();

        OracleConnection conn new OracleConnection(OracleHelper.DatabaseConnStr);
        conn.Open();
        OracleTransaction trans conn.BeginTransaction(IsolationLevel.ReadCommitted);

        try
        ...{
            OracleHelper.ExecuteNonQuery(trans, CommandType.Text, sqlInsert, parms);
            trans.Commit();
        }
        catch (Exception ex)
        ...{
            trans.Rollback();
            ex.ToString();
        }
        finally
        ...{
            conn.Close();
        }

        GridViewTianJia.EditIndex -1;
        // 初始化默认Gridview的SQL语句
        String querySql "SELECT ID,建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN FROM peixunjinxiu WHERE  ID='" this.LabelZhuJian.Text.Trim() "'";

        fillGridViewTianJia(querySql);

        ButtonBaoCun.Visible false;
        ButtonBaoCun.Enabled false;

        ButtonQuXiao.Visible false;
        ButtonQuXiao.Enabled false;
    }

    /// <summary>
    
/// 取消
    
/// </summary>
    
/// <param name="sender"></param>
    
/// <param name="e"></param>
    protected void ButtonQuXiao_Click(object sender, EventArgs e)
    ...{
        GridViewTianJia.EditIndex -1;
        // 初始化默认Gridview的SQL语句
        String querySql "SELECT ID,建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN FROM peixunjinxiu WHERE  ID='" this.LabelZhuJian.Text.Trim() "'";

        fillGridViewTianJia(querySql);

        ButtonBaoCun.Visible false;
        ButtonBaoCun.Enabled false;

        ButtonQuXiao.Visible false;
        ButtonQuXiao.Enabled false;
    }

    /// <summary>
    
/// 取消
    
/// </summary>
    
/// <param name="sender"></param>
    
/// <param name="e"></param>
    protected void LinkButtonQuXiao_Click(object sender, EventArgs e)
    ...{
        GridViewTianJia.EditIndex -1;
        // 初始化默认Gridview的SQL语句
        String querySql "SELECT ID,建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN FROM peixunjinxiu WHERE  ID='" this.LabelZhuJian.Text.Trim() "'";

        fillGridViewTianJia(querySql);

    }

    /// <summary>
    
/// 添加保存
    
/// </summary>
    
/// <param name="sender"></param>
    
/// <param name="e"></param>
    protected void LinkButtonTianJia_Click(object sender, EventArgs e)
    ...{

        if (Page.IsValid)
        ...{
            //
        }
        // 建立日期,姓名,类型,培训名称,进修名称,开始时间,结束时间,取得证书,备注,经办人,SN
        String sqlInsert "INSERT INTO peixunjinxiu(ID,建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN) "
                            "VALUES(:id,:jlrq,:xm,:lx,:mc,:kssj,:jssj,:qdzs,:bz,:jbr,:sn)";

        OracleParameter[] parms ...{
                new OracleParameter(":id", OracleType.Char, 32),
                new OracleParameter(":jlrq", OracleType.Char, 10),
                new OracleParameter(":xm", OracleType.Char, 20),
                new OracleParameter(":lx", OracleType.Char, 10),
                new OracleParameter(":mc", OracleType.VarChar, 255),
                new OracleParameter(":kssj", OracleType.Char, 10),
                new OracleParameter(":jssj", OracleType.Char, 10),
                new OracleParameter(":qdzs", OracleType.VarChar, 255),
                new OracleParameter(":bz", OracleType.VarChar,1024),
                new OracleParameter(":jbr", OracleType.Char, 20),
                new OracleParameter(":sn", OracleType.Char, 32)
              };

        parms[0].Value this.LabelZhuJian.Text.Trim();
        parms[1].Value this.GridViewTianJia.Rows[GridViewTianJia.Rows.Count 1].Cells[1].Text.ToString().Trim();
        parms[2].Value ((TextBox)GridViewTianJia.Rows[GridViewTianJia.Rows.Count 1].FindControl("TextBoxXinMing")).Text.Trim();
        parms[3].Value ((DropDownList)GridViewTianJia.Rows[GridViewTianJia.Rows.Count 1].FindControl("DropDownListLeiXing")).SelectedValue.ToString().Trim();
        parms[4].Value ((TextBox)GridViewTianJia.Rows[GridViewTianJia.Rows.Count 1].FindControl("TextBoxMingCheng")).Text.Trim();
        parms[5].Value ((TextBox)GridViewTianJia.Rows[GridViewTianJia.Rows.Count 1].FindControl("TextBoxKaiShiShiJian")).Text.Trim();
        parms[6].Value ((TextBox)GridViewTianJia.Rows[GridViewTianJia.Rows.Count 1].FindControl("TextBoxJieShuShiJian")).Text.Trim();
        parms[7].Value ((TextBox)GridViewTianJia.Rows[GridViewTianJia.Rows.Count 1].FindControl("TextBoxZhengShu")).Text.Trim();
        parms[8].Value ((TextBox)GridViewTianJia.Rows[GridViewTianJia.Rows.Count 1].FindControl("TextBoxBeiZhu")).Text.Trim();
        parms[9].Value this.GridViewTianJia.Rows[GridViewTianJia.Rows.Count 1].Cells[9].Text.ToString().Trim();
        parms[10].Value GridViewTianJia.DataKeys[GridViewTianJia.Rows.Count 1].Values[0].ToString().Trim();

        OracleConnection conn new OracleConnection(OracleHelper.DatabaseConnStr);
        conn.Open();
        OracleTransaction trans conn.BeginTransaction(IsolationLevel.ReadCommitted);

        try
        ...{
            OracleHelper.ExecuteNonQuery(trans, CommandType.Text, sqlInsert, parms);
            trans.Commit();
        }
        catch (Exception ex)
        ...{
            trans.Rollback();
            ex.ToString();
        }
        finally
        ...{
            conn.Close();
        }

        GridViewTianJia.EditIndex -1;
        // 初始化默认Gridview的SQL语句
        String querySql "SELECT ID,建立日期,姓名,类型,名称,开始时间,结束时间,取得证书,备注,经办人,SN FROM peixunjinxiu WHERE  ID='" this.LabelZhuJian.Text.Trim() "'";

        fillGridViewTianJia(querySql);
    }

    /// <summary>
    
/// 时间格式验证
    
/// </summary>
    
/// <param name="source"></param>
    
/// <param name="args"></param>
    protected void CVKaiShiShiJian_ServerValidate(object source, ServerValidateEventArgs args)
    ...{
        try
        ...{
            DateTime dt DateTime.Parse(args.Value);
            // 如果长度不为10则不是合法的日期
            if(args.Value.Trim().Length == 10)
            ...{
              
                args.IsValid true;
                return;
            }
        }
        catch (Exception) 
        ...
        }
        args.IsValid false;
    }
 
}

  

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值