111,126
社区成员
发帖
与我相关
我的任务
分享
protected string sub;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
infor();
}
}
public string infor()
{
SqlConnection ACconn;
datalink a = new datalink();
ACconn = a.GetConnection();
//打开数据库
ACconn.Open();
string infor = null;//新闻主体
//定义SQL语句
string ACsql = "select top 9 * from news order by id desc"; ;
//创建Command对像
SqlCommand ACcomm = new SqlCommand(ACsql, ACconn);
//通过执行Command实例化DataReader类
SqlDataReader ACdr = ACcomm.ExecuteReader();
while (ACdr.Read())//循环读取
{
sub = ACdr["Title"].ToString();
if (sub.Length > 18)
{
sub = sub.Remove(18, sub.Length - 18);
}
// infor+="*"+" ";
infor += "<ul>" + "<li>" + "<a href='news.aspx?id=" + ACdr["id"] + "' target=_blank>" + sub + "</a>" + "</li>" + "</ul>";
//infor+="<br>";//行间距
}
ACdr.Close();//切记一定要关闭阅读器
ACconn.Close();
return infor;
// }
}