Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
toddhd
Yak Posting Veteran
55 Posts |
 Posted - 2009-02-26 : 09:09:22
|
Ok, this might be an odd question, but here ya go...I have a web app with a paged grid. The grid shows (for example) shows 10 rows of data at a time. The problem I'm having is this - let's say I have 12 records. Page 1 of the grid shows 10 rows, while page 2 shows only 2 rows. This means that the height of the grid changes drastically, and this looks/feels ugly. So I want to append 8 blank rows to page 2 so that it also has 10 rows? Get it?Doing this programatically is starting to become troublesome, and if we switch to another type of grid control in the future, we'll have to do it all over again. That makes me wonder if I can just have SQL return the blank rows? So... if I were to create a stored procedure that took in a page size and number of pages, is there a way that I can calculate and add the appropriate number of blank rows? Can you even add a blank row in SQL? -Todd Davis |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-02-26 : 11:14:49
|
| rather than appending blank rows, you should probably put the grid in some container - perhaps a <div> or some table with fixed height..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-03-02 : 04:46:57
|
quote:
Originally posted by dinakar
rather than appending blank rows, you should probably put the grid in some container - perhaps a <div> or some table with fixed height..Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/
I agree with you. There should be some way to fix the number of rows for a gridMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
How to return additional blank rows?