|
-
Dec 16th, 2002, 04:01 AM
#1
Thread Starter
Lively Member
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()
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|