做的一个网站 图片取自数据库。在页面上内容取到了!但是不知道为什么没有显示。
以下是代码部分。
后台:
private void get_tpxw()//这里是在load里面显示的方法
{
string siteserver = ConfigurationManager.AppSettings["site_server"].ToString();
string sql = "select top 7 * from pg_news order by news_editdate desc";
SqlDataReader sdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql, null);
string ntts = "var titles = '";
string npics = "var imgs = '";
string nlks = "var urls = '";
ntts = ntts.Substring(0, ntts.Length - 1);
npics = npics.Substring(0, npics.Length - 1);
nlks = nlks.Substring(0, nlks.Length - 1);
string jsstr = "<script language='javascript' type='text/javascript'>";
//string jsstr = "";
string divstr = "";
int i = 1;
while (sdr.Read())
{
if (i <= 5)
{
string picurl = siteserver + sdr["news_pic"].ToString();
if (sdr["news_pic"].ToString() != "" && sdr["news_pic"].ToString() != null)
{
//picurl = "new_pic";
//picurl = siteserver + sdr["news_pic"].ToString();
}
else
{
picurl = "images/ad1.jpg";
} jsstr = jsstr + "imgUrl" + i.ToString() + " = \"" + picurl + "\";";
jsstr = jsstr + "imgtext" + i.ToString() + " = \"" + sdr["news_title"].ToString() + "\";";
jsstr = jsstr + "imgLink" + i.ToString() + " = escape(\"" + sdr["news_link"].ToString() + "\");";
i = i + 1; }
}
sdr.Close();
jsstr = jsstr + ntts + "';";
jsstr = jsstr + npics + "';";
jsstr = jsstr + nlks + "';"; jsstr = jsstr + "var pw = 348;";
jsstr = jsstr + "var ph = 198;";
jsstr = jsstr + "var sizes = 14;";
jsstr = jsstr + "var Times = 4000;";
jsstr = jsstr + "var umcolor = 0xFFFFFF;";
jsstr = jsstr + "var btnbg = 0xFF7E00;";
jsstr = jsstr + "var txtcolor = 0xFFFFFF;";
jsstr = jsstr + "var txtoutcolor = 0x000000;";
jsstr = jsstr + "var flash = new SWFObject('flash/focus1.swf', 'mymovie', pw, ph, '7', '');";
jsstr = jsstr + "flash.addParam('allowFullScreen', 'true');";
jsstr = jsstr + "flash.addParam('allowScriptAccess', 'always');";
jsstr = jsstr + "flash.addParam('quality', 'high');";
jsstr = jsstr + "flash.addParam('wmode', 'Transparent');";
jsstr = jsstr + "flash.addVariable('pw', pw);";
jsstr = jsstr + "flash.addVariable('ph', ph);";
jsstr = jsstr + "flash.addVariable('sizes', sizes);";
jsstr = jsstr + "flash.addVariable('umcolor', umcolor);";
jsstr = jsstr + "flash.addVariable('btnbg', btnbg);";
jsstr = jsstr + "flash.addVariable('txtcolor', txtcolor);";
jsstr = jsstr + "flash.addVariable('txtoutcolor', txtoutcolor);";
jsstr = jsstr + "flash.addVariable('urls', urls);";
jsstr = jsstr + "flash.addVariable('Times', Times);";
jsstr = jsstr + "flash.addVariable('titles', titles);";
jsstr = jsstr + "flash.addVariable('imgs', imgs);";
jsstr = jsstr + "flash.write('dplayer2');";
jsstr = jsstr + "</script>"; fjs.Controls.Add(new LiteralControl(jsstr));
}
接下来是前台部分的源码
<div class="gray_blue" style="width: 310px; height: 195px; float:left;">
<div style="height: 10px;">
</div>
<div style="float: left; margin-left: 10px;">
<div id="fjs" runat="server"></div> </div>
</div>请各位大侠指点下!
以下是代码部分。
后台:
private void get_tpxw()//这里是在load里面显示的方法
{
string siteserver = ConfigurationManager.AppSettings["site_server"].ToString();
string sql = "select top 7 * from pg_news order by news_editdate desc";
SqlDataReader sdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, sql, null);
string ntts = "var titles = '";
string npics = "var imgs = '";
string nlks = "var urls = '";
ntts = ntts.Substring(0, ntts.Length - 1);
npics = npics.Substring(0, npics.Length - 1);
nlks = nlks.Substring(0, nlks.Length - 1);
string jsstr = "<script language='javascript' type='text/javascript'>";
//string jsstr = "";
string divstr = "";
int i = 1;
while (sdr.Read())
{
if (i <= 5)
{
string picurl = siteserver + sdr["news_pic"].ToString();
if (sdr["news_pic"].ToString() != "" && sdr["news_pic"].ToString() != null)
{
//picurl = "new_pic";
//picurl = siteserver + sdr["news_pic"].ToString();
}
else
{
picurl = "images/ad1.jpg";
} jsstr = jsstr + "imgUrl" + i.ToString() + " = \"" + picurl + "\";";
jsstr = jsstr + "imgtext" + i.ToString() + " = \"" + sdr["news_title"].ToString() + "\";";
jsstr = jsstr + "imgLink" + i.ToString() + " = escape(\"" + sdr["news_link"].ToString() + "\");";
i = i + 1; }
}
sdr.Close();
jsstr = jsstr + ntts + "';";
jsstr = jsstr + npics + "';";
jsstr = jsstr + nlks + "';"; jsstr = jsstr + "var pw = 348;";
jsstr = jsstr + "var ph = 198;";
jsstr = jsstr + "var sizes = 14;";
jsstr = jsstr + "var Times = 4000;";
jsstr = jsstr + "var umcolor = 0xFFFFFF;";
jsstr = jsstr + "var btnbg = 0xFF7E00;";
jsstr = jsstr + "var txtcolor = 0xFFFFFF;";
jsstr = jsstr + "var txtoutcolor = 0x000000;";
jsstr = jsstr + "var flash = new SWFObject('flash/focus1.swf', 'mymovie', pw, ph, '7', '');";
jsstr = jsstr + "flash.addParam('allowFullScreen', 'true');";
jsstr = jsstr + "flash.addParam('allowScriptAccess', 'always');";
jsstr = jsstr + "flash.addParam('quality', 'high');";
jsstr = jsstr + "flash.addParam('wmode', 'Transparent');";
jsstr = jsstr + "flash.addVariable('pw', pw);";
jsstr = jsstr + "flash.addVariable('ph', ph);";
jsstr = jsstr + "flash.addVariable('sizes', sizes);";
jsstr = jsstr + "flash.addVariable('umcolor', umcolor);";
jsstr = jsstr + "flash.addVariable('btnbg', btnbg);";
jsstr = jsstr + "flash.addVariable('txtcolor', txtcolor);";
jsstr = jsstr + "flash.addVariable('txtoutcolor', txtoutcolor);";
jsstr = jsstr + "flash.addVariable('urls', urls);";
jsstr = jsstr + "flash.addVariable('Times', Times);";
jsstr = jsstr + "flash.addVariable('titles', titles);";
jsstr = jsstr + "flash.addVariable('imgs', imgs);";
jsstr = jsstr + "flash.write('dplayer2');";
jsstr = jsstr + "</script>"; fjs.Controls.Add(new LiteralControl(jsstr));
}
接下来是前台部分的源码
<div class="gray_blue" style="width: 310px; height: 195px; float:left;">
<div style="height: 10px;">
</div>
<div style="float: left; margin-left: 10px;">
<div id="fjs" runat="server"></div> </div>
</div>请各位大侠指点下!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货