SqlGeometryDataAdapter.SqlText Property

Gets or sets the SQL query that will be used to select data from a SQL database.

Namespace: DevExpress.XtraMap

Assembly: DevExpress.XtraMap.v18.2.dll

Declaration

C#

[DefaultValue("")]
public string SqlText { get; set; }

VB.NET

<DefaultValue("")>
Public Property SqlText As String

Property Value

Type	Default	Description
String	String.Empty	A String object.

Example

To load data from a SQL Geometry data source, do the following.

1. Create a SqlGeometryDataAdapter object.
2. Specify its SqlGeometryDataAdapter.ConnectionString, SqlGeometryDataAdapter.SqlText and SqlGeometryDataAdapter.SpatialDataMember properties.
3. Assign this object to the VectorItemsLayer.Data property.

Note

All data table field values loaded from the database will be provided as attributes for each SqlGeometryItem object generated using SqlGeometryDataAdapter.

Note

A complete sample project is available at https://github.com/DevExpress-Examples/how-to-load-data-from-a-sql-geometry-data-source-t175898

Form1.cs

const string filePath = "..\\..\\Data\\SQLG.mdf";

private void Form1_Load(object sender, System.EventArgs e) {
    string fullFilePath = Path.GetFullPath(Path.Combine(Application.StartupPath, filePath));
    SqlGeometryDataAdapter adapter = new SqlGeometryDataAdapter() {
        ConnectionString = "Data Source=(local);AttachDbFileName=" + fullFilePath + 
            ";Database=SqlGeometryDB;Integrated Security=True;MultipleActiveResultSets=True",
        SqlText = "SELECT TOP 1000 [GeomCol1],[TextCol] FROM [dbo].[DemoTable]",
        SpatialDataMember = "GeomCol1"
    };
    VectorItemsLayer layer = new VectorItemsLayer() {
        Data = adapter,
        ShapeTitlesPattern = "{TextCol}"
    };
    layer.DataLoaded += layer_DataLoaded;
    mapControl1.Layers.Add(layer);
}

void layer_DataLoaded(object sender, DataLoadedEventArgs e) {
    mapControl1.ZoomToFitLayerItems();
}

Form1.vb

Private Const filePath As String = "..\..\Data\SQLG.mdf"

Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
    Dim fullFilePath As String = Path.GetFullPath(Path.Combine(Application.StartupPath, filePath))
    Dim adapter As New SqlGeometryDataAdapter() With { _
        .ConnectionString = "Data Source=(local);AttachDbFileName=" & fullFilePath & ";Database=SqlGeometryDB;Integrated Security=True;MultipleActiveResultSets=True", _
        .SqlText = "SELECT TOP 1000 [GeomCol1],[TextCol] FROM [dbo].[DemoTable]", _
        .SpatialDataMember = "GeomCol1" _
    }
    Dim layer As New VectorItemsLayer() With { _
        .Data = adapter, _
        .ShapeTitlesPattern = "{TextCol}" _
    }
    AddHandler layer.DataLoaded, AddressOf layer_DataLoaded
    mapControl1.Layers.Add(layer)
End Sub

Private Sub layer_DataLoaded(ByVal sender As Object, ByVal e As DataLoadedEventArgs)
    mapControl1.ZoomToFitLayerItems()
End Sub