用html构造来代替Gridview

来源:互联网 发布:大数据与国家安全 编辑:程序博客网 时间:2024/06/05 05:22

 

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Data.SqlClient;

 

public partial class TEST_TEST : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

        SqlConnection connection = new lhpub().getConnection();

        string cmdText = "select top 6 '<li><span>'+Convert(varchar(10),Crdt,120)+'</span> <a title='''+title+''' target=_blank  href=''type.aspx?iid='+convert(varchar(20),iid,120)+'''>'+dbo.minititle(title,15)+'</a></li>'aa from vw_oa_news where result='同意' and type not in(3,8,9,10,11) order by crdt desc ";

        SqlCommand cmd = new SqlCommand(cmdText, connection);

        SqlDataReader reader = lhpub.SqlExcuteReader(cmd);

 

        Response.Write(getlistdata(reader));

        connection.Close();

    } 

    private string getlistdata(SqlDataReader reader)

    {

        string temp=string.Empty;

        while (reader.Read())

        {

            temp += reader.GetString(0);

        }

        return temp;

    }

 

 

}

 

 

 

 

目标HTML

 

<li>

<span>2010-11-16</span> 

<a title='tttttttttttttt' target=_blank  href='type.aspx?iid=21378'>tttttttttttttt</a>

</li>

 

 

<li>

<span>2010-08-17</span> 

<a title='流动人口育龄妇女 首个健康基金成立 ' target=_blank  href='type.aspx?iid=21323'>流动人口育龄妇女 首个健康基金...</a>

</li>