后台: conn=new DBConnection(); //填写你自己的连接字符串,此处是我定义的一个类 string strSQL="select TOP 8 * from news_view where lm_id=11 order by riqi DESC"; DataSet list_ds=conn.CreateDataSet(strSQL,"DataList_Focus");//传递sql语句 DataTable list_table =list_ds.Tables["DataList_Focus"];//指定datalist数据源 DataList_Focus.DataSource =list_table; DataList_Focus.DataBind();
<TABLE CELLSPACING="0" CELLPADDING="0" BORDER="0" WIDTH="100%">
<TR height="20">
<TD width="12"><li></TD>
<TD align="left" width="340"><a target="_blank" href='<%# "news_nr.aspx?news_id=" + DataBinder.Eval(Container, "DataItem.news_id") %>' title='<%# DataBinder.Eval(Container, "DataItem.title") %>' ><%# Title_limit((string)(DataBinder.Eval(Container.DataItem,"title")).ToString(),25) %></a></TD>
<TD align="right" width="150"><FONT color="#000000">【<%# (string)DataBinder.Eval(Container.DataItem,"riqi").ToString()%>】</FONT></TD>
</TR>
</TABLE>
conn=new DBConnection(); //填写你自己的连接字符串,此处是我定义的一个类
string strSQL="select TOP 8 * from news_view where lm_id=11 order by riqi DESC";
DataSet list_ds=conn.CreateDataSet(strSQL,"DataList_Focus");//传递sql语句
DataTable list_table =list_ds.Tables["DataList_Focus"];//指定datalist数据源
DataList_Focus.DataSource =list_table;
DataList_Focus.DataBind();