Questions tagged [data-paging]
72 questions
0
votes
1 answer
How to prevent shifting of paged data in a REST API result set
I am trying to implement a REST API endpoint that will return a set of entities, optionally filtered using various query parameters. Since the result set may be large, the endpoint will also support paging, using limit and offset query…
Tim Coulter
- 8,705
- 11
- 64
- 95
0
votes
1 answer
How to create Paging in Yii2?
I want to create a line of code to create paging in my Web Service with Yii2 and I want the results like in Api The Movie there is param page=1. After I made the observation on Google, I found a way to make paging by adding limit and offsets in my…
user8442578
0
votes
1 answer
Null bitmap is set when there is no null columns
I am learning PAGE structure and currently I'm stuck at the NULL bitmaps.
create table dbo.ro
(
ID int not null,
Col1 varchar(8000) null,
Col2 varchar(8000) null
);
insert into dbo.ro(ID, Col1, Col2)…
Dmitrij Kultasev
- 5,447
- 5
- 44
- 88
0
votes
1 answer
Missing bytes in SQL Server data page
Did not know how to call the Title properly. However, I am trying to understand how the data pages are stored. I've created simple table:
CREATE TABLE testFix
(
id INT,
v CHAR(10)
);
INSERT INTO dbo.testFix
(
id,
v
)
VALUES
( 1, -- id -…
Dmitrij Kultasev
- 5,447
- 5
- 44
- 88
0
votes
2 answers
Paging data and get row count with out considering the page number in stored procedure
I am using SQL Server 2012. I need to do paging in my stored procedure. In client side (Web page), I need to have the result of the stored procedure for requested page and also I need to have the row count without considering the page number for…
Ardalan Shahgholi
- 11,967
- 21
- 108
- 144
0
votes
1 answer
control that has paging but supports custom format
i need to know what control in asp .net 2.0 to use to get this layout:
i need to display 8 videos at a time using 2 rows with 4 columns, but the control should also have paging (to display 8 items per page).
i've thought of using a formview but the…
iceheaven31
- 877
- 1
- 13
- 23
0
votes
1 answer
Ice faces datapaginator doesn´t work
I have a problem with an ice:dataPaginator.
It shows correctly the number of rows in my datatable also shows correctly the current page, but when I press the next page icon nothings happens, in others words if I have 23 rows it shows correctly the…
RicardoP
- 1
- 4
0
votes
1 answer
SQL ce data paging possible?
Is there a way to implement data paging with sql ce? It would be for windows mobile app.
Currently using the sql compact edition 3.5. Also using the Microsoft Sync Framework ADO.net v1.0 for device.
pdiddy
- 6,217
- 10
- 50
- 111
0
votes
2 answers
Is there a way to get just the first page of data from a long-running SQL Server stored procedure?
My ultimate need is to present some reports (the results of SQL Server stored procedures) on Web API pages.
The challenge is that the stored procedures that return this data are very slow - sometimes taking several minutes to run. No user in their…
B. Clay Shannon-B. Crow Raven
- 8,547
- 144
- 472
- 862
0
votes
1 answer
How to make server-side paging in datatable?
I am using MVC. I have large amount of data and I need to have data only with paging limit. For example, if page size is 10 I want to get only top 10 records in my database.
Here is my html :
