从数据库中取值批量生成html文件

最新推荐文章于 2024-08-18 20:03:03 发布

calyn18

最新推荐文章于 2024-08-18 20:03:03 发布

阅读量676

点赞数

文章标签：数据库 html string dataset security table

本文链接：https://blog.csdn.net/calyn18/article/details/5374713

版权

1. web.config

string htmlPath = "D://htmlFiles"; string[] files = Directory.GetFiles(htmlPath,"*.html"); foreach (string filename in files) { File.Delete(filename); }

string conn = ConfigurationManager.ConnectionStrings["myconn"].ToString(); SqlConnection sqlconn = new SqlConnection(conn); SqlCommand scom = new SqlCommand("select * from table",sqlconn); SqlDataAdapter sda = new SqlDataAdapter(scom); DataSet ds = new DataSet(); sda.Fill(ds); if (ds.Tables[0].Rows.Count > 0) { writeHtml(ds); }

foreach (DataRowView drv in dv) { int pid = int.Parse(drv["pid"].ToString().Trim()); string id_name = drv["ID_Name"].ToString().Trim(); string en_title = drv["en_title"].ToString().Trim(); string en_contents = drv["en_contents"].ToString(); string htmlName = String.Format("{0:D4}{1}.html",pid,id_name); htmlName = htmlName.Replace(' ','_'); htmlName = htmlName.Replace('/','_'); htmlName = htmlName.Replace(':','_'); string htmlContents = "<html><head><title>" + en_title + "</title><meta http-equiv=/"Content-Type/" content=/"text/html; charset=gb2312/"><LINK href="/" mce_href="/""css.css/" type=/"text/css/" rel=/"stylesheet/"></head><body><table><tbody><tr valign=/"top/"><td valign=/"top/" height=/"467/" width=/"696/">" + en_contents + "</td></tr></tbody></table></body></html>"; string htmlPath = "D://htmlFiles//"+htmlName+""; try { using (StreamWriter sw = new StreamWriter(htmlPath, false, System.Text.Encoding.GetEncoding("GB2312"))) { sw.WriteLine(htmlContents); sw.Flush(); sw.Close(); } } catch { Response.Write("The file could not be write!"); } } }

以下表格摘自：http://article.yeeyan.org/view/94842/50302

指定格式	函数用法	输出结果
固定宽度右对齐	`String.Format("{0, 4}", num)`	`“ 1”`
固定宽度左对齐	`String.Format("{0, -4}", num)`	`“1 ”`
用0填充	`String.Format("{0:D4}", num)` 或者 `String.Format("{0:0000}", num)`	`“0001”`
固定宽度并用0填充	`String.Format("{0, 8:D4}", num)`	`“ 0001”`

calyn18

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
从数据库中取值批量生成html文件

1. web.config 2. string htmlPath = "D://htmlFiles"; string[] files = Directory.GetFiles(htmlPath,"*.html"); foreach (string filename in files)
复制链接

扫一扫