aspnet定时执行一个查询操作的代码

能否帮忙给个教材参考下怎么做~本来我是执行查询按钮,实现数据库查询,数据量大所以需要定时执行

使用timer,以前写过一个网页版简单聊天功能,实现原理是1s中对页面的局部刷新一次,你自己看吧,代码如下:
.aspx文件:

<body>
    <form id="form1" runat="server">
    <div>
        <div>
            <a href="HomePage.aspx">首页</a>&nbsp; &nbsp;<a href="UserPage.aspx">个人中心</a><a href="#">退出登录</a>
        </div>
        <h1>和<%=user2 %>聊天中……</h1><hr />
        <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
        <asp:Panel ID="Panel1" runat="server" BorderStyle="Solid" BorderColor="#66CCFF" BorderWidth="3px" ScrollBars="Vertical" Height="400px" Width="600px">

            <asp:UpdatePanel ID="UpdatePanel1" runat="server">
                <ContentTemplate>
                     <asp:Timer ID="Timer1" runat="server" OnTick="Timer1_Tick" Interval="1000"></asp:Timer>
                    <div runat="server" id="div1" style="width:550px; clear:both;">aaaa</div>

                </ContentTemplate>
            </asp:UpdatePanel>
        </asp:Panel>
        <asp:UpdatePanel ID="UpdatePanel2" runat="server" UpdateMode="Conditional">
            <ContentTemplate>
                <asp:TextBox ID="TextBox1" runat="server" Width="550px" MaxLength="40"></asp:TextBox>
                <asp:Button ID="Button1" runat="server" Text="发送" OnClick="Button1_Click" />
            </ContentTemplate>
        </asp:UpdatePanel>

    </div>
    </form>
</body>

.cs文件

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using DataBaseConnection;
public partial class UserChat : System.Web.UI.Page
{
    public string user1, user2;
    protected void Page_Load(object sender, EventArgs e)
    {
        if(Session["UserName"].ToString().Length == 0) Response.Redirect("HomePage.aspx");
        user1=Session["UserName"].ToString();
        if (Request.QueryString["uid"]!=null) 
        user2 = Request.QueryString["uid"].ToString();
        else
            Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "<script>alert('对不起,意外的错误!');window.location='HomePage.aspx';</script>");
        Timer1.Enabled = true;
        if (!Partone.userExist(user2))
        {
            Timer1.Enabled = false;
            Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "<script>alert('对方账号不存在!');window.location='HomePage.aspx'</script>");
            return;
        }
        else { Timer1.Enabled = true; }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (!Partone.userExist(user2))
        {
            Timer1.Enabled = false;
            Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "<script>alert('对方账号不存在!');window.location='HomePage.aspx'</script>");
            return;
        }
        else 
        {
            Timer1.Enabled = true;
        }
        if (TextBox1.Text.Length == 0) return;
        UsersChat.insertChat(user1, user2, TextBox1.Text);
        TextBox1.Text = "";
    }
    protected void Timer1_Tick(object sender, EventArgs e)
    {
        div1.InnerHtml = "";
        DataTable dtb = UsersChat.getChat(user1, user2);
        int max = 20;
        if (dtb.Rows.Count < max) max = dtb.Rows.Count;
        for (int i = max - 1; i >= 0; i--)
        {
            if (user1.Equals(dtb.Rows[i]["CUser1"].ToString()))
            {
                string htm1 = "<div style=\"color:#22ff33; font-size:18px; text-align:right\">" + user1 + " " + dtb.Rows[i]["ChatDT"] + "</div>";
                string htm2 = "<div style=\"font-size:22px; text-align:right;\">" + dtb.Rows[i]["ChatContent"] + "</div>";
                div1.InnerHtml += htm1;
                div1.InnerHtml += htm2;
            }
            else
            {
                string htm1 = "<div style=\"color:#2233ff; font-size:18px;\">" + user2 + " " + dtb.Rows[i]["ChatDT"] + "</div>";
                string htm2 = "<div style=\"font-size:22px;\">" + dtb.Rows[i]["ChatContent"] + "</div>";
                div1.InnerHtml += htm1;
                div1.InnerHtml += htm2;
            }

        }
    }
}

可以不可以加一个timer事件,根据服务器时间到点触发一个查询,有个设计模式非常适合这个,状态模式(当一个对象的内在状态改变时允许改变其行为,这个对象看起来像是改变了其类)

global.asax中启动一个线程执行查询:http://www.zzzj.com/a/aspnet/20100603111646.html

在Global.ascx.cs中,找到方法Application_Start,在这个方法内定义一个timer事件。
如下:
int time = 1000 * 60 * 60;
System.Timers.Timer myTimer = new System.Timers.Timer(time);
myTimer.Elapsed += new ElapsedEventHandler(myTimer_Elapsed);
myTimer.Enabled = true;
myTimer.AutoReset = true;
其中的myTimer_Elapsed就是需要执行的具体方法