|
What would be a better design for CRUD pagination.
1: Send the Page and Show to the controller and just grab the records needed.
Get the record count first so I have a total, then get the records
2: Get all the records, send them down and use the client to take the ones I need.
Since I have all the records, I can get a count.
3: Or change my model, so I have a column for count, and then shift the records to an array for 1 single call.
If it ain't broke don't fix it
Discover my world at jkirkerx.com
modified 1-Oct-18 18:29pm.
|
|
|
|
|
In most LOB (WPF) applications I have built the number of records is quite limited <1000 usually. So I get the entire data set.
When doing web apps I treat the UI the same as a desktop app IE you can scroll horizontally in a grid but the vertical is a fixed size and the user scrolls WITHIN the grid, never using pagination but implementing filtering.
I know this is anathema to most web developers but I find it much easier to use and control the grid.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I get what your saying.
I have cards or square tiles, 4 across for large displays, 1 for cell phones and a pagination of buttons at the bottom.
I ended up creating a new model with count and an array of records, choosing to create a specific query for skip and take.
It's pretty fast still and just one call for data.
I suppose the question boils down to preference.
If it ain't broke don't fix it
Discover my world at jkirkerx.com
|
|
|
|
|
|
The data tables is very nice. That's slick.
I was going to use a NPM package for Angular. Then I ran across this article called pagination made easy.
Ended up writing a component from almost scratch. Then I got to the controller / back end part and questioned myself.
It wasn't easy at all.
If it ain't broke don't fix it
Discover my world at jkirkerx.com
|
|
|
|
|
Hi Coders,
i'm trying to create an discussion forum similar to msdn-forum/code-project forum in my asp.net Application.
How to do it.
Please help.
|
|
|
|
|
... and please do not post the same question in multiple forums.
|
|
|
|
|
Hi, can anyone tell me what is cell padding, and cell spacing?
|
|
|
|
|
|
Cell padding is so you don't injure yourself, cell spacing is so you can't hear the other inmates.
In other words: padding is space inside the cell, spacing is between the cells.
|
|
|
|
|
cell padding : which specifies the space between cells is called cell padding
cell spacing : controls the space between table cells. Although there is no official default,
browsers usually use a default of 2.
|
|
|
|
|
The cell padding is used to define the spaces between the cells and its border. If cell padding property is not apply then it will be set as default value. The cell spacing is used to define the space between the cells.
|
|
|
|
|
hello can someone help me to add a cache for this query or for a way to optimize it by avoiding the use of SELECT * FROM information_schema to improve the performance of this query
SELECT * FROM information_schema.key_column_usage AS kcu
INNER JOIN information_schema.referential_constraints AS rc
ON ( kcu.constraint_name = rc.constraint_name
AND kcu.constraint_schema = rc.constraint_schema )
WHERE kcu.table_schema = 'joseph79_tiny'
AND kcu.table_name = 'options'
AND rc.table_name = 'options'
SELECT * FROM information_schema.key_column_usage AS kcu
INNER JOIN information_schema.referential_constraints AS rc
ON (
kcu.constraint_name = rc.constraint_name
AND kcu.constraint_schema = rc.constraint_schema ) wh ere kcu.table_schema = 'joseph79_tiny'
AND kcu.table_name = 'links'
AND rc.table_name = 'links'
|
|
|
|
|
Add another join condition
and kcu.tablename = rc.tablename
and remove the last line of the filters
Also Select * from ... is not your problem other than you are getting all fields from both tables
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
|
website tables to CSS
Trying to convert from tables to CSS to make a responsive website.
This should be 4 vertical colums, instead it is 1 verticle column.
Where did I go wrong ??
Thank You
falcon
<style type="text/css">
.lfcol { float:left;width:19.8%;margin-bottom:5px; }
.micol { float:left;width:19.8%;margin-bottom:5px; }
.rmicol { float:right;width:19.8%;margin-bottom:5px; }
.ricol { float:right;width:19.8%;margin-bottom:5px; }</style>
<h2 class="clear">Old Testament</h2>
<!-- left column -->
<dl class=".lfcol"><font size="+2">
<dt> 1 <a href="01_001.htm">Genesis</a></dt>
<dt> 2 <a href="02_001.htm">Exodus</a></dt>
<dt> 3 <a href="03_001.htm">Leviticus</a></dt>
<dt> 4 <a href="04_001.htm">Numbers</a></dt>
<dt> 5 <a href="05_001.htm">Deuteronomy</a></dt>
<dt> 6 <a href="06_001.htm">Joshua</a></dt></dl>
<!-- middle column -->
<dl class=".micol">
<dt> 7 <a href="07_001.htm">Judges</a></dt>
<dt> 8 <a href="08_001.htm">Ruth</a></dt>
<dt> 9 <a href="09_001.htm">1 Samuel</a></dt>
<dt> 10 <a href="10_001.htm">2 Samuel</a></dt>
<dt> 11 <a href="11_001.htm">1 Kings</a></dt>
<dt> 12 <a href="12_001.htm">2 Kings</a></dt></dl>
<!-- right middle column -->
<dl class=".rmicol">
<dt> 13 <a href="13_001.htm">1 Chronicles</a></dt>
<dt> 14 <a href="14_001.htm">2 Chronicles</a></dt>
<dt> 15 <a href="15_001.htm">Ezra</a></dt>
<dt> 16 <a href="16_001.htm">Nehemiah</a></dt>
<dt> 17 <a href="17_001.htm">Esther</a></dt>
<dt> 18 <a href="18_001.htm">Job</a></dt></dl>
<!-- right column -->
<dl class=".ricol">
<dt> 19 <a href="19_001.htm">Psalms</a></dt>
<dt> 20 <a href="20_001.htm">Proverbs</a></dt>
<dt> 21 <a href="21_001.htm">Ecclesiastes</a></dt>
<dt> 22 <a href="22_001.htm">Song of Solomon</a></dt>
<dt> 23 <a href="23_001.htm">Isaiah</a></dt>
<dt> 24 <a href="24_001.htm">Jeremiah</a></dt></dl>
|
|
|
|
|
|
Hello,
I am currently creating a website in the trial mode of squarespace. I had some trouble doing the things I wanted to do just using the squarespace templates, so I resorted to codes. I do not know much about codes and what I have got done so far is from researching online.
Basically what I have so far is an image with 4 icon images on top of it. (in code) I want to make it so when you hover over each of the of the icons a box from the left slides in and has text information regarding that icon. I want it to slide in from the left of the whole page, not just the picture these 4 icons are on. I cannot for the life of me figure this out.
Below is currently what I have done to create a picture with 4 images and some text on top. I have tried for 2 days to figure out where to ad in the overlay/hover "stuff" but it hasn't worked. I was up till 2 am last night trying different things. If someone could help would be greatly appreciated. Hope this all makes sense. P.S. I don't have any code in here for overlay/hover as it was not working. ANd I am using the Moshka template.
<html>
<head>
<style>
.doggrass
{
position: relative;
top: 0;
left: 0;
}
.bathtub
{position: absolute;
top: 190px;
left: 70px;}
.parkaccess
{position: absolute;
top: 190px;
right:70px}
.discounts
{position: absolute;
bottom:290px;
left:70px }
.events
{position: absolute;
bottom:290px;
right: 70px}
.dogpaw1
{position: absolute;
top:20px;
left: 15px}
.dogpaw2
{position: absolute;
top:365px;
left:15px}
.dogpaw3
{position: absolute;
top:500px;
left:15px}
.bottom-left
{position: absolute;
text-align: center;
color: white;
bottom: 275px;
left: 62px}
.top-left
{position: absolute;
color: white;
text-align: center;
top: 235px;
left: 77px;}
.top-right
{position: absolute;
text-align: center;
color: white;
top: 235px;
right: 58px;}
.bottom-right
{position: absolute;
text-align:ceter;
color:white;
bottom: 275px;
right: 74px;}
.top-left2
{position: absolute;
text-align: left;
color:white;
font-family:impact;
top: 20px;
left: 50px;
right:50px }
.top-left3
{position:absolute;
text-align: left;
color: white;
top:95px;
left: 50px}
.bottom-right2
{position:absolute;
text-align: left;
font-family:impact;
color: white;
left:50px;
top:365px;}
.bottom-right3
{position: absolute;
text-align:left;
color:white;
left:50px;
top:395px;}
.bottom-right4
{position:absolute;
text-align:left;
color:white;
font-family:impact;
left:50px;
top:500px}
.bottom-left2
{position:absolute;
text-align:left;
color:white;
left:50px;
top:530px}
</style>
</head>
<body>
<img src="https://static1.squarespace.com/static/5b8f261d5417fc3f4ba18707/t/5b9741d9575d1f202ba0b496/1536639456655/black+dog+3.jpg" width=400px; height=600px class="doggrass">
<img src="https://static1.squarespace.com/static/5b8f261d5417fc3f4ba18707/t/5b96e0140e2e72b75cc40cea/1536614420600/white+bath.png" width=50px; height=50px class="bathtub">
<img src= https://static1.squarespace.com/static/5b8f261d5417fc3f4ba18707/t/5b96dfe68985831b924b15ad/1536614374362/icons8-dog-park-90.png width=50px; height=50px class="parkaccess"/>
<img src=https://static1.squarespace.com/static/5b8f261d5417fc3f4ba18707/t/5b96e01c0ebbe8ed91e62809/1536614428465/white+event.png width=50px; height=50px class="events"/>
<img src=https://static1.squarespace.com/static/5b8f261d5417fc3f4ba18707/t/5b96dffb4ae2373cac59e9ab/1536614395019/icons8-pricing-96.png width=50px ; height=50px class="discounts"/>
<img src=https://static1.squarespace.com/static/5b8f261d5417fc3f4ba18707/t/5b9745d91ae6cfbcdbd3a5ac/1536640473741/icons8-cat-footprint-filled-100.png width=25px; height=25px class="dogpaw1"/>
<img src=https://static1.squarespace.com/static/5b8f261d5417fc3f4ba18707/t/5b9745d91ae6cfbcdbd3a5ac/1536640473741/icons8-cat-footprint-filled-100.png width=25px; height=25px class="dogpaw2"/>
<img src=https://static1.squarespace.com/static/5b8f261d5417fc3f4ba18707/t/5b9745d91ae6cfbcdbd3a5ac/1536640473741/icons8-cat-footprint-filled-100.png width=25px; height=25px class="dogpaw3"/>
<div class="bottom-left"><font size="">Discounts</font></div>
<div class="top-left"><font size="">Baths</font></div>
<div class="top-right"><font size="">Park Access</font></div>
<div class="bottom-right"><font size ="">Events</font></div>
<div class="top-left2"><font size="6">Membership Benefits</font></div>
<div class="top-left3"><font size="4">Hover over icons below for more information</font></div>
<div class="bottom-right2"><font size="6">Park Hours</font></div>
<div class="bottom-right3"><font size="4">Monday-Friday 6AM-10PM</br> Saturday/Sunday 7AM-11PM</font></div>
<div class="bottom-right4"><font size="6">Our Location</font></div>
<div class="bottom-left2"><font size="4">Ridge Road 2210 </br>View Map</font>
</div>
</div>
</body>
</html>
modified 12-Sep-18 3:25am.
|
|
|
|
|
Hi Experts,
Can any one post me the code to bypass MFA and access the site which is launched in AWS server.
TIA
|
|
|
|
|
Sorry, this site does not provide code to order. Especially not code that tries to breach security.
|
|
|
|
|
hello again...
My NA area's website (due to launch next month) has a Meeting Schedule page, navigated to from the MEETINGS link in the main nav bar on the home page: http://www.moonjams.net/BurlCoNA-VII.html. That schedule has Tabs for every day of the week. My idea was to have the Tab open for the particular day of the week it happens to be (i.e., if it's Monday, I wanted the Monday Tab to automatically open when the schedule page is navigated to). Right now...no matter the day of the week...it always opens on 'Sunday'.
Can someone please help w/ this...???...this is the last task I need to have accomplished prior to launching the site (other than populating the various pages).
thanx very much,
Dox
|
|
|
|
|
Help how exactly? We have no idea what your code is doing.
|
|
|
|
|
i have a website designed in php/ajax and im in need of a push to talk button for the voice video chat portion of my site. any ideas?
|
|
|
|
|
I am developing a plugin that creates two pages on installation and assigns them templates. now I want to call one page(template) through a form on the other page(template). I tried some snippets but no response.
here is the form that will call the other page on submit
<form action="">
<input type="text" class="form-control input-lg" placeholder="Movie Name" />
<button class="btn btn-info btn-lg" type="submit">
class="glyphicon glyphicon-search">
</button>
</form>
I don't know how to do it as WordPress is generic and anybody might use this plugin, so if I put the manual link of the page then everybody will be redirected to my page so how can I do it?
|
|
|
|
|
I have a web application that is a knowledge base- I do login - once i am in it
when I get to the part of Upload Files
The windows gets opened - but I can not find that particular window to send the list of files I want to get opened -
1. How can identify that windows with code C# or VB?
2. Do you have a routine to upload a list of files from a particula directory to a web application?
Thank you!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
