前台:
<div>
<asp:DataList ID="DataList1" runat="server" BackColor="LightGoldenrodYellow" BorderColor="Tan" BorderWidth="1px" CellPadding="2" ForeColor="Black" GridLines="Horizontal" RepeatDirection="Horizontal" OnEditCommand="DataList1_EditCommand" OnCancelCommand="DataList1_CancelCommand" OnDeleteCommand="DataList1_DeleteCommand" OnUpdateCommand="DataList1_UpdateCommand">
<FooterStyle BackColor="Tan" />
<SelectedItemStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />
<ItemTemplate>
StuID:
<asp:Label ID="StuIDLabel" runat="server" Text='<%# Eval("StuID") %>'></asp:Label><br />
Stuname:
<asp:Label ID="StunameLabel" runat="server" Text='<%# Eval("Stuname") %>'></asp:Label><br />
Stuage:
<asp:Label ID="StuageLabel" runat="server" Text='<%# Eval("Stuage") %>'></asp:Label><br />
Address:
<asp:Label ID="AddressLabel" runat="server" Text='<%# Eval("Address") %>'></asp:Label><br />
Zip:
<asp:Label ID="ZipLabel" runat="server" Text='<%# Eval("Zip") %>'></asp:Label><br />
Grade:
<asp:Label ID="GradeLabel" runat="server" Text='<%# Eval("Grade") %>'></asp:Label><br />
Class:
<asp:Label ID="ClassLabel" runat="server" Text='<%# Eval("Class") %>'></asp:Label><br /><br />
<asp:LinkButton ID="LinkButton1" runat="server" CommandArgument='<%# Eval("StuID") %>' CommandName="Edit">编辑</asp:LinkButton>
<asp:LinkButton ID="LinkButton2" runat="server" CommandArgument='<%# Eval("StuID") %>' OnClientClick="return confirm('确定删除吗?/n/r删除人员信息后将删除该人的所有信息!');" CommandName="Delete">删除</asp:LinkButton>
</ItemTemplate>
<EditItemTemplate>
StuID:<%# Eval("stuid") %><br />
Stuname:<%# Eval("stuname") %><br />
Stuage:<%# Eval("stuage") %><br />
Address:<asp:TextBox ID="txtAddress" runat="server" Text='<%# Eval("Address") %>'></asp:TextBox><br />
Zip:<%# Eval("zip") %><br />
Grade:<%# Eval("grade") %><br />
Class:<%# Eval("class") %><br />
<asp:LinkButton ID="LinkButton1" runat="server" CommandArgument='<%# Eval("StuID") %>' CommandName="Update">更新</asp:LinkButton>
<asp:LinkButton ID="LinkButton2" runat="server" CommandArgument='<%# Eval("StuID") %>' CommandName="Cancel">取消</asp:LinkButton>
</EditItemTemplate>
<AlternatingItemStyle BackColor="PaleGoldenrod" />
<HeaderStyle BackColor="Tan" Font-Bold="True" />
</asp:DataList>
</div>
后台:
SqlConnection conn = new SqlConnection("Data Source=A496EEA01CF34AB//SA;Initial Catalog=Students;User ID=sa;pwd=666666");
protected void Page_Load(object sender, EventArgs e)
{
Dbind();
}
protected void Dbind()
{
conn.Open();
SqlCommand cmd = new SqlCommand("select *from student", conn);
SqlDataReader sdr = cmd.ExecuteReader();
DataList1.DataSource = sdr;
DataList1.DataBind();
conn.Close();
}
protected void DataList1_EditCommand(object source, DataListCommandEventArgs e)
{
DataList1.EditItemIndex = e.Item.ItemIndex;
Page.SmartNavigation = true;
Dbind();
}
protected void DataList1_CancelCommand(object source, DataListCommandEventArgs e)
{
DataList1.EditItemIndex = -1;
Page.SmartNavigation = true;
Dbind();
}
protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e)
{
conn.Open();
string sql = "delete from student where stuid=" + e.CommandArgument;
SqlCommand cmd = new SqlCommand(sql,conn);
cmd.ExecuteNonQuery();
conn.Close();
Page.SmartNavigation = true;
Dbind();
}
protected void DataList1_UpdateCommand(object source, DataListCommandEventArgs e)
{
conn.Open();
TextBox address = (TextBox)e.Item.FindControl("txtAddress");
string sql = "update student set address='" + address.Text + "' where stuid=" + e.CommandArgument;
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();
Page.SmartNavigation = true;
Dbind();
}