Field Description!!

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

VB Code:

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

Check out the DataAdapter and the Dataset.

thats so kind of u :bigyello: :p

i need an example

Code:

---

' 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