Hi,
I have the following problem. The web-based software I am to create is going
to display tabular data. Lots of data so I need some pagging mechanism. I
thought about creating three classes: GridView (displayng tabular data),
PaggingControl (displaying [Previous] and [Next] buttons) and DataSource (for
retrieving data from the db. In the database I have following data:
id | column1 | column2
-------------------------------------
1 | data11 | data 12
2 | data21 | data 22
(...)
DataSource class retrieves data basing on three parameters: id, pagesize,
direction. For example DataSource(30, 10, Back) gets records with id 20, 21,
..., 29.
The question is: are there design patterns describing such a problem. Any
solutions you'd recommend?
T. 2 1314
This link will help with your DataClass (accomplishing what you describe is
easier said than done... this article gives you options) http://www.aspfaq.com/show.asp?id=2120
If you are using SQL Server 2005, you have additional options; check with
the SQL Server NG for those.
Otherwise I'm not sure about a specific or well-known pattern of which you
ask.
-HTH
"t" <t@tt.pl> wrote in message news:dr******** **@nemesis.news .tpi.pl... Hi,
I have the following problem. The web-based software I am to create is going to display tabular data. Lots of data so I need some pagging mechanism. I thought about creating three classes: GridView (displayng tabular data), PaggingControl (displaying [Previous] and [Next] buttons) and DataSource (for retrieving data from the db. In the database I have following data:
id | column1 | column2 ------------------------------------- 1 | data11 | data 12 2 | data21 | data 22 (...)
DataSource class retrieves data basing on three parameters: id, pagesize, direction. For example DataSource(30, 10, Back) gets records with id 20, 21, .., 29.
The question is: are there design patterns describing such a problem. Any solutions you'd recommend?
T.
t wrote: Hi,
I have the following problem. The web-based software I am to create is going to display tabular data. Lots of data so I need some pagging mechanism. I thought about creating three classes: GridView (displayng tabular data), PaggingControl (displaying [Previous] and [Next] buttons) and DataSource (for retrieving data from the db. In the database I have following data:
id | column1 | column2 ------------------------------------- 1 | data11 | data 12 2 | data21 | data 22 (...)
DataSource class retrieves data basing on three parameters: id, pagesize, direction. For example DataSource(30, 10, Back) gets records with id 20, 21, .., 29.
The question is: are there design patterns describing such a problem. Any solutions you'd recommend?
In my opinion it depends on how much rows you have to extract. You can
not think to make every time a query (if tables are big) to get the next
recordset, it is more efficient for DB (I am a dba but i like to
develop) if you get all the recordset and then paged it. You can do it
mantainging it in session or directly in javascripts ....I'd look at
technologies like AJAX so you put the work on the browser ....(if you
dont have dialup visitors :) T. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: bobdedogh |
last post by:
can anyone add live hyperlinks to the sortable table made by the code
supplied by Machi, or know of a simple alternative
bob
Machi wrote Mar 10 1999, 8:00 am
>>>>>>>>>>>>>>
....
Hello Harjinder!
|
by: Robin S. |
last post by:
I tried to ask this question several days ago, but I didn't explain my
application correctly.
Basically I want to have one record from table "A" and I want to display,
say, 5 records from table "B" which are specified by the one record from
table "A"... And all on the same form. I do not want to use a subform. The
record fields from table...
|
by: farseer |
last post by:
Here is the scenario:
I have an interface which defines get methods for data that will make
up a row in a table. However, the source of this data may, over time,
switch/change (The company may choose to change data providers).
Therefore i thought to myself, a type of Adapter Pattern is best here
and so i proceeded with that. here's an...
|
by: swoozie |
last post by:
Hello,
I'm trying to display two sets of tabluar data
in two tables. There is a submit button on the
page to launch everything, and a refresh button
to update the tables without having a post-related
dialog pop up. I'm having a problem with some
of Table A's data showing up in Table B. It
occurs when the refresh button is clicked. ...
|
by: Joo Park |
last post by:
Hello,
i have an aspx page that displays data in tabular format.
I'd like to change this page so that it outputs that same data into excel
format.
what needs to change in an aspx page to do that?
thx in advance!
| |
by: t |
last post by:
Hi,
I have the following problem. The web-based software I am to create is going
to display tabular data. Lots of data so I need some pagging mechanism. I
thought about creating three classes: GridView (displayng tabular data),
PaggingControl (displaying and buttons) and DataSource (for
retrieving data from the db. In the database I have...
|
by: teju |
last post by:
Hello,
I have to display all the data from the database in tables in ASP. I am able to get the data but the problem is of displaying one to many relations.Like below Title1 has two records but how would i display in the table
Title1 heading1 heading 2 heading 3
x y x1 y1
a b a1 ...
|
by: Sanders Kaufman |
last post by:
I'm converting my table-based layouts to css-positioned divs - but the
ONLY reason I'm doing it is because it's *considered* a best practice.
I don't really see where anything goes hinky when tables are used - but
I'm doing it anyway because the HTML and CSS specs says to reserve
tables for tabular data.
So as I convert my login widgit to...
|
by: Carona |
last post by:
Hi,
This seems like a simple question, even for someone as green as me, but i'm not sure of how to proceed. I'm working with WM5 and have a simple application with some data that i want to display to the user in a tabular form. For example there will be several lines with columns of id, name, address etc. The data is not taken from a database,...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |