此文是小白在学习张晨光老师的视频教学<<Asp.Net WEB服务器编程技术>>中做的学习笔记,一些知识点也是跟着教程走的,大家也可以去老师的主页去学习,谢谢大家.
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm4.aspx.cs" Inherits="WebApplication9_ajax_.WebForm4" %> <!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> </head> <body> <form id="form1" runat="server"> <div> <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager> <asp:UpdatePanel ID="UpdatePanel1" runat="server"> <ContentTemplate> <asp:Label ID="Label1" runat="server"></asp:Label> <br /> <asp:Label ID="Label2" runat="server"></asp:Label> <br /> <asp:Timer ID="Timer1" runat="server" Interval="3000" OnTick="Timer1_Tick"> </asp:Timer> <%--Interval="3000" 刷新的间隔为3秒 OnTick="Timer1_Tick" 每3秒过后触发的事件 --%> </ContentTemplate> </asp:UpdatePanel> </div> </form> </body> </html>
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; namespace WebApplication9_ajax_ { public partial class WebForm4 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Timer1_Tick(object sender, EventArgs e) { int count=ToolMySqlDate.excutScl("SELECT COUNT(*) FROM student"); Label1.Text = string.Format("总共有{0}名学生",count); count = ToolMySqlDate.excutScl("SELECT COUNT(*) FROM student where sex = FALSE"); Label2.Text= string.Format("总共有{0}名女学生", count); } } }
当我们修改数据库中的数据时,在3秒过后,数据即可更新