getting the column names of a table

[steve]

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

 

[Bernie Yaeger]

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

 

[scorpion53061]

Hi Steve,

Psuedo code....

For I = 0 to dataset.Tables(0).Columns.Count
MsgBox(dataset.Tables(0).Columns.Item(I).ColumnName
Next