前端代码：
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="default.aspx.cs" Inherits="listview增删改查._default" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
<style type="text/css">
.divItem {
padding: 5px;
}
.divBtns {
width:130px;
}
.divInfo {
width:350px;
padding:0px 10px 0px 10px;
border-left:1px solid #dadada;
border-right:1px solid #dadada;
}
.divInfo2 {
width:200px;
}
.divBtns, .divInfo, .divInfo2 {
float:left;
}
.clr {
clear:both;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:ListView ID="ListView1" runat="server" DataSourceID="SqlDataSource2" ItemPlaceholderID="itemholder">
<LayoutTemplate>
<div runat="server" id="itemholder"></div>
</LayoutTemplate>
<ItemTemplate>
<div id="divItem">
<div
class="divBtns">
<asp:
Button ID="btn_edit" runat="server" Text="编辑"
CommandName="edit" /><br/>
<asp:
Button ID="btn_delete" runat="server" Text="删除"
CommandName="delete" />
<asp:
Button ID="btn_delmak" runat="server" Text="标记删除"
CommandName="lvcmd"
CommandArgument='<%#Eval("se_id") %>' on
Command="mycmd" />
</div>
<div
class="divInfo">
<h2><%#Eval("se_name") %></h2>
<p><%#Eval("se_memo") %></p>
</div>
<div
class="divInfo2">
<asp:CheckBox ID="chk_enable" runat="server" Checked='<%#Eval("se_enable") %>' Enabled="false" Text="有效性" /><br/>
<p>排序：<%#Eval("se_order") %></p>
</div>
<div
class="clr"></div>
</div>
</ItemTemplate>
</asp:ListView>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString9 %>" Delete
Command="DELETE FROM [T_SERIES] WHERE [se_id] = ?" Insert
Command="INSERT INTO [T_SERIES] ([se_id], [se_name], [se_memo], [se_order], [se_enable], [se_delete]) VALUES (?, ?, ?, ?, ?, ?)" ProviderName="<%$ ConnectionStrings:ConnectionString9.ProviderName %>" Select
Command="SELECT * FROM [T_SERIES] WHERE SE_DELETE=FALSE" Update
Command="UPDATE [T_SERIES] SET [se_name] = ?, [se_memo] = ?, [se_order] = ?, [se_enable] = ?, [se_delete] = ? WHERE [se_id] = ?">
<DeleteParameters>
<asp:Parameter Name="se_id" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="se_id" Type="Int32" />
<asp:Parameter Name="se_name" Type="String" />
<asp:Parameter Name="se_memo" Type="String" />
<asp:Parameter Name="se_order" Type="Int32" />
<asp:Parameter Name="se_enable" Type="Boolean" />
<asp:Parameter Name="se_delete" Type="Boolean" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="se_name" Type="String" />
<asp:Parameter Name="se_memo" Type="String" />
<asp:Parameter Name="se_order" Type="Int32" />
<asp:Parameter Name="se_enable" Type="Boolean" />
<asp:Parameter Name="se_delete" Type="Boolean" />
<asp:Parameter Name="se_id" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
后端代码：
using System;
using System.Collections.Generic;
using System.Data.OleDb;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace listview增删改查
{
public partial
class _default : System.Web.UI.Page
{
string str_cnn = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=";
string str_sourcefile = "mdb\\TB-HLINKS.accdb";
OleDbConnection cnn;
OleDb
Command cmd;
OleDbDataReader datar;
string str_sql;
protected void Page_Load(object sender,
EventArgs e)
{
}
protected void mycmd(object sender,
CommandEventArgs e)
{
string str_conn = str_cnn + MapPath(str_sourcefile);
cnn = new OleDbConnection(str_conn);
cnn.Open();
str_sql = "update T_SERIES set se_delete =true where " +
"se_id =" + e.
CommandArgument.ToString();
cmd = new OleDb
Command(str_sql, cnn);
cmd.ExecuteNonQuery();
cnn.Close();
ListView1.DataBind();
}
}
}
不能更改数据，什么原因呢？
本文介绍了EventArgs类作为事件数据基类的作用，及其子类CommandEventArgs在Button或ImageButton控件单击事件中如何提供数据。阐述了在.NET框架中如何通过CommandEventArgs传递额外的状态信息，并解释了为何在某些情况下选择使用OnCommand而非OnClick事件。
扫一扫
821
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
