📄 datalist2.aspx
字号:
<% @ Page Language="C#" %>
<% @ Import Namespace="System.Data" %>
<% @ Import Namespace="System.Data.OleDb" %>
<Script Language="C#" Runat="Server">
OleDbConnection MyConn;
public void Page_Load(Object src,EventArgs e)
{
//连接语句
string MyConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+Server.MapPath(".")+"..\\db1.mdb;";
MyConn = new OleDbConnection(MyConnString);
MyConn.Open();
if(!Page.IsPostBack)
{
ListBind();
}
}
ICollection CreateSource()
{
string strSel = "select * from Score";
DataSet ds = new DataSet();
OleDbDataAdapter MyAdapter = new OleDbDataAdapter(strSel,MyConn);
MyAdapter.Fill(ds,"Score");
return ds.Tables["Score"].DefaultView;
}
public void ListBind()
{
score.DataSource = CreateSource();
score.DataBind();
}
public void DataList_EditCommand(Object sender,DataListCommandEventArgs e)
{
score.EditItemIndex = (int)e.Item.ItemIndex;
ListBind();
}
public void DataList_CancelCommand(Object sender,DataListCommandEventArgs e)
{
score.EditItemIndex = -1;
ListBind();
}
public void DataList_UpdateCommand(Object sender,DataListCommandEventArgs e)
{
string strName = ((Label)e.Item.FindControl("lblName")).Text;
int intChinese = Int32.Parse(((TextBox)e.Item.FindControl("tbChinese")).Text);
int intMath = Int32.Parse(((TextBox)e.Item.FindControl("tbMath")).Text);
int intEnglish = Int32.Parse(((TextBox)e.Item.FindControl("tbEnglish")).Text);
//更新数据库中的数据
string strUpdate = "Update Score Set Chinese="+intChinese+",Math="+intMath+",English="+intEnglish+" Where Name='"+strName+"'";
OleDbCommand MyComm = new OleDbCommand(strUpdate,MyConn);
MyComm.ExecuteNonQuery();
score.EditItemIndex = -1;
ListBind();
}
</script>
<html>
<head>
<title></title>
</head>
<body>
<form runat="server">
<asp:DataList id="score" runat="server"
HeaderStyle-BackColor="#aaaadd"
AlternatingItemStyle-BackColor="Gainsboro"
EditItemStyle-BackColor="yellow"
RepeatLayout="Table"
OnEditCommand="DataList_EditCommand"
OnUpdateCommand="DataList_UpdateCommand"
OnCancelCommand="DataList_CancelCommand"
>
<HeaderTemplate>
DataList控件的编辑模版
</HeaderTemplate>
<ItemTemplate>
name：<%# DataBinder.Eval(Container.DataItem,"Name") %>
<asp:LinkButton id="btnSelect" Text="edit" CommandName="edit" runat="server" />
</ItemTemplate>
<EditItemTemplate>
name：<asp:Label id="lblName" Text='<%# DataBinder.Eval(Container.DataItem,"Name") %>' runat="server" /><br>
Cscore：<asp:TextBox id="tbChinese" Text='<%# DataBinder.Eval(Container.DataItem,"Chinese") %>' runat="server" /><br>
Mscore：<asp:TextBox id="tbMath" Text='<%# DataBinder.Eval(Container.DataItem,"Math") %>' runat="server" /><br>
Escore：<asp:TextBox id="tbEnglish" Text='<%# DataBinder.Eval(Container.DataItem,"English") %>' runat="server" /><br>
<asp:LinkButton id="lbnUpdate" Text="update" CommandName="update" runat="server" />
<asp:LinkButton id="lbnCancel" Text="cancell" CommandName="cancel" runat="server" />
</EditItemTemplate>
</asp:DataList>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -