ASP.NET2.0下含有DropDownList的GridView编辑、删除的完整例子！

 

< 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';");
        } 
    }