注册 登录  
 加关注
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

一车,一房,一个温暖家

10万左右的车,80平方的房子,这是我奋斗的暖暖的家

 
 
 

日志

 
 

引用 含有DropDownList的GridView编辑、删除的完整例子   

2015-06-20 19:50:32|  分类: 默认分类 |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" PageSize="10"
                        Width="542px" AllowPaging="True" AllowSorting="True"
                         DataKeyNames="DB31_1,DB31_2" OnRowCancelingEdit="GridView1_RowCancelingEdit" OnRowDeleting="GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating" OnPageIndexChanging="GridView1_PageIndexChanging" OnRowDataBound="GridView1_RowDataBound" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" OnSorting="GridView1_Sorting" >
                        <Columns>
                            <asp:TemplateField HeaderText="序号">
                                <ItemTemplate>
                                <%# this.GridView1.PageIndex * this.GridView1.PageSize + this.GridView1.Rows.Count + 1%>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="学历代码" SortExpression="DB1_1">
                                <EditItemTemplate>
                                    <%--<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("DB1_1") %>'></asp:TextBox>--%>
                               <asp:DropDownList ID ="ddlXL" runat="server"  DataValueField='<%# Bind("DB1_1") %>'></asp:DropDownList>
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="Label1" runat="server" Text='<%# Bind("xueliText") %>'></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="学历名称" SortExpression="DB1_2">
                                <EditItemTemplate>
                                    <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("DB1_2") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="Label2" runat="server" Text='<%# Bind("DB1_2") %>'></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>
                         
                        <asp:TemplateField HeaderText="操作" ShowHeader="False">
                        <EditItemTemplate>
                            <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="True" CommandName="Update"
                                 Text="更新"></asp:LinkButton>
                            <asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" CommandName="Cancel"
                                Text="取消"></asp:LinkButton>
                        </EditItemTemplate>
                        <ItemTemplate>
                            <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Edit"
                                Text="编辑" OnClientClick="return confirm('确认要编辑吗?');"></asp:LinkButton>
                       
                            <asp:LinkButton ID="LinkButton3" runat="server" CausesValidation="False" CommandName="Delete"
                                Text="删除" OnClientClick="return confirm('确认要删除吗?');"></asp:LinkButton>
                            <asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" CommandName="Select"
                                Text="选择"></asp:LinkButton>
                        </ItemTemplate>
                        </asp:TemplateField>
                       </Columns>
                       <AlternatingRowStyle BackColor="Aquamarine" />
                    </asp:GridView>
    /// <summary>
    /// 绑定数据到GridView
    /// </summary>
    private void GridViewBind()
    {
        检索数据库
        string strSql = "SELECT * FROM DB1";
        得到数据集
        this.GridView1.DataSource=conn.GetDs(strSql).Tables[0].DefaultView;
        this.GridView1.DataBind();
  
    }
    /// <summary>
    /// 编辑当前行
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex;
        //当前编辑行背景色高亮
        this.GridView1.EditRowStyle.BackColor = Color.FromName("#F7CE90");
        GridViewBind();
    }
    /// <summary>
    /// 取消编辑状态
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        GridViewBind();
    }
    /// <summary>
    /// 删除记录过程
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        //得到单位编号
        string rowToDelete = GridView1.DataKeys[e.RowIndex].Values[0].ToString();
        //转换为整数
        //int ID=Convert.ToInt32(rowToDelete);
        //从数据库中删除
        string str = "DELETE FROM DB1 where DB1_1=" + "'" + rowToDelete + "'" + "";
      
        try
        {
        conn.RunSql(str);
        //重新绑定数据
        GridViewBind();
        }
        catch (Exception ex)
        {
        Response.Write("数据库错误,错误原因:" + ex.Message);
        Response.End();
        }

    }
    /// <summary>
    /// 更新记录过程
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        string ID = GridView1.DataKeys[e.RowIndex].Values[0].ToString();
        string DB1_1 = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox1")).Text;
        //string DB1_2 = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox2")).Text;
        string DB1_2 = (((DropDownList))GridView1.Rows[e.RowIndex].FindControl("ddlXL")).SelectedItem.Text;
       
    //判断表单项是否有空并给出提示信息
        if (DB1_1 == "" || DB1_2 == "")
        {
            conn.Alert("请输入完整信息!", Page);
            return;
        }            
       try
       {
        conn.BuilderEdit("select * from DB1 where DB1_1 ='" + ID + "'");
        conn.dr["DB1_1"] = DB1_1;
        conn.dr["DB1_2"] = DB1_2;
        conn.BuilderEditClose();
       }
       catch (OracleException err)
       {
            if (err.Code.ToString() == "1")
                conn.Alert("错误:已存在具有相同主键的记录", Page);
            else
                conn.Alert("错误:未能添加记录", Page);
        }

        Response.Write("<script language='javascript'>alert('数据已被保存!');</script>");
        //返回浏览状态
        GridView1.EditIndex = -1;
        GridViewBind();
    }
    /// <summary>
    /// 分页事件
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        GridViewBind();
    }
    /// <summary>
    /// 加入鼠标效果及为DropDownList绑定值
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        //为DropDownList绑定值
        if (((DropDownList)e.Row.FindControl("ddlXL")) != null)
        {
            DropDownList ddlXL = (DropDownList)e.Row.FindControl("ddlXL");
            ddlXL.Items.Clear();
            ddlXL.Items.Add(new ListItem("博士", "1"));
            ddlXL.Items.Add(new ListItem("硕士", "2"));
            ddlXL.Items.Add(new ListItem("学士", "3"));
        }

        //加入鼠标滑过的高亮效果
        if (e.Row.RowType == DataControlRowType.DataRow)//判定当前的行是否属于datarow类型的行
        {
            //当鼠标放上去的时候 先保存当前行的背景颜色 并给附一颜色
            e.Row.Attributes.Add("onmouseover", "currentcolor=this.style.backgroundColor;this.style.backgroundColor='yellow',this.style.fontWeight='';");
            //当鼠标离开的时候 将背景颜色还原的以前的颜色
            e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=currentcolor,this.style.fontWeight='';");
        }
        //单击行改变行背景颜色
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            e.Row.Attributes.Add("onclick", "this.style.backgroundColor='#99cc00'; this.style.color='buttontext';this.style.cursor='default';");
        }
    }

  评论这张
 
阅读(4)| 评论(0)
推荐 转载

历史上的今天

在LOFTER的更多文章

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2018