Hi,

I am trying to display column/field names in a scrollable listbox (instead of its data content). Since I'm fairly new to listboxes I'm not even sure this is possible. I do however understand the concept of binding a listbox to a table to display data within that table. Is there anyway to bind to a table displaying its column/field names?

Any assistance on this matter is great appreciated.

The database technology is intrinsic to your question. (Access? Oracle? SQLServer? . . .?)

Of course it is..please my apologies. The database technology is SQL Server 2000, but may change to AS/400 db2.

You can get column names for X table from the [INFORMATION_SCHEMA] so your select statement might literally look like this:

SELECT
  [COLUMN_NAME]
FROM
  [INFORMATION_SCHEMA]
WHERE
  [TABLE_NAME] = 'yourtablename'

hth

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Professional Search Engine Optimization with ASP.NET
Professional IIS 7 and ASP.NET Integrated Programming
Wrox Blox: Introduction to Google Gears
Wrox Blox: Create Amazing Custom User Interfaces with WPF and .NET 3.0
================================================== =========

That worked just fine with a minor adjustment. Thank you very much. The select statement I used looks like this:
   SELECT COLUMN_NAME
   FROM INFORMATION_SCHEMA.COLUMNS
   WHERE (TABLE_NAME = 'salehistp')

I'm also able to bring back table names using the same methodology.

Thanks