Hi,
Assuming you are using sql server, build this dataset/datatable and then
simply loop through it with a datarow for each loop:
Dim dacolumns As New SqlDataAdapter("select distinct column_name from
information_schema.columns where table_name = '" & gl_xfilename & "' order
by column_name", oconn)
Dim dscolumns As New DataSet("columns")
dacolumns.Fill(dscolumns, "columns")
Dim irow As DataRow
For Each irow In dscolumns.Tables(0).Rows
columnbox.Items.Add(irow("column_name"))
Next
HTH,
Bernie Yaeger
"steve" <noemail.@try.com> wrote in message
news:qk*******************@wagner.videotron.net...
hi,
how can i loop and get the field names of the columns in a dataset\s
table?
I want the names of the columns (i.e. the field names) not the actual
data.
TIA