목록페이징 (2)

DJ메탈짱™의 Free Style

[MS-SQL] 이전글, 다음글, 처음글, 마지막글, Min, Max, Prev, Next (페이징)

-- 이전글 SELECT TOP 1 MEMO_ID, MEMO FROM TB_CMM_MEMO WHERE MEMO_ID = ( SELECT MAX(MEMO_ID) FROM TB_CMM_MEMO WHERE MEMO_ID 9 AND EMPLOYEE_NUMBER = @EMPLOYEE_NUMBER ) -- 마지막글 SELECT TOP 1 MEMO_ID, MEMO FROM TB_CMM_MEMO WHERE MEMO_ID = ( SELECT MAX(MEMO_ID) FROM TB_CMM_MEMO AND EMPLOYEE_NUMBER = @EMPLOYEE_NUMBER ) -- 처음글 SELECT TOP 1 MEMO_ID, MEMO FROM TB_CMM_MEMO WHERE MEMO_ID = ( SELECT MIN(MEMO_ID..
일(job)/DBMS 2016. 1. 14. 15:42
[ASP.NET] GridView 페이징 (SqlDataSource 컨트롤 사용안함)

1. ASPX 2. ASPX.CS private void GridViewBind() { SqlCommand cmdOrders = new SqlCommand(); cmdOrders.Connection = Con; cmdOrders.CommandText = "SELECT * FROM Orders"; cmdOrders.Parameters.Add("@OrderID", SqlDbType.VarChar, 10); cmdOrders.Parameters["@OrderID"].Value = strOrderID.Text ; DataSet dsMain = new DataSet(); SqlDataAdapter daOrders = new SqlDataAdapter(cmdOrders); daOrders.Fill(dsMain, "..
일(job)/MS(Microsoft) 2015. 11. 15. 14:22
이전 Prev 1 Next 다음