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());
}
}