Private Sub Command1_Click()
On Error GoTo MapXErr
Dim ds As Dataset
Dim flds As New MapXLib.Fields
' Adodc1 is a Microsoft ADO Data Control, which must be
' placed on the VB form.
' Change the "Data Source=" line if MapX was installed in
' a different location.
Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;" & _
"Data Source=C:\Program Files\MapInfo\MapX 4.0\Data\MapStats.mdb"
Adodc1.RecordSource = "Select * from USA"
Adodc1.Refresh ' Bring in the data from the database
' Add a dataset to the map and create a simple theme from it.
Set ds = Map1.DataSets.Add(miDataSetADO, Adodc1.Recordset, "ADOset", "GEOABBR")
'这里你可以根据自己改写一下,不过他是如何匹配大概是通过索引吧。具体我不大清楚
Debug.Print ds.Fields(3).Name
flds.Add ds.Fields(3)
ds.Themes.Add miThemeRanged, ds.Fields(3)
Exit Sub
MapXErr:
Debug.Print "Error #" & Err.Number & ": " & Err.Description
End Sub
这里的ds.Fields(3).Name就是数据库里的,因为表tab里只有2个字段