How to get all fields in a databasetable
I want to get info about the NAME OF ALL THE FIELDS in a
access database table.
I have opened the database with code similar to the one here.
Someone that knows how to accomplish that?
strSQL = "SELECT * FROM tblArtikel ORDER by TestName"
cn = New OleDbConnection(JET_CONNECTIONSTRING)
cn.Open()
cm = New OleDbCommand(strSQL, cn)
dr = cm.ExecuteReader() 'bygger en OleDb datareader
Do While dr.Read()
...code to read from database
Loop
dr.Close()
cn.Close()
cm.Dispose()
cn.Dispose()