inputemails.aspx.cs

This is not a very mean things

//-----------------------------------------------------------------------
//
// WebExpert.NET 1.0 
//
// (c) 2003, www.AspCool.com. All rights reserved.
// ASP酷技术网 版权所有
//
// 该源码下载自：http://www.51aspx.com
// 邮箱：[e-mail]
//
// 版权声明：本程序仅供学习使用，你也可以修改后在网站上使用，但使用时必
// 须保留ASP酷技术网(www.AspCool.com)的版权信息和链接。本程序随《ASP.NET
// 网站建设专家》一书赠送，未经作者同意，不得随意修改、传播。
//
// 描述:
//   此文件包含下面的类：
//       InputEmails
//
// 作者:     王保健
// 时间:     2005-01-15
//
//------------------------------------------------------------------------
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Configuration;

namespace AspCool.WebExpert
{
	/// <summary>
	/// Summary description for InputEmails.
	/// </summary>
	public class InputEmails : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.TextBox txtEmails;
		protected System.Web.UI.WebControls.Button btnSave;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.Button btnCancel;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// Put user code to initialize the page here
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{    
			this.btnSave.Click += new System.EventHandler(this.btnSave_Click);
			this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void btnCancel_Click(object sender, System.EventArgs e)
		{
			txtEmails.Text="";
		}

		private void btnSave_Click(object sender, System.EventArgs e)
		{
			string[] emails;
			string sEmail;
			//根据回车键把输入的文字分成单个的邮件地址，并存入emails数组中
			emails=txtEmails.Text.Split(Convert.ToChar(13));

			//创建数据库连接
			SqlConnection myConnection = new SqlConnection( ConfigurationSettings.AppSettings ["ConnectionString"]);
			myConnection.Open(); //打开数据库连接

			for(int i=0;i<emails.Length;i++) 
			{
				sEmail=emails[i].Trim();
				if(sEmail!="")
				{
					sEmail=sEmail.Replace("'","''");
					//判断这个邮件地址是否已经订阅的SQL语句
					string strEmail="select Email from newsletters where Email='"+sEmail +"'";
					SqlCommand myComm= new SqlCommand(strEmail,myConnection);
					//执行SQL命令
					SqlDataReader dr=myComm.ExecuteReader();
					if (dr.Read())
					{
						dr.Close();
						//邮件存在，显示已经订阅过了
						Label2.Text += sEmail+"已经订阅过了<br>";
						continue;
					}
					dr.Close();

					//向数据库中增加订阅电子杂志的电子邮件的SQL语句
					string strSQL="insert into newsletters(Email) values('"+sEmail+"')";
					SqlCommand myComm2=new SqlCommand(strSQL,myConnection);
					try
					{
                        //执行SQL命令
						myComm2.ExecuteNonQuery();
						//显示订阅成功信息
						Label2.Text += sEmail+"订阅成功<br>";
						
					}
					catch
					{
						//显示订阅失败信息
						Label2.Text += sEmail+"订阅失败<br>";					
					}
				}
			
			}
			//关闭数据库连接
			myConnection.Close();	
		}
	}
}