《Asp.net(C#)读取数据库并生成JS文件制作首页图片切换效果(附demo源码下载)_》由会员分享，可在线阅读，更多相关《Asp.net(C#)读取数据库并生成JS文件制作首页图片切换效果(附demo源码下载)_（13页珍藏版）》请在金锄头文库上搜索。
1、A(C#)读取数据库并生成JS文件制作首页图片切换效果(附demo源码下载)_ 本文实例讲解并描述了A(C#)读取数据库并生成JS文件制作首页图片切换效果的方法。分享给大家供大家参考，具体如下： using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Text; using System.IO; public partial class _Defau
2、lt : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) / summary / 利用模板生成静态页面 / /summary / param name=strTitle标题/param / param name=strText/param / param name=strContent发布时间/param / param name=strAuthor内容/param / returns生成页面名称/returns public static string WriteFile(string strTi
3、tle, string strAuthor, string strDate, string strContent) string path = HttpContext.Current.Server.MapPath(/); Encoding code = Encoding.GetEncoding(gb2312); / 读取模板文件 string temp = HttpContext.Current.Server.MapPath(/Template.html); StreamReader sr = null; StreamWriter sw = null; string str = ; try s
4、r = new StreamReader(temp, code); str = sr.ReadToEnd(); / 读取文件 catch (Exception exp) HttpContext.Current.Response.Write(exp.Message); HttpContext.Current.Response.End(); sr.Close(); Random rd = new Random(); string strRd = rd.Next(0, 9999).ToString(); string htmlfilename = DateTime.Now.ToString(yyyy
5、MMddHHmmss) + strRd + .html; DateTime dtNow = DateTime.Now; / 替换内容 str = str.Replace($biaoti, strTitle); str = str.Replace($author, strAuthor); str = str.Replace($datetime, strDate); str = str.Replace($content, strContent); / 写文件 try string pathUrl = path + dtNow.Year + + dtNow.Month + + dtNow.Day;
6、if (!Directory.Exists(pathUrl) Directory.CreateDirectory(pathUrl); sw = new StreamWriter(pathUrl + + htmlfilename, false, code); sw.Write(str); sw.Flush(); catch (Exception ex) HttpContext.Current.Response.Write(ex.Message); HttpContext.Current.Response.End(); finally sw.Close(); return dtNow.Year.T
7、oString() + / + dtNow.Month.ToString() + / + dtNow.Day.ToString() + / + htmlfilename; protected void Button1_Click(object sender, EventArgs e) WriteFile(title , ttttttt , 2021-09-27, 测试 br); Template.html table tr td align=center$biaoti/td /tr tr td align=center：$author 发布时间：$datetime/td /tr tr td$c
8、ontent/td /tr /table 思路：首先读取数据库中图片，链接，说明文字等数据，然后将读取到的数据写入首页图片切换效果的JS文件。 下面代码实现向数据库中增加 图片、链接、说明文字等数据 和 生成JS文件 using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using
9、 System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.OleDb; using System.IO; using System.Text; public partial class Admin_Slide : System.Web.UI.Page protected void Page_Load(object sender, EventArgs e) protected void Add_Btn_Click(object sender, EventArgs e) /增加幻
10、灯片,将信息写入数据库 string imgpath; imgpath = ./UpLoadFiles/SlideImg/ + ImgUp.FileName; ImgUp.SaveAs(Server.MapPath(imgpath); MyOleDb mc = new MyOleDb(); mc.ConnOpen(); OleDbCommand cmd = new OleDbCommand(insert into SlideImg(lnk,pic,txt) values ( + linkarea.Text.ToString() + , + imgpath + , + imgtitle.Text
11、.ToString() + );, mc.Conn); OleDbDataReader rdr = null; rdr = cmd.ExecuteReader(); mc.ConnClose(); protected void MJS_Btn_Click(object sender, EventArgs e) /生成JS幻灯文件 string jsfile,jstemplete; string strlnk, strpic, strtxt; strlnk = null; strpic = null; strtxt = null; jsfile = Server.MapPath(/Js/) +
12、SlideImg.js; /JS文件路径 jstemplete = Server.MapPath(/Js/) + JsTemplete.js; /JS文件模板路径 deljs(jsfile); /删除JS文件 MyOleDb mc = new MyOleDb(); mc.ConnOpen(); OleDbCommand cmd = new OleDbCommand(select top + Img_Num.Text.ToString() + * from SlideImg order by id desc, mc.Conn); OleDbDataReader rdr = null; rdr =
13、 cmd.ExecuteReader(); while (rdr.Read() strlnk += rdrlnk.ToString() + |; strpic += rdrpic.ToString() + |; strtxt += rdrtxt.ToString() + |; mc.ConnClose(); Encoding code = Encoding.GetEncoding(UTF-8); StreamReader sr = null; StreamWriter sw = null; string str = ; try sr = new StreamReader(jstemplete, code); str = sr.ReadToEnd(); / 读取文件 catch (Exception exp) HttpContext.Current.Response.Write(script
