嘎上一篇下一遍的问题
查询数据库的一条数据列如top 1 id>5或id<5;
private string NewMethodNext()
{
string s = Request.QueryString["newsid"];
string sql = "select top 1 newsid ,newsname from news where newsid> ";
sql = sql + s;
SqlConnection objSqlConnection = new SqlConnection("server=127.0.0.1;uid=sa;pwd=1;database=ThpDb");
objSqlConnection.Open();
SqlCommand sqlcom = new SqlCommand(sql, objSqlConnection);
SqlDataReader datareader = sqlcom.ExecuteReader();
string ss = "";
while (datareader.Read())
{
string strid = "";
strid = Convert.ToString(datareader["newsid"]);
string strname=(string)datareader["newsname"];
ss = "<a href=\"news_view.aspx?newsid= " + strid + "\">" + strname + "</a>";
}
datareader.Close();
if (ss=="")
{
ss = "最后一篇了";
}
return ss;