無景

 

@上一筆

 

SELECT * FROM ( SELECT ROW_NUMBER() OVER(ORDER BY Createtime) AS Sort, PK FROM TableName ) TempM 

 WHERE Sort = 
 ( 
  select sort from( 
  SELECT ROW_NUMBER() OVER(ORDER BY Createtime) AS Sort,PK  FROM TableName 
  ) tmps 
 WHERE PK=@PK
  ) 
  - 1 

@下一筆

 SELECT * FROM ( SELECT ROW_NUMBER() OVER(ORDER BY Createtime) AS Sort, PK FROM TableName ) TempM 
 WHERE Sort = 
 ( 
  select sort from( 
  SELECT ROW_NUMBER() OVER(ORDER BY Createtime) AS Sort,PK  FROM TableName 
  ) tmps 
 WHERE PK=@PK
  ) 
  + 1 

@注意事項 

1.一定要有PK 如果mode=UPD 才能開啟btn

2.判別 ds.table[0].rows.count>0 

if (ds.Tables[0].Rows.Count > 0)
                return ds.Tables[0].Rows[0]["PKID"];
            else
                return "";

3.判別回傳的PK 顯示message

if (!string.IsNullOrEmpty(PK))
            formload(mybo.queryCrtExamMByPK(PK));
        else
        {
            AlertMessage.ShowMessage(this.Page, UpdatePanel1, "無上一筆資料！");
        }