前端代码：
<%@ 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") %>' onCommand="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 %>" DeleteCommand="DELETE FROM [T_SERIES] WHERE [se_id] =
?" InsertCommand="INSERT INTO [T_SERIES] ([se_id], [se_name], [se_memo], [se_order], [se_enable], [se_delete]) VALUES (
?,
?,
?,
?,
?,
?)" ProviderName="<%$ ConnectionStrings:ConnectionString9.ProviderName %>" SelectCommand="SELECT * FROM [T_SERIES] WHERE SE_DELETE=FALSE" UpdateCommand="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;
OleDbCommand 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 OleDbCommand(str_sql, cnn);
cmd.ExecuteNonQuery();
cnn.Close();
ListView1.DataBind();
}
}
}
不能更改数据，什么原因呢？
本文讨论了ASP.NET中ViewState对搜索引擎优化（SEO）的影响，并提出了移除form元素中runat=server属性的做法来改进SEO效果。此外，还探讨了ViewState的实际作用及是否真的如传言中那样对网站优化不利。
扫一扫
123
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
