Thread: Get tables name from DataBase [vb]

Code:

Public Function FieldNames(dbPath As String, TableName As _
String) As Collection
\'Input:
  \'dbPath: Full Path to an Access Database
  \'TableName: Name of a Table within the
      \'Database
\'Returns: Collection of the names
\'of fields in that table
\'or Nothing if there is an error
\'Requires: a reference to data access
\'objects (DAO) in your project

Dim oCol As Collection
Dim db As DAO.Database
Dim oTD As DAO.TableDef
Dim lCount As Long, lCtr As Long
Dim f As DAO.Field
On Error GoTo errorhandler
Set db = workspaces(0).opendatabase(dbPath)
Set oTD = db.TableDefs(TableName)
Set oCol = New Collection
With oTD
    lCount = .Fields.Count
      For lCtr = 0 To lCount - 1
        oCol.Add .Fields(lCtr).Name
    Next
End With
    db.Close
    Set FieldNames = oCol
    
Exit Function
errorhandler:
    On Error Resume Next
    If Not db Is Nothing Then db.Close
    Set FieldNames = Nothing
    Exit Function
End Function

Good SHare..
Which VB?

welcome
its visual basic
<div class='quotetop'>QUOTE (L33T @ May 7 2009, 12:01 PM) <{POST_SNAPBACK}></div>

Good SHare..
Which VB?[/b]

<div class='quotetop'>QUOTE (ghadeer @ May 7 2009, 01:20 PM) <{POST_SNAPBACK}></div>

welcome
its visual basic[/b]

Yes! I know how to Code in VB pro..
But the newest version?

you mean .net
<div class='quotetop'>QUOTE (L33T @ May 7 2009, 01:22 PM) <{POST_SNAPBACK}></div>

Yes! I know how to Code in VB pro..
But the newest version?[/b]

<div class='quotetop'>QUOTE (ghadeer @ May 7 2009, 01:29 PM) <{POST_SNAPBACK}></div>

you mean .net[/b]

VB.net yes..
And I know C++, Java and ....

yh this is good, but its the long way round, why dont you just creat a connect.php file and do a simple mysql request

3 lines -> easy

1- its not php coding (php+mysql) its (visualbasic6ith any database (access, paradox,...))
2-its not to connect app with database this code to get (tables name from detcated data base)
<div class='quotetop'>QUOTE (Eyes @ May 8 2009, 09:15 AM) <{POST_SNAPBACK}></div>

yh this is good, but its the long way round, why dont you just creat a connect.php file and do a simple mysql request

3 lines -> easy[/b]