mycreatehtml.aspx.cs

ASP C#代码实例 适合初学人士学习使用

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
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.Text;
using System.IO;
using System.Data.SqlClient;
using System.Configuration;

namespace Example_11_15
{
	/// <summary>
	/// Summary description for MyCreateHTML.
	/// </summary>
	public class MyCreateHTML : System.Web.UI.Page
	{
		private readonly string SQLCONNECTIONSTRING = ConfigurationSettings.AppSettings["SQLCONNECTIONSTRING"].ToString();

		private void Page_Load(object sender, System.EventArgs e)
		{
			if(!Page.IsPostBack)
			{
				CreateHTML();
			}
		}

		private SqlDataReader GetSourceListData()
		{
			///创建数据库的链接对象
			String cmdText = "SELECT Staff_ID,Staff_Name from Staff ORDER BY Staff_ID";
			SqlConnection myConnection = new SqlConnection(SQLCONNECTIONSTRING);
			SqlCommand myCommand = new SqlCommand(cmdText,myConnection);

			///查询数据库
			myConnection.Open();
			SqlDataReader reader = myCommand.ExecuteReader(CommandBehavior.CloseConnection);				

			///返回dataReader对象
			return(reader);
		}

		private void CreateHTML()
		{
			//读html模板页面到stringbuilder对象里---- 
			string[] format = new string[4];//定义和htmlyem标记数目一致的数组 
			StringBuilder htmltext = new StringBuilder(); 
			try 
			{ 
				using(StreamReader sr = new StreamReader(Server.MapPath("TemplateHTML.htm")))
				{ 
					String line; 
					while((line = sr.ReadLine()) != null) 
					{ 
						htmltext.Append(line); 
					} 
					sr.Close(); 
				} 
			} 
			catch 
			{ 
				Response.Write("<Script>alert('读取文件错误')</Script>"); 
			} 

			format[0]="background=\"bg.jpg\"";   //背景图片 
			format[1]= "#990099";                //字体颜色 
			format[2]="150px";                   //字体大小 

			///获取数据库的内容
			SqlDataReader reader = GetSourceListData();
			format[3]= "<marquee>";

			///读取SqlDataReader中的数据
			while(reader.Read())
			{
				format[3] += reader["Staff_Name"].ToString() + "  " + reader["Staff_ID"].ToString();				
			}
			format[3] += "</marquee>";

			///关闭读取器和数据库的链接
			reader.Close();
			
			//----------替换htm里的标记为你想加的内容 
			for(int i = 0;i < 4; i++) 
			{ 
				htmltext.Replace("$htmlformat["+i+"]",format[i]);
			} 

			//动态生成htm文件
			try 
			{ 
				using(StreamWriter sw = new StreamWriter(Server.MapPath(@"HTMLFiles\TemplateHTML.htm"),false,System.Text.Encoding.GetEncoding("GB2312"))) 
				{ 
					sw.WriteLine(htmltext); 
					sw.Flush(); 
					sw.Close(); 
				} 
			} 
			catch 
			{ 
				Response.Write ("The file could not be wirte:"); 
			} 
		}

		#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.Load += new System.EventHandler(this.Page_Load);
		}
		#endregion
	}
}