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.