Obtain Column Description In VB.Net

• jabbathenut

  Mr or Mrs. 500

  Points: 564

  More actions

  April 26, 2003 at 6:52 pm

  #159855

  I want to extract the "Description" property of a SQL 2000 column using VB.Net. I have used the following code to populate a list box with the "ColumnName" property. I instead want to populate the list box with the "Description" property. Can someone please help?

  <code>

  Private Sub GetFieldList()

  ' Create instance of connection object.

  Dim myConnection As New SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))

  ' Create instance of dataset object, passing in SQL string

  Dim mySQL As String

  mySQL = "SELECT * FROM MyTable"

  Dim myAdapter As New SqlDataAdapter(mySQL, myConnection)

  Dim DS As DataSet = New DataSet()

  myAdapter.FillSchema(DS, SchemaType.Source)

  Dim i As Integer

  For i = 0 To DS.Tables(0).Columns.Count - 1

  lstAvail.Items.Add(New ListItem(i, DS.Tables(0).Columns(i).ColumnName))

  Next

  End Sub

  </code>

• April 29, 2003 at 8:00 am

  This was removed by the editor as SPAM

• Rajesh Patavardhan

  SSCrazy

  Points: 2801

  More actions

  May 2, 2003 at 5:35 am

  #455976

  Answer to similar query exists in

  http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=11768