现有的项目么有 简单的思路就是: 下一篇select top 1 * from table1 where id>@id order by id 上一篇select top 1 * from table1 where id <@id order by id desc 或使用LINQ 排序skip,take(1)
SQL语句我自己写出来了!就是不会用,所以才想看下源代码,学习一下
//下一条: select top 1 from tb where id > 知道的ID值 order by id asc//上一条: select top 1 from tb where id < 知道的ID值 order by id desc
</table> </div> </form> public string Title = string.Empty; public string Content = string.Empty; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataBind(0); } } private void DataBind(int pageIndex) { var list = new[] { new {Title="1",Content="标题1"}, new {Title="2",Content="标题2"}, new {Title="3",Content="标题3"} }.ToList(); Title = list[pageIndex].Title; Content = list[pageIndex].Content; } protected void Button1_Click(object sender, EventArgs e) { DataBind(0); } protected void Button2_Click(object sender, EventArgs e) { DataBind(1); } protected void Button3_Click(object sender, EventArgs e) { DataBind(2); }
这不就是上一页下一页的问题吗 csdn里有我发过的代码
select T_SavePath,T_FileName,T_NoteTitle from [T_Note_Info] where T_NoteID = (select MAX(T_NoteID) from [T_Note_Info] where T_NoteID<@T_NoteID)select T_SavePath,T_FileName,T_NoteTitle from [T_Note_Info] where T_NoteID = (select MIN(T_NoteID) from [T_Note_Info] where T_NoteID>@T_NoteID)注意一点:如果是生成静态页面的话,每次新添加数据的时候你是需要把新添加的这条数据的前面那条重新生成下,不然的话因为上一条数据在你还没添加这最后一跳数据的时候,它就是最后一条,也就没有所谓的下一条,
简单的思路就是:
下一篇select top 1 * from table1 where id>@id order by id
上一篇select top 1 * from table1 where id <@id order by id desc
或使用LINQ 排序skip,take(1)
//下一条:
select top 1 from tb
where id > 知道的ID值
order by id asc//上一条:
select top 1 from tb
where id < 知道的ID值
order by id desc
<div>
<table>
<tr>
<td>
<%=Title %>
</td>
</tr>
<tr>
<td>
<%=Content %>
</td>
</tr>
<tr>
<td>
<asp:Button ID="Button1" runat="server" Text="1" onclick="Button1_Click" />
<asp:Button ID="Button2" runat="server" Text="2" onclick="Button2_Click" />
<asp:Button ID="Button3" runat="server" Text="3" onclick="Button3_Click" />
</td>
</tr>
</table>
</div>
</form>
public string Title = string.Empty;
public string Content = string.Empty; protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataBind(0);
}
} private void DataBind(int pageIndex)
{
var list = new[] {
new {Title="1",Content="标题1"},
new {Title="2",Content="标题2"},
new {Title="3",Content="标题3"}
}.ToList();
Title = list[pageIndex].Title;
Content = list[pageIndex].Content;
}
protected void Button1_Click(object sender, EventArgs e)
{
DataBind(0);
}
protected void Button2_Click(object sender, EventArgs e)
{
DataBind(1);
}
protected void Button3_Click(object sender, EventArgs e)
{
DataBind(2);
}
select T_SavePath,T_FileName,T_NoteTitle from [T_Note_Info] where T_NoteID = (select MAX(T_NoteID) from [T_Note_Info] where T_NoteID<@T_NoteID)select T_SavePath,T_FileName,T_NoteTitle from [T_Note_Info] where T_NoteID = (select MIN(T_NoteID) from [T_Note_Info] where T_NoteID>@T_NoteID)注意一点:如果是生成静态页面的话,每次新添加数据的时候你是需要把新添加的这条数据的前面那条重新生成下,不然的话因为上一条数据在你还没添加这最后一跳数据的时候,它就是最后一条,也就没有所谓的下一条,