前台代码:
1<%
@ Page Language="C#" AutoEventWireup="true" CodeFile="DataList.aspx.cs" Inherits="test_DataBind_DataList" %>
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>无标题页</title>
8</head>
9<body style="text-align: center">
10 <form id="form1" runat="server">
11 <div>
12 </div>
13 <asp:Panel ID="Panel1" runat="server" Height="382px" Width="578px">
14 DataList 例子<br />
15 <br />
16 <asp:DataList ID="DataList1" runat="server" OnItemCommand="DataList1_ItemCommand" OnEditCommand="DataList1_EditCommand" OnCancelCommand="DataList1_CancelCommand" OnUpdateCommand="DataList1_UpdateCommand">
17 <ItemTemplate>
18 <asp:LinkButton ID="LinkButton1" runat="server" CommandName="select">查看信息</asp:LinkButton><asp:LinkButton ID="LinkButton2" runat="server" CommandName="edit">编辑</asp:LinkButton><%# Eval("personname")%><%# Eval("personsex")%>
19 </ItemTemplate>
20 <AlternatingItemTemplate>
21 <font color=red>
22 <asp:LinkButton ID="LinkButton1" runat="server" CommandName="select">查看信息</asp:LinkButton><asp:LinkButton ID="LinkButton2" runat="server" CommandName="edit">编辑</asp:LinkButton><%# Eval("personname")%><%# Eval("personsex")%></font>
23 </AlternatingItemTemplate>
24 <HeaderTemplate>
25 <span style="color: #3300cc"><strong>页眉
26 <hr />
27 </strong></span>
28 </HeaderTemplate>
29 <SelectedItemTemplate>
30 姓名:<%# Eval("personname")%>
31 <br />
32 姓别:<%# Eval("personsex")%>
33 </SelectedItemTemplate>
34 <FooterTemplate>
35 <strong><span style="color: #0000cc">页脚
36 <hr />
37 <span style="color: #3300cc"></span></span></strong>
38 </FooterTemplate>
39 <SeparatorTemplate>
40 <hr />
41
42 </SeparatorTemplate>
43 <EditItemTemplate>
44 <asp:LinkButton ID="Update" runat="server">确定</asp:LinkButton>
45 <asp:LinkButton ID="Cancel" runat="server">取消</asp:LinkButton>
46 姓名:<%# Eval("personname")%>
47 <asp:TextBox ID="personName" runat="server" Text='<%# Eval("personname") %>'></asp:TextBox>
48 </EditItemTemplate>
49 </asp:DataList></asp:Panel>
50 </form>
51</body>
52</html>
53
后台代码:
1using System;
2using System.Data;
3using System.Configuration;
4using System.Collections;
5using System.Web;
6using System.Web.Security;
7using System.Web.UI;
8using System.Web.UI.WebControls;
9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11using System.Data.SqlClient;
12public partial class test_DataBind_DataList : System.Web.UI.Page
13{
14
protected void Page_Load(object sender, EventArgs e)
15
{
16 if(!this.IsPostBack)
17 {
18 this.BindToDataList();
19
}
20
21 }
22 public void BindToDataList()
23 {
24 SqlConnection con = DBtest.createCon();
25 SqlDataAdapter sdr = new SqlDataAdapter();
26 sdr.SelectCommand = new SqlCommand("select * from person", con);
27 DataSet ds = new DataSet();
28 sdr.Fill(ds, "emp"); //用数据适配器填充数据集.
29 this.DataList1.DataKeyField = "pID"; //更新时需要的主键
30 this.DataList1.DataSource = ds.Tables["emp"];
31 this.DataList1.DataBind();
32 }
33
34 protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
35 {
36 if (e.CommandName == "select")
37 {
38 this.DataList1.SelectedIndex = e.Item.ItemIndex; //指定选中项的索引
39 this.BindToDataList();
40 }
41 }
42 protected void DataList1_EditCommand(object source, DataListCommandEventArgs e)
43 {
44 this.DataList1.EditItemIndex = e.Item.ItemIndex; //指定选中项的索引
45 this.BindToDataList(); //注意这里没有判断 e.CommandName
46
47 }
48 protected void LinkButton3_Click(object sender, EventArgs e)
49 {
50
51 }
52 protected void DataList1_CancelCommand(object source, DataListCommandEventArgs e)
53 {
54 this.DataList1.EditItemIndex = -1; //设置其索引号为－１，没选中．
55 // this.DataList1.SelectedIndex = -1;
56 this.BindToDataList();
57 }
58 protected void DataList1_UpdateCommand(object source, DataListCommandEventArgs e)
59 {
60 //获取主键
61 string personID = this.DataList1.DataKeys[e.Item.ItemIndex].ToString();
62 string personName = ((TextBox)e.Item.FindControl("personname")).Text;
63 SqlConnection con = DBtest.createCon();
64 con.Open();
65 SqlCommand cmd = new SqlCommand("update person set personname='"+personName+"'",con);
66 cmd.ExecuteNonQuery();
67 this.DataList1.EditItemIndex = -1; //更新好后取消选中
68 this.BindToDataList(); //再重新绑定
69
70 }
71
}
72
为什么点击"取消"按钮无反应,哪里写错了????
1
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="DataList.aspx.cs" Inherits="test_DataBind_DataList" %>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>无标题页</title>8
</head>9
<body style="text-align: center">10
<form id="form1" runat="server">11
<div>12
</div>13
<asp:Panel ID="Panel1" runat="server" Height="382px" Width="578px">14
DataList 例子<br />15
<br />16
<asp:DataList ID="DataList1" runat="server" OnItemCommand="DataList1_ItemCommand" OnEditCommand="DataList1_EditCommand" OnCancelCommand="DataList1_CancelCommand" OnUpdateCommand="DataList1_UpdateCommand">17
<ItemTemplate>18
<asp:LinkButton ID="LinkButton1" runat="server" CommandName="select">查看信息</asp:LinkButton><asp:LinkButton ID="LinkButton2" runat="server" CommandName="edit">编辑</asp:LinkButton><%# Eval("personname")%><%# Eval("personsex")%>19
</ItemTemplate>20
<AlternatingItemTemplate>21
<font color=red>22
<asp:LinkButton ID="LinkButton1" runat="server" CommandName="select">查看信息</asp:LinkButton><asp:LinkButton ID="LinkButton2" runat="server" CommandName="edit">编辑</asp:LinkButton><%# Eval("personname")%><%# Eval("personsex")%></font>23
</AlternatingItemTemplate>24
<HeaderTemplate>25
<span style="color: #3300cc"><strong>页眉26
<hr />27
</strong></span>28
</HeaderTemplate>29
<SelectedItemTemplate>30
姓名:<%# Eval("personname")%>31
<br />32
姓别:<%# Eval("personsex")%>33
</SelectedItemTemplate>34
<FooterTemplate>35
<strong><span style="color: #0000cc">页脚36
<hr />37
<span style="color: #3300cc"></span></span></strong>38
</FooterTemplate>39
<SeparatorTemplate>40
<hr />41
42
</SeparatorTemplate>43
<EditItemTemplate>44
<asp:LinkButton ID="Update" runat="server">确定</asp:LinkButton>45
<asp:LinkButton ID="Cancel" runat="server">取消</asp:LinkButton>46
姓名:<%# Eval("personname")%>47
<asp:TextBox ID="personName" runat="server" Text='<%# Eval("personname") %>'></asp:TextBox>48
</EditItemTemplate>49
</asp:DataList></asp:Panel>50
</form>51
</body>52
</html>53
后台代码:
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.SqlClient;12
public partial class test_DataBind_DataList : System.Web.UI.Page13
{14
protected void Page_Load(object sender, EventArgs e)15
{16
if(!this.IsPostBack)17
{18
this.BindToDataList();19
}20
21
}22
public void BindToDataList()23
{24
SqlConnection con = DBtest.createCon();25
SqlDataAdapter sdr = new SqlDataAdapter();26
sdr.SelectCommand = new SqlCommand("select * from person", con);27
DataSet ds = new DataSet();28
sdr.Fill(ds, "emp"); //用数据适配器填充数据集.29
this.DataList1.DataKeyField = "pID"; //更新时需要的主键30
this.DataList1.DataSource = ds.Tables["emp"];31
this.DataList1.DataBind();32
}33
34
protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)35
{36
if (e.CommandName == "select")37
{38
this.DataList1.SelectedIndex = e.Item.ItemIndex; //指定选中项的索引39
this.BindToDataList();40
}41
}42
protected void DataList1_EditCommand(object source, DataListCommandEventArgs e)43
{44
this.DataList1.EditItemIndex = e.Item.ItemIndex; //指定选中项的索引45
this.BindToDataList(); //注意这里没有判断 e.CommandName46
47
}48
protected void LinkButton3_Click(object sender, EventArgs e)49
{50
51
}52
protected void DataList1_CancelCommand(object source, DataListCommandEventArgs e)53
{54
this.DataList1.EditItemIndex = -1; //设置其索引号为－１，没选中．55
// this.DataList1.SelectedIndex = -1;56
this.BindToDataList();57
}58
protected void DataList1_UpdateCommand(object source, DataListCommandEventArgs e)59
{60
//获取主键61
string personID = this.DataList1.DataKeys[e.Item.ItemIndex].ToString();62
string personName = ((TextBox)e.Item.FindControl("personname")).Text;63
SqlConnection con = DBtest.createCon();64
con.Open();65
SqlCommand cmd = new SqlCommand("update person set personname='"+personName+"'",con);66
cmd.ExecuteNonQuery();67
this.DataList1.EditItemIndex = -1; //更新好后取消选中68
this.BindToDataList(); //再重新绑定69
70
}71
}72
为什么点击"取消"按钮无反应,哪里写错了????
