//显示最新的滚动供求信息
protected void ShowScrollGQ()
{
string sqlcon = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString.ToString();
SqlConnection conn = new SqlConnection(sqlcon);
conn.Open();
string sql = "select top 10 X000_ID,X005_FL,X020_GQMC from [Xinxigongqiu] order by X000_ID desc";
string inner = "";
int i = 0;
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader sdr = cmd.ExecuteReader();
inner = "<table style=/"width:100%;/"><tr>";
for (i = 0; i < 10; i++)
{
if (sdr.Read())
{
inner = inner + "<td style=/"white-space:nowrap;height:20px;/">[" + sdr["X005_FL"].ToString().Replace("信息", "") + "] <a href=/"Gq_XinxiYL.aspx?X000_ID=" + sdr["X000_ID"].ToString() + "/" target=/"_blank/" title=/"" + sdr["X020_GQMC"].ToString() + "/">" + sdr["X020_GQMC"].ToString() + "</a> </td>";
}
else
{
inner = inner + "<td style=/"white-space:nowrap;height:20px;/"> </td>";
}
}
inner = inner + "<td> </td></tr></table>";
Response.Write(inner);
conn.Dispose();
}
一段asp.net的滚动显示的代码
最新推荐文章于 2019-03-09 20:31:00 发布