Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

get the names of all the fields

2 Posts 2 Posters 0 Views 1 Watching

X Offline
X Offline
x4uca

wrote on last edited by

#1

i'm using vb.net, and i need to know how to get the names of all the fields(columns), a mdb table contains, and display them in a listbox. hope someone can help....
A 1 Reply Last reply

0
X x4uca

i'm using vb.net, and i need to know how to get the names of all the fields(columns), a mdb table contains, and display them in a listbox. hope someone can help....
A Offline
A Offline
Ageesh

wrote on last edited by

#2

hi... You can use this query to get column names of the table SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'name of the table' with Rgrds Ageesh M.
1 Reply Last reply

0

Log in to reply