473,770 Members | 1,743 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

displaying records with many fields

Hi,
I need to display records with lots of fields. When placed in a grid, a row
of data will scroll off the screen. Not exactly what I'm looking for. I've
also used a datalist, which allows multiple lines for a single row of data
(yes! no horizontal scrolling!), but columns do not line up across
listitems/data rows (very ugly & distracting - maybe there's some way to get
the items to line up, but I haven't found it). This has to be a common UI
problem, and I was wondering how others have handled it. Any ideas?
Nov 19 '05 #1
5 1403
Jon
I have spent much time myself looking for a perfect grid. I agree its a
common problem in the stuff I do as well, but there do not seem to be a lot
of elegant solutions about.

This is the kind of think you need
http://www.activewidgets.com/

I have had this one recommended to me a few times
http://www.infragistics.com/products...rms/Grids.aspx

http://webfx.eae.net/dhtml/grid/intro.html
(try out the demo and resize a column. the horizontal scrollbar becomes
active)

An article on how to write the code from scratch
http://www.webreference.com/programm...pt/gr/column4/

Let us know how you go and what solution you finally decide on

Jon
"Lisa Calla" <sp*********@he rplace.com> wrote in message
news:l5******** *************** *******@eatel.n et...
Hi,
I need to display records with lots of fields. When placed in a grid, a
row of data will scroll off the screen. Not exactly what I'm looking for.
I've also used a datalist, which allows multiple lines for a single row of
data (yes! no horizontal scrolling!), but columns do not line up across
listitems/data rows (very ugly & distracting - maybe there's some way to
get the items to line up, but I haven't found it). This has to be a
common UI problem, and I was wondering how others have handled it. Any
ideas?

Nov 19 '05 #2
Yes - it is a common UI problem that is often addressed by first requiring
users to somehow narrow down the scope of data they want to see (rows) and
then showing them all the values (columns) for their selection - but not
necessarily in a grid.

So, while it's sometimes annoying to have "requiremen ts" questioned, it's
sometimes a reasonable thing to ask if you *really need* to show all those
columns for all those rows at once? Or, would it be acceptable to require
the user to first specify the "cases/rows" they want to see and only then
show them all the values (perhaps not in a grid at all)? If you can satisfy
the "requiremen ts" by doing someting other than showing that huge amount of
data all at once, then other solutions might become reasonable.

Separately, I see that another poster recommended the Infragistics grid. I
suspect that's only because he has never *actually* attempted to implement
it. Their ASP.NET Web products are known to be incomplete and buggy. Before
you get distracted by Infragistics attractive marketing materials you might
first want to take a long hard look at their products and support. You'll
definitely need it because (1) their object models are unintuitive and (2)
their documentation substantially lacking in useful organization and
information. Apparently their business model assumes (hopes) they will make
a lot of money from tech support.

-HTH
"Lisa Calla" <sp*********@he rplace.com> wrote in message
news:l5******** *************** *******@eatel.n et...
Hi,
I need to display records with lots of fields. When placed in a grid, a
row of data will scroll off the screen. Not exactly what I'm looking for.
I've also used a datalist, which allows multiple lines for a single row of
data (yes! no horizontal scrolling!), but columns do not line up across
listitems/data rows (very ugly & distracting - maybe there's some way to
get the items to line up, but I haven't found it). This has to be a
common UI problem, and I was wondering how others have handled it. Any
ideas?

Nov 19 '05 #3
Jon
True I have never implemented their grid but I have had it recommended to me
when people see the time I've spent on JavaScript grids I have hacked around
with in the past.
I have however used their graphs and numeric text boxes etc. and you are
right they leave a lot to be desired. Once you get past the marketting hype
the documentation is pretty scarce.

I've seen a number of scrollable (on both axes) grids that are .NET server
controls but most are over $1000 and come with no demo so I've not been
willing to test.

Jon
"Frankie" <Be***********@ TacoTime.net> wrote in message
news:eS******** *****@tk2msftng p13.phx.gbl...
Yes - it is a common UI problem that is often addressed by first requiring
users to somehow narrow down the scope of data they want to see (rows) and
then showing them all the values (columns) for their selection - but not
necessarily in a grid.

So, while it's sometimes annoying to have "requiremen ts" questioned, it's
sometimes a reasonable thing to ask if you *really need* to show all those
columns for all those rows at once? Or, would it be acceptable to require
the user to first specify the "cases/rows" they want to see and only then
show them all the values (perhaps not in a grid at all)? If you can
satisfy the "requiremen ts" by doing someting other than showing that huge
amount of data all at once, then other solutions might become reasonable.

Separately, I see that another poster recommended the Infragistics grid. I
suspect that's only because he has never *actually* attempted to implement
it. Their ASP.NET Web products are known to be incomplete and buggy.
Before you get distracted by Infragistics attractive marketing materials
you might first want to take a long hard look at their products and
support. You'll definitely need it because (1) their object models are
unintuitive and (2) their documentation substantially lacking in useful
organization and information. Apparently their business model assumes
(hopes) they will make a lot of money from tech support.

-HTH
"Lisa Calla" <sp*********@he rplace.com> wrote in message
news:l5******** *************** *******@eatel.n et...
Hi,
I need to display records with lots of fields. When placed in a grid, a
row of data will scroll off the screen. Not exactly what I'm looking
for. I've also used a datalist, which allows multiple lines for a single
row of data (yes! no horizontal scrolling!), but columns do not line up
across listitems/data rows (very ugly & distracting - maybe there's some
way to get the items to line up, but I haven't found it). This has to be
a common UI problem, and I was wondering how others have handled it. Any
ideas?


Nov 19 '05 #4
Hi Jon,

I'm so incredibly down on Infragistics as a result of struggling with their
products, poor documentation, etc. I won't give sad stories here but I can
say from first hand experience just how aweful their products AND support
AND documentation all are. It's truly unprofessional of them to be
conducting themselves that way.

Here's a $400 grid from a first-rate company. There are a lot of demos; the
following link is to just one of them. I haven't implemented it, but I have
implemented many of ComponentArt's components. They are complete, polished,
well documented, and very well supported.
http://www.componentart.com/demos/gr.../WebForm1.aspx
-HTH
"Jon" <jo*******@nusy stems.com.au> wrote in message
news:Ok******** ******@tk2msftn gp13.phx.gbl...
True I have never implemented their grid but I have had it recommended to
me when people see the time I've spent on JavaScript grids I have hacked
around with in the past.
I have however used their graphs and numeric text boxes etc. and you are
right they leave a lot to be desired. Once you get past the marketting
hype the documentation is pretty scarce.

I've seen a number of scrollable (on both axes) grids that are .NET server
controls but most are over $1000 and come with no demo so I've not been
willing to test.

Jon
"Frankie" <Be***********@ TacoTime.net> wrote in message
news:eS******** *****@tk2msftng p13.phx.gbl...
Yes - it is a common UI problem that is often addressed by first
requiring users to somehow narrow down the scope of data they want to see
(rows) and then showing them all the values (columns) for their
selection - but not necessarily in a grid.

So, while it's sometimes annoying to have "requiremen ts" questioned, it's
sometimes a reasonable thing to ask if you *really need* to show all
those columns for all those rows at once? Or, would it be acceptable to
require the user to first specify the "cases/rows" they want to see and
only then show them all the values (perhaps not in a grid at all)? If you
can satisfy the "requiremen ts" by doing someting other than showing that
huge amount of data all at once, then other solutions might become
reasonable.

Separately, I see that another poster recommended the Infragistics grid.
I suspect that's only because he has never *actually* attempted to
implement it. Their ASP.NET Web products are known to be incomplete and
buggy. Before you get distracted by Infragistics attractive marketing
materials you might first want to take a long hard look at their products
and support. You'll definitely need it because (1) their object models
are unintuitive and (2) their documentation substantially lacking in
useful organization and information. Apparently their business model
assumes (hopes) they will make a lot of money from tech support.

-HTH
"Lisa Calla" <sp*********@he rplace.com> wrote in message
news:l5******** *************** *******@eatel.n et...
Hi,
I need to display records with lots of fields. When placed in a grid, a
row of data will scroll off the screen. Not exactly what I'm looking
for. I've also used a datalist, which allows multiple lines for a single
row of data (yes! no horizontal scrolling!), but columns do not line up
across listitems/data rows (very ugly & distracting - maybe there's some
way to get the items to line up, but I haven't found it). This has to
be a common UI problem, and I was wondering how others have handled it.
Any ideas?



Nov 19 '05 #5
Jon & Frankie,
Thanks for your help & advice. I've decided to use a datalist with small
text, with the data prefaced by the field names in bold. With a little
judicious spacing, it's pretty readable. Not beautifully formatted, but
readable. Thanks again.

"Lisa Calla" <sp*********@he rplace.com> wrote in message
news:l5******** *************** *******@eatel.n et...
Hi,
I need to display records with lots of fields. When placed in a grid, a
row of data will scroll off the screen. Not exactly what I'm looking for.
I've also used a datalist, which allows multiple lines for a single row of
data (yes! no horizontal scrolling!), but columns do not line up across
listitems/data rows (very ugly & distracting - maybe there's some way to
get the items to line up, but I haven't found it). This has to be a
common UI problem, and I was wondering how others have handled it. Any
ideas?

Nov 19 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
4083
by: Matt K. | last post by:
Hi there, I have a form in an Access project that contains a subform which displays the results of a query of the style "select * from where = #a certain date#". In the main part of the form the user can change the date, which will force a requery in the subform to bring up records from the date selected. My question is this... The query in the subform is a very simple one, with only three fields being returned. In the interest of...
3
3507
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 "B" must be displayed in text boxes with the record fields from the single record from table "A". ...
13
3482
by: Jan | last post by:
Hi I have a database that I use to keep track of the sales promotions that we send to companies. I normally send a mailing based on a subset of the companies in the database (found using the query: QryICTMassDistribution3) , I then use a form and the code below to create a new record in the corrispondence table to show what corrispondence has been sent to various companies.
9
2359
by: Susan Bricker | last post by:
Greetings. I am having trouble populating text data that represents data in my table. Here's the setup: There is a People Table (name, address, phone, ...) peopleID = autonumber key There is a Judge Table (information about judges) judgeID = autonumber key
4
3652
by: Krzysztof Bartosiewicz | last post by:
Hi! I haven't been using Access for a very long time and I forgot everything :) I will be very greatful for help since I have been fighting with this problem for a few hours... I have three tables: Medicines (ID_Medicine, ID_MedicineGroup, MedicineName), MedicineGroups (ID_MedicineGroup, MedicineGroupName) and Treatment (ID_MEDICINE, ID_CONSULT, ID_COMMENT). After the user chooses appropraite MedicineGroup and later Medicine from...
4
1865
by: Vigneshwar Pilli via DotNetMonster.com | last post by:
Hey, Well, I have a Problem. I have designed a table which has few fields which are being declared in the database of type .... char of length 10. and other fields with varchar 50 and datetime too. Well, the Problem is I am not able to display the CHAR type FIELDS in the
1
4784
by: NumberCruncher | last post by:
Hi All, I am struggling with setting up my first system of tables, forms,and reports, and could use your help! I am setting up a database to keep track of the production of a produced item. The item is a panel, with a specific texture. There are standard panels that are then produced in a limited number of specific textures. The number of panels/project varies, so I keep track of the actual number of panels per project with the count:...
0
1223
by: darrel | last post by:
Hi there, good day! i need some help in displaying my records,,, my assignment is i have to display a database records in a labels. Its like this in my database i have a table called "SUBJECTS" that is consists of 4 fields, SUBJECT CODE, SUBJECT, TYPE, & UNITS, i have input their all the data for my fields that have unique identifier. My problem i dont know how to display in my form. No in my form i have several of labels. in each...
0
1464
by: John Kirkpatrick | last post by:
Hi all, I am having difficulty displaying records on a frontend MS Access 2000 form using a MySQL backend. The following code works well with the Jet database engine but doesn't work properly using the MySQL backend database. All records are displayed on the form using the Jet, but only one record appears using MySQL. Perhaps it just needs some tweaking to work with MySQL. Any advice would be great. Thanks Function HelpDesc(HelpFrm As...
0
9617
marktang
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 usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10099
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9904
tracyyun
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7456
isladogs
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6710
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 into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5354
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5482
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3609
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2849
bsmnconsultancy
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.