Manipulating the size of the track and knob in a scrollbar of a JTable

From: Dave (Davel*removethistosendemail*_at_superstar.demon.nl)
Date: 11/15/03 

Date: Sat, 15 Nov 2003 20:28:39 +0100

Hello there,

I have a JTable added to a JScrollPane. The JTable shows the contents of a
databasetable. I only want to load the datarows from the database when they
are needed (meaning: when they are in the visible area of the JTable),
because the JTable could show only 10 rows, while the databasetable could
contain thousands of rows. I have accomplished this by overriding the
getScrollableBlockIncrement and getScrollableUnitIncrement methods of
JTable, from where data is loaded from the database. The size of JTable's
datamodel is therefore always the size of the rows visible. I have set the
vertical scrollbar to be always visible. Furthermore, the datamodel holds a
datastructure with the primary key values for all the rows in the
databasetable; this allows me to fetch the complete datarow when I need it.

Now I have the following problem: the size of the knob on the vertical
scrollbar in relation to the size of the track is based on the number of
rows visible and the number of rows in the datamodel of JTable (at least,
that's my conclusion), and this is obvious not what I want. I want the size
of the knob and the size of the track to be related to the rowcount of the
databasetable and not to the rowcount of the datamodel.

I hope there is someone out there who can give me some pointers in how to
accomplish this? Also suggestions that take a completely different approach,
but prove to be working, are much appreciated.

Thanks in advance.

Dave

---------------------------------------------------------------------
Computers, you can't live with them and you can't live without them.
---------------------------------------------------------------------

Relevant Pages

  • Re: Reverse-Engineer Database thru VISIO SDK?
    ... I want to connect to a database, Reverse Engineer the Database structure i.e ... generate the DataModel and Export the Datamodel as JPEG. ... need to be done through VisualBasic Code using Visio SDK. ... > You can save as jpeg with normal Visio ...
    (microsoft.public.visio.developer)
  • Re: Caching Queries in DataTable
    ... I am implementing this by storing the command ... database itself is likely to cache query results. ... values and the generated DataRows that have been queried thus far. ... How can I be sure that my hash codes ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: Quickest way to update a DataColumns values?
    ... collection of "DataRows" in Memory. ... But if your concern is efficiency of updating database, ... UPDATE SQL statement to database directly. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: heterogeneous query how do I get correct @@rowcount ?
    ... and ultimately writes some data into my SQL Server 2000 database. ... @@rowcount is returning a value related to the number of remote records I read and not how many I ultimately wrote into local SQL database. ...
    (microsoft.public.sqlserver.programming)
  • Re: Store data into Access
    ... because you are talking about Datarows. ... This method you show is probably just to store values in a database by ... > I have a small table in an Access database, ... I looked at the view SQL in Access ...
    (microsoft.public.dotnet.languages.vb)