datalist的手写代码更新记录

昨天做"datalist的手写代码更新记录"的时候遇到一个难题:就是运行后更改了数据按了更新按钮,数据还是没有更改,找了一个下午也没能找出那里错了,试过在protected void DataList1_UpdateCommand(object source, DataListCommandEventArgs e)事件的最后一个花括号}处加了一个断点来调试(也就是说在55行加了一个断点),发现string Score =(( TextBox)e.Item.FindControl("TextBox1")).Text和string Comment = ((TextBox)e.Item.FindControl("TextBox2")).Text的值是原来没有更新之前的值,而不是更新之后的值,真的很奇怪!望各位大侠帮忙看一下错在那里.

075010.aspx

 1 <% @ Page Language = " C# "  AutoEventWireup = " true "  CodeFile = " 070510.aspx.cs "  Inherits = " _070510 "   %>
 2
 3 <! DOCTYPE html PUBLIC  " -//W3C//DTD XHTML 1.0 Transitional//EN "   " http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd " >
 4
 5 < html xmlns = " http://www.w3.org/1999/xhtml "   >
 6 < head runat = " server " >
 7      < title > Untitled Page </ title >
 8 </ head >
 9 < body >
10      < form id = " form1 "  runat = " server " >
11      < div >
12          < asp:DataList ID = " DataList1 "  runat = " server "  OnCancelCommand = " DataList1_CancelCommand "  OnEditCommand = " DataList1_EditCommand "  OnUpdateCommand = " DataList1_UpdateCommand " >
13              < ItemTemplate >
14                  < asp:LinkButton ID = " LinkButton1 "  runat = " server "  CommandName = " edit " > 修改 </ asp:LinkButton >
15
16                  < asp:LinkButton ID = " LinkButton2 "  runat = " server "  CommandName = " delete " > 删除 </ asp:LinkButton >
17
18              <% # Eval( " HomeworkID " ) %>
19
20              <% # Eval( " HScore " ) %>
21
22              <% # Eval( " HComment " ) %>
23              </ ItemTemplate >
24              < EditItemTemplate >
25                  < asp:LinkButton ID = " LinkButton1 "  runat = " server "  CommandName = " update " > 更新 </ asp:LinkButton >
26
27                  < asp:LinkButton ID = " LinkButton2 "  runat = " server "  CommandName = " cancel " > 删除 </ asp:LinkButton >
28
29                  <% # Eval( " HomeworkID " ) %>
30                 
31                  < asp:TextBox ID = " TextBox1 "  runat = " server "  Text = ' <%# Eval("HScore")%> ' ></ asp:TextBox >
32                  < asp:TextBox ID = " TextBox2 "  runat = " server "  Text = ' <%# Eval("HComment")%> ' ></ asp:TextBox >
33
34              </ EditItemTemplate >
35          </ asp:DataList >
36     
37      </ div >
38      </ form >
39 </ body >
40 </ html >
41

070510.aspx.cs

 1 using  System;
 2 using  System.Data;
 3 using  System.Configuration;
 4 using  System.Collections;
 5 using  System.Web;
 6 using  System.Web.Security;
 7 using  System.Web.UI;
 8 using  System.Web.UI.WebControls;
 9 using  System.Web.UI.WebControls.WebParts;
10 using  System.Web.UI.HtmlControls;
11 using  System.Data.OleDb;
12
13 public  partial  class  _070510 : System.Web.UI.Page
14 {
15
16    private void bind()
17    {
18        OleDbConnection conn = new OleDbConnection(ConfigurationSettings.AppSettings["connstr"]);
19        OleDbCommand comm = new OleDbCommand("select * from Homework", conn);
20        OleDbDataAdapter da = new OleDbDataAdapter(comm);
21        DataSet ds = new DataSet();
22        da.Fill(ds);
23        DataList1.DataSource = ds;
24        DataList1.DataKeyField = "HomeworkID";
25        DataList1.DataBind();
26    }
27    protected void Page_Load(object sender, EventArgs e)
28    {
29        bind();
30    }
31
32    protected void DataList1_CancelCommand(object source, DataListCommandEventArgs e)
33    {
34        DataList1.EditItemIndex = -1;
35        bind();
36    }
37    protected void DataList1_EditCommand(object source, DataListCommandEventArgs e)
38    {
39        DataList1.EditItemIndex = e.Item.ItemIndex;
40        bind();
41    }
42    protected void DataList1_UpdateCommand(object source, DataListCommandEventArgs e)
43    {
44        int HomeworkID=Convert.ToInt32( DataList1.DataKeys[e.Item.ItemIndex]);
45        string Score =(( TextBox)e.Item.FindControl("TextBox1")).Text;
46        string Comment = ((TextBox)e.Item.FindControl("TextBox2")).Text;
47        OleDbConnection conn = new OleDbConnection(ConfigurationSettings.AppSettings["connstr"]);
48        string updateString = "update Homework set HScore='"+ Score+"',HComment='"+Comment+"'where HomeworkID="+HomeworkID+"";
49        conn.Open();
50        OleDbCommand comm = new OleDbCommand(updateString, conn);
51        comm.ExecuteNonQuery();
52        conn.Close();
53        DataList1.EditItemIndex = -1;
54        bind();
55    }
56}
57

转载于:https://www.cnblogs.com/uncletwo/archive/2007/05/11/742461.html