using System; using System.Data; using System.Data.OleDb; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.HtmlControls; using System.Web.Mail; using System.Data.SqlClient; using System.Configuration; using System.Text;namespace www { public class MyCodeBehind : Page { public DataGrid MyList; public TextBox TextBox1,TextBox2,TextBox3,TextBox4,txtIndex; public LinkButton btnFirst,btnPrev,btnNext,btnLast; public Label lblCurrentPage,lblPageCount,lblRecordCount,Lbl_note,label1,label2; public DataRow dr,dr0,dr1; public int PageCount,RecordCount,sum1=0,sum11=0; public string status,subject1,body1="",body2="";
1.对于SQL2000及以前的版本,轮询.
2.对于SQL2005,数据表改变之后可以自动发送一个事件.
http://dev.csdn.net/develop/article/82/82119.shtm
using System.Data;
using System.Data.OleDb;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Web.Mail;
using System.Data.SqlClient;
using System.Configuration;
using System.Text;namespace www
{
public class MyCodeBehind : Page
{
public DataGrid MyList;
public TextBox TextBox1,TextBox2,TextBox3,TextBox4,txtIndex;
public LinkButton btnFirst,btnPrev,btnNext,btnLast;
public Label lblCurrentPage,lblPageCount,lblRecordCount,Lbl_note,label1,label2;
public DataRow dr,dr0,dr1;
public int PageCount,RecordCount,sum1=0,sum11=0;
public string status,subject1,body1="",body2="";
private void Page_Load(Object sender, EventArgs e)
{
string nowDSN=ConfigurationSettings.AppSettings["data"];
SqlConnection myConnection=new SqlConnection(nowDSN);
SqlDataAdapter myCommand=new SqlDataAdapter("select * from pur",myConnection);
DataSet ds=new DataSet();
myCommand.Fill(ds, "pur");
dr = ds.Tables["pur"].Rows[0];
int pur_count=ds.Tables["pur"].Rows.Count; string CommandText;
SqlCommand myCommand0 = new SqlCommand();
myCommand0.Connection=myConnection;
myCommand0.Connection.Open();
myCommand0.CommandText = "select pur_count from pur_count where id='1'";
int pur_count0=(int)myCommand0.ExecuteScalar(); if(pur_count > pur_count0)
{
myCommand0.CommandText = "update pur_count set pur_count='"+pur_count+"' where id='1'";
myCommand0.ExecuteNonQuery();
myCommand0.Connection.Close();
Response.Write("正在转WEB资料程序!");
}
else
{
SmtpMail.SmtpServer="mail.lw-org.com";
MailMessage oMessage = new MailMessage();
oMessage.BodyFormat = MailFormat.Html;
oMessage.Priority = MailPriority.High;
oMessage.From = "[email protected]";
oMessage.To = "[email protected]";
oMessage.Bcc = "[email protected]";
oMessage.BodyEncoding = Encoding.UTF8;
oMessage.Subject = "?";
oMessage.Body = "烦重启转WEB资料程序";
SmtpMail.Send(oMessage);
Response.Write("烦重启转WEB资料程序!");
}
}
}
}