Welcome to the homepage of  XListbox

 

Click here if you are interessted in our XSelect which allows you to run SQL-queries against textfiles/logfiles/.txt/.csv ...

Click here if you are interessted in our XClasses which allow you access Hardware/Networking and WMI functions under RealBASIC...

Click here if you are interessted in our tool VBSInc that allows VBScript developers to use include files in their VBS code


What is  XListbox ?

xListbox is a Realbasic listbox class. 

It features the following capabilities :
 

 

Sample code:

//add some data to a xListbox (without heading)
// - set type of data in columns of the xListbox
// - Do some conditional formatting of the columns
// - Do a sort for each column (Button click)

//add some data to the xlistbox
xListbox1.xAddRow "1.55,31/12/2008,Norman"
xListbox1.xAddRow "2.01,28/10/2008,Peter"
xListbox1.xAddRow "3.00,17/08/2008,Simon"
xListbox1.xAddRow "-1,31/12/2007,Peter"
xListbox1.xAddRow "-2,29/11/2000,Susan"
xListbox1.xAddRow "-3,15/03/2009,David"
xListbox1.xAddRow "-11,15/04/2009,David"
xListbox1.xAddRow "-9,15/05/2009,David"
xListbox1.xAddRow "-9999,15/03/1966,Susan"
xListbox1.xAddRow "-12.1,15/03/1779,David"
xListbox1.xAddRow "-123.5,15/03/2002,David"


//set column types
xListbox1.xSetColumnType 1,"Number"
xListbox1.xSetColumnType 2,"mm/dd/yyyy"
xListbox1.xSetColumnType 3,"text"

//Conditional formatting of cells / rows:
//
//1
//red cell backgroundcolor if the number in a cell is <= 0 - else green for all other numbers
xListbox1.xSetColumnFormat 1,"<=","0","red","green","Cellsolid"

//2
//green cell forecolor for all dates between 25/11/1966 and 10/01/2009 - else blue xListbox1.xSetColumnFormat 2,"between","19661125 20090110","green","blue","Cell"

//3
//blue cell backgroundcolor if the text in a cell is "Peter" (else no action)
xListbox1.xSetColumnFormat 3,"=","Peter","blue","","Cellsolid"

//sort column 1 (first column) based on its columnType (as previously set using xSetColumnType)
xlistbox1.xsort 1

The above sample code will create the following listbox :

The xListbox can be sorted using a header-click

 

Some screenshots of the the Demo-Project that comes with the download :

The xListbox can be sorted using a header-click

 

SQL queries can be run against a xListbox. For example: Run a SQL-Query selecting all Users "BRAIN" from xListbox1 and display result in a new listbox (xListbox2)

In the new listbox set the rowcolor to red backgroundcolor if Session is < 0 - else set green row backgroundcolor

The x Listbox can be sorted using a header-click

 

Download:

Download the xListbox class including a demo-project.

xListbox was developed and tested under windows, but  it should run under MAC, too  (except MS Excel export which will not work on a MAC)

Download xListbox v 1.2

After the download has finished you can start the REALBasic Demo-Project.

Use the "Load CSV" Button to load the "SampleData1.csv" file into the xListbox.

 

License:

If you buy a licence of xListbox you will receive:

Buy:

We use   to process your order 

25 Euro for xListbox  BUY

All prices are plus local TAX / VAT

 


(C) 2008, 2009 www.Scout-Soft.com