Field Description!!

[pvbangera]

I used the following code using DAO to populate arrays with table's field name and field description.

Dim rsReport as DAO.RecorrSet
rsReport = dbDatabase.OpenRecordset("Table1")
For Idx As Short = 1 To rsReport.Fields.Count - 1
    FieldNames(Idx) = rsReport.Fields(Idx).Name
    Descriptions(Idx) = rsReport.Fields(Idx).Properties("Description").Value
Next

How to achieve the same result using ADO.Net?

Please guide

Regards

[Hole-In-One]

Check out the DataAdapter and the Dataset.

[pvbangera]

thats so kind of u

i need an example

[Hole-In-One]

 ' create a connection string 
        Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\Northwind.mdb"
        Dim myConnection As OleDb.OleDbConnection = New OleDb.OleDbConnection
        myConnection.ConnectionString = connString
        ' create a data adapter 
        Dim da As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter("Select * from Employees", myConnection)
        ' create a new dataset 
        Dim ds As DataSet = New DataSet
        ' fill dataset 
        Try
            da.Fill(ds, "Employees")

        Catch ex As Exception
            MsgBox(ex.ToString)
        End Try


        For Idx As Integer = 1 To ds.Tables(0).Columns.Count - 1
            MsgBox(ds.Tables(0).Columns(Idx).ColumnName.ToString)
            'FieldNames(Idx) = rsReport.Fields(Idx).Name
            'Descriptions(Idx) = rsReport.Fields(Idx).Properties("Description").Value
        Next

That'll get you started