[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Collapse]WPF Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Expand]MVVM Framework
 [Collapse]Controls and Libraries
   Reporting
  [Expand]Data Grid
  [Expand]Ribbon, Bars and Menu
  [Expand]Charts Suite
  [Expand]Pivot Grid
  [Expand]Scheduler
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Tree List
  [Expand]Gauge Controls
  [Collapse]Map Control
   [Expand]Getting Started
    Layers
   [Expand]Coordinate Systems
   [Expand]Map Image Data
   [Expand]GIS Data
   [Expand]Vector Data
   [Expand]Visual Elements
   [Expand]End-User Interaction
   [Collapse]Examples
    [Expand]General
    [Expand]Map Image Data
    [Expand]GIS Data
    [Collapse]Vector Data
     [Collapse]Providing Data
       How to: Load Data from a Shapefile
       How to: Load Data from a KML File
       How to: Load Data from a SVG File
       How to: Load Data from a SQL Geometry Datasource
       How to: Manually Generate Vector Items
       How to: Manually Generate Vector Items from WKT
       How to: Automatically Generate Vector Items from a Datasource
       How to: Automatically Generate Bubble Chart Items from a Datasource
       How to: Automatically Generate Pie Chart Items from a Datasource
       How to: Aggregate Vector Items Using a Clusterer
       How to: Implement a Custom Clusterer
     [Expand]Colorize Data
     [Expand]Customize Data Appearance
    [Expand]Printing and Exporting
  [Expand]Layout Management
  [Expand]Windows Modern UI
  [Expand]Printing-Exporting
  [Expand]Data Editors
  [Expand]Navigation Controls
  [Expand]Spell Checker
  [Expand]Property Grid
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Diagram Control
  [Expand]Windows and Utility Controls
   Dialogs, Notifications and Panels
  [Expand]Scheduler (legacy)
 [Expand]Scaffolding Wizard
 [Expand]Localization
  Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

How to: Load Data from a SQL Geometry Datasource

Show Me

A complete sample project is available in the DevExpress Code Examples database at http://www.devexpress.com/example=T180275.

To load shapes from a SQL Geometry datasource, do the following.

  1. Create a SqlGeometryDataAdapter object and assign it to the VectorLayer.Data property.

  2. Specify the SqlGeometryDataAdapter.ConnectionString, SqlGeometryDataAdapter.SpatialDataMember and SqlGeometryDataAdapter.SqlText properties.

Note

All table fields of the SQL data table loaded from the database will be provided as attributes values for each SqlGeometryItem object generated by the SqlGeometryDataAdapter.

Expanded See Also

Is this topic helpful?​​​​​​​