动态文件转化为静态文件

来源：互联网发布：工艺设计软件编辑：程序博客网时间：2024/05/28 11:29

using System.Data.SqlTypes;

using System.Data.SqlClient;

using System.IO;

string title = "demo";

StringBuilder sb = new StringBuilder();

sb.Append("<html>");

sb.Append("<head>");

sb.Append("<title>"+title+"</title>"); //注意这里使用到了变量

sb.Append("</head>");

sb.Append("<body>");

sb.Append("<table>");

//连接数据库

using (SqlConnection conn = DbHelp.getConnection())

{

//获取数据

SqlCommand cmd = new SqlCommand("select * from xxx_table where xxx=yyyy", conn);

SqlDataReader reader = cmd.ExecuteReader();

while (reader.Read())

{

sb.Append("<tr>");

//增加数据到html数据流当中

sb.Append("<td>" + reader["data_field"].ToString() + "</td>");

sb.Append("</tr>");

}

sb.Append("</table>");

sb.Append("</body>");

sb.Append("</html>");

//以下代码将StringBuilder当中的内容写入到硬盘当中的文件中去

FileInfo html_file_info = new FileInfo(@"c:/test.html");

if (html_file_info.Exists == true)

{

html_file_info.Delete();

}

using(FileStream html_file = html_file_info.Open(FileMode.OpenOrCreate, FileAccess.ReadWrite))

{

using(StreamWriter writer=new StreamWriter(html_file,Encoding.UTF8))

{

writer.Write(sb.ToString());

}