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" >                                                                                                                     <%# this.GridView1.PageIndex * this.GridView1.PageSize + this.GridView1.Rows.Count + 1%>                                                                                                                                                             <%----%>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       Text="更新">                                                             Text="取消">                                                                                                             Text="编辑" OnClientClick="return confirm('确认要编辑吗？');">                                                                                     Text="删除" OnClientClick="return confirm('确认要删除吗？');">                                                             Text="选择">                                                                                                                       ///     /// 绑定数据到GridView     ///     private void GridViewBind()     {         检索数据库         string strSql = "SELECT * FROM DB1";         得到数据集         this.GridView1.DataSource=conn.GetDs(strSql).Tables[0].DefaultView;         this.GridView1.DataBind();        }     ///     /// 编辑当前行     ///     ///     ///     protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)     {         GridView1.EditIndex = e.NewEditIndex;         //当前编辑行背景色高亮         this.GridView1.EditRowStyle.BackColor = Color.FromName("#F7CE90");         GridViewBind();     }     ///     /// 取消编辑状态     ///     ///     ///     protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)     {         GridView1.EditIndex = -1;         GridViewBind();     }     ///     /// 删除记录过程     ///     ///     ///     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();         }

    }     ///     /// 更新记录过程     ///     ///     ///     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("");         //返回浏览状态         GridView1.EditIndex = -1;         GridViewBind();     }     ///     /// 分页事件     ///     ///     ///     protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)     {         GridView1.PageIndex = e.NewPageIndex;         GridViewBind();     }     ///     /// 加入鼠标效果及为DropDownList绑定值     ///     ///     ///     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';");         }     }

该文章转载自网络大本营：http://www.xrss.cn/Info/12969.Html