Get column names from SQL data source for drop down list

[nowandever29]

Hi,

I'm using VB.net 2008 and SQL 2008. I've got a SQL data source that works fine, but I need to get the column names from it so that I can fill a drop down. But there's no "table" element in the data source, and nothing else that I can see that would give me the column names. The data source is attached to a SQL view.

 

[Andrzejek]

Something like:

Friend dsDtSet As New DataSet
Dim dt As DataTable

dt = dsDtSet.Tables("MyTableName")

For Each column As DataColumn In dt.Columns
    Debug.Print(column.Caption.ToString & " is " & column.DataType.ToString)
Next

Have fun.

---- Andy