62,266
社区成员
发帖
与我相关
我的任务
分享
<div id="templatemo_main">
<div id="gallery">
<ul>
<% =liHtml%>
</ul>
<div class="cleaner"></div>
</div>
CS文件
protected string hthtml = "";
protected string liHtml = "";
protected string noticeHtml = "";
protected void Page_Load(object sender, EventArgs e)
{
string cisql = "select * from XX ";//读取数据表
DataTable table = SqlDataAdapterDt(cisql);
string imageUrl ="";
string imagesuolue = "";
foreach (DataRow row in table.Rows)//循环表的行
{
string isUser = row["Url"].ToString();
string shuoming=row["shuoming"].ToString();
//if (isUser == "False") imageUrl = "images/table.gif";
//else imageUrl = "images/table_3.jpg";
imageUrl = "image/"+isUser+"";
imagesuolue = "images/"+isUser+"";
liHtml += "<li><a href="+imageUrl+" title="+shuoming+"><span></span><img src="+imagesuolue+"></a><em></em></li>"; //将前台HTML写入字符串变量liHtml
}
//读取Notice
}
public DataTable SqlDataAdapterDt(string sql)
{
//查询一个表之后
string Conn = ConfigurationManager.ConnectionStrings["connstr"].ConnectionString;
SqlConnection myConn = new SqlConnection(Conn);
SqlCommand cmd = new SqlCommand(sql, myConn);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adapter.Fill(dt);
return dt;
}