GridView和下拉菜单DropDownList结合.doc

刚刚把那个程序编出来呵呵，写一下 语言表达能力不强，看代码就ok了先来看看效果图：更新前：点击编辑后（专业那一列出现数据绑定的DropDownList）：点击更新后保存了结果（注意对比第一张政治经济学原理那一行的所属专业）：晕宿舍要断点了明天把代码贴出来前台代码：（主要是GridView控件的代码）asp:LabelID=Label1runat=serverText=asp:DropDownListID=DropDownList2runat=serverDataSource=DataTextField=NameDataValueField=ID后台代码：usingSystem;usingSystem.Collections;usingSystem.Configuration;usingSystem.Data;usingSystem.Web;usingSystem.Web.Security;usingSystem.Web.UI;usingSystem.Web.UI.HtmlControls;usingSystem.Web.UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Data.SqlClient;publicpartialclassAdmin_kecheng_xinxi:System.Web.UI.PageBassClassbc=newBassClass();protectedvoidPage_Load(objectsender,EventArgse)if(!IsPostBack)Bind();privatevoidBind()GridView1.DataSource=bc.GetDataSet(Select*Fromkecheng_zhuanye_viewORDERBYIDDESC,kecheng_zhuanye_view);GridView1.DataKeyNames=newStringID;GridView1.DataBind();publicDataSetddlBind()SqlConnectionconn=bc.getCon();conn.Open();SqlDataAdapteradq=newSqlDataAdapter(select*fromtb_Profession,conn);DataSetdataset=newDataSet();adq.Fill(dataset,tb_Profession);conn.Close();returndataset;protectedvoidButton1_Click(objectsender,EventArgse)protectedvoidGridView1_RowUpdating(objectsender,GridViewUpdateEventArgse)stringName=(TextBox)GridView1.Rowse.RowIndex.Cells0.Controls0).Text.ToString().Trim();DropDownListddl=(DropDownList)GridView1.Rowse.RowIndex.FindControl(DropDownList2);intofProfession=Convert.ToInt32(ddl.SelectedValue);boolbl=bc.ExecSQL(updatetb_LessonsetName=+Name+,ofProfession=+ofProfession+whereID=+GridView1.DataKeyse.RowIndex.Value.ToString()+);if(bl)Response.Write(bc.messageBox(更新成功！);elseResponse.Write(bc.messageBox(更新失败！);GridView1.EditIndex=-1;Bind();protectedvoidGridView1_RowEditing(objectsender,GridViewEditEventArgse)GridView1.EditIndex=e.NewEditIndex;Bind();protectedvoidGridView1_RowDeleting(objectsender,GridViewDeleteEventArgse)boolbl=bc.ExecSQL(deletefromtb_lessonwhereID=+GridView1.DataKeyse.RowIndex+);if(bl)Response.Write(bc.messageBox(删除成功！);elseResponse.Write(bc.messageBox(删除失败！);protectedvoidGridView1_RowCancelingEdit(objectsender,GridViewCancelEditEventArgse)GridView1.EditIndex=-1;Bind();protect