惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

Forbes - Security
Forbes - Security
Cisco Talos Blog
Cisco Talos Blog
Latest news
Latest news
P
Proofpoint News Feed
T
The Exploit Database - CXSecurity.com
Know Your Adversary
Know Your Adversary
S
Securelist
T
Tor Project blog
P
Palo Alto Networks Blog
G
GRAHAM CLULEY
NISL@THU
NISL@THU
C
CERT Recently Published Vulnerability Notes
L
LINUX DO - 热门话题
V
Vulnerabilities – Threatpost
Simon Willison's Weblog
Simon Willison's Weblog
AWS News Blog
AWS News Blog
T
The Blog of Author Tim Ferriss
Security Latest
Security Latest
P
Proofpoint News Feed
C
CXSECURITY Database RSS Feed - CXSecurity.com
cs.CV updates on arXiv.org
cs.CV updates on arXiv.org
T
Tenable Blog
博客园_首页
TaoSecurity Blog
TaoSecurity Blog
Attack and Defense Labs
Attack and Defense Labs
Project Zero
Project Zero
The Hacker News
The Hacker News
M
MIT News - Artificial intelligence
Cyber Security Advisories - MS-ISAC
Cyber Security Advisories - MS-ISAC
Application and Cybersecurity Blog
Application and Cybersecurity Blog
H
Hackread – Cybersecurity News, Data Breaches, AI and More
K
KPMG report finds enterprise disconnect between AI and its ROI | CIO
K
Kaspersky official blog
F
Full Disclosure
WordPress大学
WordPress大学
Engineering at Meta
Engineering at Meta
The Cloudflare Blog
N
Netflix TechBlog - Medium
Stack Overflow Blog
Stack Overflow Blog
L
LangChain Blog
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
MongoDB | Blog
MongoDB | Blog
宝玉的分享
宝玉的分享
GbyAI
GbyAI
J
Java Code Geeks
云风的 BLOG
云风的 BLOG
Recent Announcements
Recent Announcements
博客园 - 叶小钗
Webroot Blog
Webroot Blog
Hacker News: Ask HN
Hacker News: Ask HN

博客园 - 飞鼠

面试时英语自我介绍范文 判斷一天是否是年月中正確的日 - 飞鼠 - 博客园 Javascript中parseInt的一個問題 NUMERIC(3,1) 的含義 在 google 里找书下载的捷径 - 飞鼠 使用asp.net发送邮件详解 創建用戶控件 - 飞鼠 - 博客园 SQL密码 不斷提醒 datagrid用xml作为数据源,并且有更新,删除和排序的操作(VB) - 飞鼠 - 博客园 将xml作为DataGrid 操作(Sort, Edit, Delete) - 飞鼠 用ASP.NET结合XML制作广告管理程序 用ASP.NET结合XML制作广告管理程序(2) - 飞鼠 - 博客园 XML、DataSet、DataGrid结合写成广告管理程序(上)(转载) 分别用DataGrid、Repeater、DataList绑定XML数据的例子 - 飞鼠 - 博客园 将某一目录下的所有相同格式的 XML文件绑定到不同的DataGrid - 飞鼠 - 博客园 创建可编辑的xml文档(之五)执行中的treeview 控件 创建可编辑的xml文档(之四) 删除、改名、插入操作 创建可编辑的xml文档(之三)执行拖放操作
XML、DataSet、DataGrid结合写成广告管理程序(下)(转载) - 飞鼠 - 博客园
飞鼠 · 2005-12-29 · via 博客园 - 飞鼠

作者:http://www.aspcn.com 飞刀

上一节中,由于XML文件占了很大的篇幅,只好把源程序贴在这一页了。

也是很长的哟,大家有性子看才行:)

<% @ Page Language="C#" ResponseEncoding="gb2312" %>
<% @ Import Namespace="System.Data" %>
<% @ Import Namespace="System.Xml" %>
<% @ Import Namespace="System.IO" %>
<Script Language="C#" Runat="Server">
DataSet ds;        //定义公用的DataSet
DataView dv;    //定义公用的DataView
string SortField;
string sPath;
public void Page_Load(Object src,EventArgs e)
{
    if(State["adxml"]==null)
    {
        sPath = Server.MapPath(".") + "\\AdBanners\\ad_gb.xml";
        ds = new DataSet();
        ds.ReadXml(sPath);
        State["adxml"] = ds;
    }
    else
    {
        ds = (DataSet)State["adxml"];
    }
    dv = ds.Tables[0].DefaultView;
    dv.Sort = "ImageUrl";

    if(!Page.IsPostBack)
    {
        CreateTable();
    }
}

//捆绑Binder
public void CreateTable()
{

    dgXML.DataSource = dv;
    dgXML.DataBind();
}

//翻页时
public void dgXML_Changed(Object sender,DataGridPageChangedEventArgs e)
{
    CreateTable();
}

//删除
public void DelItem(Object sender,DataGridCommandEventArgs e)
{
    if(((LinkButton)e.CommandSource).CommandName == "del")
    {
        //首先取得当前更新页的行数与CurrentPageIndex
        int CPI = (int)dgXML.CurrentPageIndex;
        int EII = (int)e.Item.ItemIndex;
        int row = CPI*5+EII;    

        lb.Text = row.ToString();
    
        //删除
        dv.Delete(row);
    
        dgXML.EditItemIndex = -1;
        ds.WriteXml(sPath);
    
        CreateTable();
    }
}

