第一条 select top 1 * from tb order by id 上一条 select top 1 * from tb where id<@id order by id desc 下一条 select top 1 * from tb where id>@id order by id 最后一条 select top 1 * from tb order by id desc
vs2008的datapager控件可以完美实现 就是麻烦在不能用于不支持分页的控件
分页查询 select top 1 * from tb order by id select top 1 * from tb where id<@id order by id desc select top 1 * from tb where id>@id order by id LINQ FIRST
上一条 select top 1 * from tb where id<@id order by id desc
下一条 select top 1 * from tb where id>@id order by id
最后一条 select top 1 * from tb order by id desc
select top 1 * from tb order by id
select top 1 * from tb where id<@id order by id desc
select top 1 * from tb where id>@id order by id
LINQ FIRST
第一条:dataset.Table[0].rows[0]
下一条:dataset.Table[0].rows[selectedIndex+1]
上一条:dataset.Table[0].rows[selectedIndex-1]
最后一条:dataset.Table[0].rows[dataset.Table[0].rows.count-1]
this.BindingContext[数据源].PositionChanged += new System.EventHandler(this.OnPositionchanged);
public void OnPositionchanged(Object sender, System.EventArgs e)
{
this.btnFirst.Enabled = true;
this.btnPrevious.Enabled = true;
this.btnNext.Enabled = true;
this.btnLast.Enabled = true;
if (this.BindingContext[数据源].Position == 0)
{
this.btnFirst.Enabled = false;
this.btnPrevious.Enabled = false;
}
if (this.BindingContext[数据源].Position == this.BindingContext[this.dscustom, "customer"].Count - 1)
{
this.btnNext.Enabled = false;
this.btnLast.Enabled = false;
}
this.displaynum(); }
public void displaynum()
{
this.lblDatasetPosition.Text = (this.BindingContext[数据源].Position + 1) + "/" + (this.BindingContext[数据源].Count);
}