用xml实现增删改查并绑定到DataList ,目标实现:
1.添加xml时不许有空值,不许有重复项.
2.编辑DataList 时不许编辑为xml中已有的项(仍不许重复),
3.删除DataList 项,若xml中无数据时控件不显示...
偶是菜菜,2和3弄了好久...
下面是代码:
<boost.xml>
<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<boostsetting>
<Boost>5</Boost>
<KeyWord>5555</KeyWord>
</boostsetting>
<boostsetting>
<Boost>7</Boost>
<KeyWord>7777</KeyWord>
</boostsetting>
</NewDataSet>
<.aspx>
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="backManage.aspx.cs" Inherits="backManage" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>无标题页</title>
<link href="CSS/bbs.css" _fcksavedurl=""CSS/bbs.css"" _fcksavedurl=""CSS/bbs.css"" rel="stylesheet" type="text/css" />
<link href="CSS/common.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form id="form1" runat="server">
<div>
<div align="center">
搜索引擎后台管理页面</div>
<br />
<div align="center">
<table width="700" border="0" cellpadding="2" cellspacing="2" bordercolor="#ffffff"
bgcolor="#cccccc">
<tr bgcolor="#ffffff">
<td style="width: 81px">
权重:</td>
<td colspan="2" style="width: 141px; text-align: left;">
<asp:TextBox ID="TxtBoostAdd" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="* 不能为空 *"
ControlToValidate="TxtBoostAdd" ValidationGroup="add"></asp:RequiredFieldValidator>
<asp:RangeValidator ID="RangeValidator1" runat="server" ControlToValidate="TxtBoostAdd"
ErrorMessage="* 必须为数值 *" MaximumValue="10000" MinimumValue="0" Type="Double"
ValidationGroup="add"></asp:RangeValidator></td>
</tr>
<tr bgcolor="#ffffff">
<td style="width: 81px">
关键字:</td>
<td colspan="2" style="width: 141px; text-align: left;">
<asp:TextBox ID="TxtKeywordAdd" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ErrorMessage="* 不能为空 *"
ControlToValidate="TxtKeywordAdd" ValidationGroup="add"></asp:RequiredFieldValidator>
</td>
</tr>
<tr bgcolor="#ffffff">
<td colspan="3" align="center">
<asp:Button ID="BtnAdd" runat="server" Text="添加" OnClick="BtnAdd_Click" ValidationGroup="add" />
</td>
</tr>
</table>
<br />
<asp:DataList ID="DlistBoost" runat="server" RepeatColumns="2" OnCancelCommand="DlistBoost_CancelCommand"
OnDeleteCommand="DlistBoost_DeleteCommand" OnEditCommand="DlistBoost_EditCommand"
OnUpdateCommand="DlistBoost_UpdateCommand" BackColor="White" BorderColor="#999999"
BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Vertical" OnItemDataBound="DlistBoost_ItemDataBound">
<ItemTemplate>
<table width="350" border="0" cellpadding="2" cellspacing="2" bordercolor="#ffffff"
bgcolor="#cccccc">
<tr bgcolor="#ffffff">
<td style="width: 81px">
权重:</td>
<td colspan="2" style="width: 142px">
<asp:Label ID="LabBoost" runat="server" Text='<%# Eval("Boost") %>'></asp:Label></td>
</tr>
<tr bgcolor="#ffffff">
<td style="width: 81px">
关键字:</td>
<td colspan="2" style="width: 142px">
<asp:Label ID="LabKeyWord" runat="server" Text='<%# Eval("KeyWord") %>'></asp:Label></td>
</tr>
<tr bgcolor="#ffffff">
<td colspan="3" align="center">
<asp:Button ID="BtnEdit" runat="server" Text="编辑" CommandName="edit" CausesValidation="False" />
<asp:Button ID="BtnDelete" runat="server" Text="删除" CommandName="delete" CausesValidation="False" />
</td>
</tr>
</table>
</ItemTemplate>
<EditItemTemplate>
<table width="350" border="0" cellpadding="2" cellspacing="2" bordercolor="#ffffff"
bgcolor="#cccccc">
<tr bgcolor="#ffffff">
<td style="width: 81px">
权值:</td>
<td colspan="2" style="width: 142px">
<asp:TextBox ID="TxtBoostUpdate" runat="server" Text='<%# Eval("Boost") %>'></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="TxtBoostUpdate"
ErrorMessage="* 不能为空 *"></asp:RequiredFieldValidator>
<asp:RangeValidator ID="RangeValidator2" runat="server" ControlToValidate="TxtBoostUpdate"
ErrorMessage="* 必须为数值 *" MaximumValue="10000" MinimumValue="0" Type="Double"></asp:RangeValidator></td>
</tr>
<tr bgcolor="#ffffff">
<td style="width: 81px">
关键字:</td>
<td colspan="2" style="width: 142px">
<asp:TextBox ID="TxtKeywordUpdate" runat="server" Text='<%# Eval("KeyWord") %>'></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ControlToValidate="TxtKeywordUpdate"
ErrorMessage="* 不能为空 *"></asp:RequiredFieldValidator></td>
</tr>
<tr bgcolor="#ffffff">
<td colspan="3" align="center">
<asp:Button ID="BtnUpdate" runat="server" Text="更新" CommandName="update" />
<asp:Button ID="BtnCancel" runat="server" Text="取消" CommandName="cancel" CausesValidation="False" />
</td>
</tr>
</table>
</EditItemTemplate>
<HeaderTemplate>
权重及关键字列表
</HeaderTemplate>
<FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
<SelectedItemStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
<AlternatingItemStyle BackColor="Gainsboro" />
<ItemStyle BackColor="#EEEEEE" ForeColor="Black" />
<HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
</asp:DataList>
<br />
</div>
</div>
</form>
</body>
</html>
<.aspx.cs>
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Xml;
public partial class backManage : System.Web.UI.Page
{
public float fBoost;
public string strKeyword;
XmlDocument doc = new XmlDocument();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
fill();
}
}
//读取xml并绑定
protected void fill()
{
DataSet Ds = new DataSet();
Ds.ReadXml(Server.MapPath("app_data/boost.xml"));
Session["DS"] = Ds;
doc.Load(Server.MapPath("app_data/boost.xml"));
Session["DOC"] = doc;
if (doc.DocumentElement.ChildNodes.Count == 0)
{
DlistBoost.Visible = false;
}
else
{
DlistBoost.Visible = true;
DlistBoost.DataSource = Ds.Tables[0].DefaultView;
DlistBoost.DataBind();
}
}
//触发取消事件
protected void DlistBoost_CancelCommand(object source, DataListCommandEventArgs e)
{
DlistBoost.EditItemIndex = -1;
fill();
}
//删除记录
protected void DlistBoost_DeleteCommand(object source, DataListCommandEventArgs e)
{
DataSet ds = (DataSet)Session["DS"];
XmlDocument doc=(XmlDocument)Session["DOC"];
if (doc.DocumentElement.ChildNodes.Count != 0)
{
ds.Tables[0].Rows.Remove(ds.Tables[0].Rows[e.Item.ItemIndex]);
Session["DS"] = ds;
}
ds.WriteXml(Server.MapPath("app_data/boost.xml"));
fill();
}
//触发编辑事件
protected void DlistBoost_EditCommand(object source, DataListCommandEventArgs e)
{
DlistBoost.EditItemIndex = e.Item.ItemIndex;
fill();
}
//更新记录
protected void DlistBoost_UpdateCommand(object source, DataListCommandEventArgs e)
{
DataSet ds = (DataSet)Session["Ds"];
ds.Tables[0].Rows[e.Item.ItemIndex]["Boost"] = ((TextBox)(e.Item.FindControl("TxtBoostUpdate"))).Text.ToString();
ds.Tables[0].Rows[e.Item.ItemIndex]["KeyWord"] = ((TextBox)(e.Item.FindControl("TxtKeywordUpdate"))).Text.ToString();
string str_curKeyword = ((TextBox)(e.Item.FindControl("TxtKeywordUpdate"))).Text.ToString();
Session["DS"] = ds;
//避免重复添加
DataView Dv = ds.Tables[0].DefaultView;
string strKeywords;
for (int i = 0; i < Dv.Count; i++)
{
strKeywords = Session["LabKeyWord"].ToString();
//根据关键字赋权重
if (str_curKeyword == strKeywords && Dv.Count != 1)
{
Response.Write("<script language=javascript>alert('库中已有相同关键字,请重新输入!');window.history.go(-1);</script>");
((TextBox)(e.Item.FindControl("TxtBoostUpdate"))).Text = ds.Tables[0].Rows[e.Item.ItemIndex]["Boost"].ToString();
((TextBox)(e.Item.FindControl("TxtKeywordUpdate"))).Text = str_curKeyword;
return;
}
}
ds.WriteXml(Server.MapPath("app_data/boost.xml"));
DlistBoost.EditItemIndex = -1;
fill();
}
//添加记录
protected void BtnAdd_Click(object sender, EventArgs e)
{
string url = Server.MapPath("app_data/boost.xml");
string str_boost = this.TxtBoostAdd.Text;
string str_keyword = this.TxtKeywordAdd.Text;
try
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(url); //加载XML文档
XmlNode root = xmlDoc.SelectSingleNode("NewDataSet");//查找第一个匹配的XmlNode
XmlElement xe1 = xmlDoc.CreateElement("boostsetting");//创建第一个节点的第一个元素
XmlElement xesub1 = xmlDoc.CreateElement("Boost"); //创建第一个节点的第一个元素里的属性
xesub1.InnerText = str_boost;//设置文本节点
xe1.AppendChild(xesub1);//将指定节点添加到该节点的子节点列表的末尾
XmlElement xesub2 = xmlDoc.CreateElement("KeyWord");
xesub2.InnerText = str_keyword;
xe1.AppendChild(xesub2);
//避免重复添加数据
for (int i = 0; i < xmlDoc.DocumentElement.ChildNodes.Count; i++)
{
strKeyword = xmlDoc.DocumentElement.ChildNodes[i].LastChild.InnerText;
//根据关键字赋权重
if (TxtKeywordAdd.Text == strKeyword)
{
Response.Write("<script language=javascript>alert('库中已有相同关键字,请重新输入!');window.history.go(-1);</script>");
return;
}
}
root.AppendChild(xe1);
xmlDoc.Save(url);//保存XML文件
fill();
TxtBoostAdd.Text = TxtKeywordAdd.Text = "";
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
protected void DlistBoost_ItemDataBound(object sender, DataListItemEventArgs e)
{
Button BtnDel = (Button)e.Item.FindControl("BtnDelete");
if (BtnDel != null)
{
BtnDel.Attributes.Add("onclick", "return confirm('是否要删除此条记录?');");
}
DataSet ds = (DataSet)Session["DS"];
Label Lab = (Label)e.Item.FindControl("LabKeyWord");
if (Lab != null)
{
Session["LabKeyWord"] = Lab.Text;
}
}
}
希望能帮到大家,也为自己日后升级用.