//取消
public void dgXML_Cancel(Object sender,DataGridCommandEventArgs e)
{
    dgXML.EditItemIndex = -1;
    CreateTable();
}

//编辑
public void dgXML_Edit(Object sender,DataGridCommandEventArgs e)
{
    dgXML.EditItemIndex = (int)e.Item.ItemIndex;
    CreateTable();
}

//更新
public void dgXML_Update(Object sender, DataGridCommandEventArgs e)
{
    try
    {
        //首先取得当前更新页的行数与CurrentPageIndex
        int CPI = (int)dgXML.CurrentPageIndex;
        int EII = (int)e.Item.ItemIndex;
        int row = CPI*5+EII;
        //lb.Text = row.ToString();

        //取得各项值
        
        string ImageUrl            = ((TextBox)e.Item.Cells[2].Controls[0]).Text;
        string NavigateUrl        = ((TextBox)e.Item.Cells[3].Controls[0]).Text;
        string AlternateText    = ((TextBox)e.Item.Cells[4].Controls[0]).Text;
        string Keyword            = ((TextBox)e.Item.Cells[5].Controls[0]).Text;
        string Impressions        = ((TextBox)e.Item.Cells[6].Controls[0]).Text;
        
        dv.Delete(row);

        
        DataRow dr = ds.Tables[0].NewRow();
        dr[0]    =    ImageUrl;
        dr[1]    =    NavigateUrl;
        dr[2]    =    AlternateText;
        dr[3]    =    Keyword;
        dr[4]    =    Impressions;
        ds.Tables[0].Rows.Add(dr);
        ds.WriteXml(sPath);
    }
    catch(Exception ee)
    {
        lb.Text = ee.ToString();
    }

    dgXML.EditItemIndex = -1;
    CreateTable();

}

public void PanelShow(Object sender,EventArgs e)
{
    AddItem.Visible = true;
}

public void AddItem_Click(Object sender,EventArgs e)
{
    DataRow dr = ds.Tables[0].NewRow();
    dr[0]    =    mUrl.Text;
    dr[1]    =    aUrl.Text;
    dr[2]    =    mText.Text;
    dr[3]    =    aKey.Text;
    dr[4]    =    aTime.Text;
    ds.Tables[0].Rows.Add(dr);
    ds.WriteXml(sPath);
    CreateTable();
    AddItem.Visible=false;
}
</script>
<html>
<head>
<title></title>
</head>
<body>
<form id="form1" runat="server">
<asp:DataGrid id="dgXML" runat="server"
AllowPaging="True"
PageSize="10"
BorderColor="black"
BorderWidth="1"
CellPadding="3"
Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
PagerStyle-Mode="NumericPages"
PagerStyle-HorizontalAlign="Right"
PagerStyle-PrevPageText="前页"
PagerStyle-NextPageText="后页"
OnPageIndexChanged="dgXML_Changed"
OnEditCommand="dgXML_Edit"
OnCancelCommand="dgXML_Cancel"
OnUpdateCommand="dgXML_Update"
OnItemCommand="DelItem"
AutoGenerateColumns="false"
>
<property name="Columns">
    <asp:ButtonColumn HeaderText="删除"  Text="删除" CommandName="del" />
    <asp:EditCommandColumn    EditText="修改"    CancelText="取消" UpdateText="更新" ItemStyle-Wrap="false" HeaderText="操作区" HeaderStyle-Wrap="false" />
    <asp:BoundColumn HeaderText="图片地址(相对)" SortField="ImageUrl" DataField="ImageUrl" />
    <asp:BoundColumn HeaderText="链接URL" SortField="NavigateUrl" DataField="NavigateUrl" />
    <asp:BoundColumn HeaderText="图片说明" SortField="AlternateText" DataField="AlternateText" />
    <asp:BoundColumn HeaderText="类别" SortField="Keyword" DataField="Keyword" />
    <asp:BoundColumn HeaderText="显示时间" SortField="Impressions" DataField="Impressions" />
</property>
</asp:DataGrid>
<hr>
<asp:Button id="vi" Text="添加新项" OnClick="PanelShow"  runat="server"/>
<br>
<asp:Panel id="AddItem" runat="server" Visible="false">
<table>
    <tr Bgcolor="#aaaadd"><td colspan=2>添加新的广告页面</td></tr>
    <tr>
        <td>广告图片URL:</td>
        <td><asp:TextBox id="mUrl" runat="server" Text="http://" /></td>
    </tr>
    <tr>
        <td>广告链接地址:</td>
        <td><asp:TextBox id="aUrl" runat="server" Text="http://" /></td>
    </tr>
    <tr>
        <td>图片说明:</td>
        <td><asp:TextBox id="mText" runat="server" /></td>
    </tr>
    <tr>
        <td>广告所属类别:</td>
        <td><asp:TextBox id="aKey" runat="server" /></td>
    </tr>
    <tr>
        <td>显示时间</td>
        <td><asp:TextBox id="aTime" runat="server" /></td>
    </tr>
    <tr><td>
      <asp:Button id="submit" Text="提交" OnClick="AddItem_Click" runat="server" /></td></tr>
</table>
</asp:Panel>
<asp:Label id="lb" runat="server" />
</form>
</body>
</html>