StringBuilder-Append解决DIV字符串输出数据库数据

protected void DataHuanBind()
    {
        //焦点新闻
        StringBuilder StrSql = new StringBuilder();

        StrSql.Append("select top 3 id,title,newsurl,lanternurl,classid from hotel_news where ");
        StrSql.Append("ischeck=1 and isenglish=0 and islantern=1");
        StrSql.Append(" order by id desc");

        SqlDataReader sdr = SqlHelper.ExecuteReader(StrSql.ToString());

        StringBuilder builder1 = new StringBuilder();
        StringBuilder builder2 = new StringBuilder();
        StringBuilder builder3 = new StringBuilder();

        while (sdr.Read())
        {
            builder1.Append(",");
            builder1.Append(sdr.GetString(sdr.GetOrdinal("lanternurl")));
            builder2.Append(",");
            builder2.Append("<a class=\"bla\" href=\"");
            builder2.Append(GetUrl(sdr.GetString(sdr.GetOrdinal("newsurl")), sdr.GetInt32(sdr.GetOrdinal("classid"))));
            builder2.Append("\" target=\"_blank\"><strong>");
            builder2.Append(sdr.GetString(sdr.GetOrdinal("title")));
            builder2.Append("</strong></a>");
            builder3.Append(",");
            builder3.Append(GetUrl(sdr.GetString(sdr.GetOrdinal("newsurl")), sdr.GetInt32(sdr.GetOrdinal("classid"))));
        }
        sdr.Close();

        if (builder1.Length > 0)
        {
            builder1.Remove(0, 1);
            builder2.Remove(0, 1);
            builder3.Remove(0, 1);

            picurl = builder1.ToString().Split('','');
&nb

凌众科技专业提供服务器租用、服务器托管、企业邮局、虚拟主机等服务，公司网站：http://www.lingzhong.cn 为了给广大客户了解更多的技术信息，本技术文章收集来源于网络,凌众科技尊重文章作者的版权，如果有涉及你的版权有必要删除你的文章，请和我们联系。以上信息与文章正文是不可分割的一部分,如果您要转载本文章,请保留以上信息，谢谢!