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>