手动绑定数据到DatList并实现编辑删除取消···

1、效果图：前台代码： 无标题页.style1width:600px;.style3width:150px;学号：asp:TextBoxID=TextBox1runat=serverText=姓名：asp:TextBoxID=TextBox2runat=serverText=性别：asp:TextBoxID=TextBox3runat=serverText=年龄：asp:TextBoxID=TextBox4runat=serverText=专业：asp:TextBoxID=TextBox5runat=serverText=班级：asp:TextBoxID=TextBox6runat=serverT

2、ext=保存取消学生基本情况学号：姓名：性别：年龄：专业：班级：修改删除后台代码：usingSystem;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;publicpartialc

3、lass_Default:System.Web.UI.PageprotectedvoidPage_Load(objectsender,EventArgse)if(!IsPostBack)Bind();privatevoidBind()SqlConnectionconn=newSqlConnection(ConfigurationManager.ConnectionStringsPersonal.ConnectionString);SqlDataAdapteradp=newSqlDataAdapter(select*frominformation,conn);DataSetdataset=new

4、DataSet();conn.Open();tryadp.Fill(dataset,information);DataList1.DataSource=dataset;DataList1.DataKeyField=id;DataList1.DataBind();catch(Exceptionerro)Response.Write(错误+erro);finallyconn.Close();protectedvoidDataList1_CancelCommand(objectsource,DataListCommandEventArgse)DataList1.EditItemIndex=-1;Bi

5、nd();protectedvoidDataList1_DeleteCommand(objectsource,DataListCommandEventArgse)SqlConnectionconn=newSqlConnection(ConfigurationManager.ConnectionStringsPersonal.ConnectionString);SqlCommandcomm=newSqlCommand(deletefrominformationwhereid=+DataList1.DataKeyse.Item.ItemIndex+,conn);conn.Open();inti=C

6、onvert.ToInt32(comm.ExecuteNonQuery();if(i0)Response.Write(returnalert(删除成功);DataList1.EditItemIndex=-1;Bind();elseResponse.Write(returnalert(删出失败);conn.Close();protectedvoidDataList1_EditCommand(objectsource,DataListCommandEventArgse)DataList1.EditItemIndex=e.Item.ItemIndex;Bind();protectedvoidData

7、List1_UpdateCommand(objectsource,DataListCommandEventArgse)stringID=DataList1.DataKeyse.Item.ItemIndex.ToString();stringid=(TextBox)e.Item.FindControl(TextBox1).Text;stringname=(TextBox)e.Item.FindControl(TextBox2).Text;stringsex=(TextBox)e.Item.FindControl(TextBox3).Text;stringage=(TextBox)e.Item.F

8、indControl(TextBox4).Text;stringdepartment=(TextBox)e.Item.FindControl(TextBox5).Text;stringgrade=(TextBox)e.Item.FindControl(TextBox6).Text;SqlConnectionconn=newSqlConnection(ConfigurationManager.ConnectionStringsPersonal.ConnectionString);SqlCommandcomm=newSqlCommand(updateinformationsetid=+id+,name=+name+,sex=+sex+,age=+age+,department=+department+,grade=+grade+whereid=+ID+,conn);conn.Open();tryinti=Convert.ToInt32(comm.ExecuteNonQuery();if(i0)Response.Write(alert(保存成功！);elseResponse.Write(alert(保存失败！);DataList1.EditItemIndex=-1;Bind();catch(Exce