使用ADO.NET直接连接Geodatabase
使用AO获得一个要素类中要素的信息,是一件比较麻烦的事情,我们需要在获得一个要素后,遍历要素的每一个字段,取出它们的值。那么,是否存在其它的获得信息的方法呢。
毫无疑问的,AO中提供了直接支持ADO或ADO.NET的方法。
AO中有一个低级别的OLEDB数据提供者,即ESRI OLE DB provider,下面的例子将阐明如何使用ADO、ADO.NET和ESRI OLE DB provider,在一个项目中建立一个链接。
如果是ArcSDE数据库,连接字符串如下:
Provider=ESRI.GeoDB.OLEDB.1;Location=server name;Data Source=database name; User Id=user name;Password=password; Extended Properties=WorkspaceType=
esriDataSourcesGDB.SDEWorkspaceFactory.1;Geometry=WKB|OBJECT;Instance=ArcSDE service;Version=ArcSDE version
或:
Provider=ESRI.GeoDB.OLEDB.1;Extended Properties=WorkspaceType= esriDataSourcesGDB.SDEWorkspaceFactory.1;ConnectionFile= ArcSDE 连接文件的路径(这个文件一般存
放在C:\Documents and Settings\Administrator\Application Data\ESRI\ArcCatalog文件夹中)
1.下面是一个SDE连接例子:
Dim sConString As String
DIM SDEAdocon as ADODB.connection
Set SDEAdoCon = New ADODB.Connection
'Set a limit on the time to connect
SDEAdoCon.ConnectionTimeout = 30
连接字符串可以是:
sConString = "Provider=ESRI.GeoDB.OleDB.1;Location=fabio;Data Source=world;" & _
"User Id=avtest;Password=avtest;Extended Properties=workspacetype=esriDataSourcesGDB." & _
"SdeWorkspaceFactory.1;Geometry=WKB;Instance=5152;Version=SDE.DEFAULT"
或者是:
sConString = "Provider=ESRI.GeoDB.OleDB.1;Extended" & _
"Properties=workspacetype=esriDataSourcesGDB.SdeWorkspaceFactory.1;" & _
"ConnectionFile=c:\Winnt\Profiles\jill2846\Application Data\ESRI\ArcCatalog\connection to springs.sde"
SDEAdoCon.Open sConString
2.连接一个personal geodatabase的例子
sConString = "Provider=ESRI.GeoDB.OLEDB.1;Data Source=d:\testdata\access\us_states.mdb;Extended
Properties=workspacetype=esriDataSourcesGDB.AccessWorkspaceFactory.1;Geometry=WKB"
3.连接shape文件的连接字符串:
Provider=ESRI.GeoDB.OLEDB.1;Data Source=shapefile文件夹路径;Extended
Properties=WorkspaceType=esriDataSourcesFile.ShapefileWorkspaceFactory.1;Geometry=WKB|OBJECT
4.Coverages文件的连接字符串
The Coverage 工作空间工厂对象需要的是一个coverage文件夹的位置,而不是某个特定的文件
sConString = "Provider=ESRI.GeoDB.Oledb.1;Data Source=d:\workspace\;Extended
Properties=workspacetype=esriDataSourcesFile.ArcInfoWorkspaceFactory.1;Geometry=WKB"
5.使用ADO.NET连接个人geodatabase的例子
Dim cn As New OleDbConnection
Dim da As New OleDbDataAdapter
cn.ConnectionString = "Provider=ESRI.GeoDB.OLEDB.1;Data Source=D:\Program Files\ArcGIS\DeveloperKit\samples\data\usa\usa.mdb;Extended
Properties=workspacetype=esriDataSourcesGDB.AccessWorkspaceFactory.1;Geometry=WKB"
da.SelectCommand = New OleDbCommand("select * from states", cn)
Dim ds As New DataSet
da.Fill(ds, "states")
DataGrid1.SetDataBinding(ds, "states")