Hey all,

I am interested to check out whether column has an autoincrement/allowdbnull property .

Having this code below , gives me always false although I already have one column that has autoincrement/allowdbnull property.


Code:
 Dim dt As New DataTable()
    Dim con As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source =" & Application.StartupPath & "\test.mdb"
    Dim sql As String = "SELECT * from teachers"
    Dim i As Integer

        Dim dataAdapter As New OleDb.OleDbDataAdapter(sql, con)
        dataAdapter.Fill(dt)
        dataAdapter.Dispose()

  For Each column As DataColumn In dt.Columns
TextBox1.Text = TextBox1.Text & column.ColumnName & "      " & column.AutoIncrement & "    " & column.AllowDBNull & vbCrLf
 Next
thanks.