Blog Post by Murat Yaşar

Comments (2) Leave a Comment

• ---

  

  szamora | Reply

  Saturday, March 10, 2012 10:21:41 PM
  
  

  Reading a Polygon item from vb.net

  Imports Npgsql
  Imports NpgsqlTypes
  .
  .
  .
  Dim Vertexes As NpgsqlPolygon
  Dim Point As NpgsqlPoint
  Dim PGConn As NpgsqlConnection
  PGConn = New NpgsqlConnection("Server=yourserver;Port=yourport;User Id=youruser;Password=yourpass;Database=yourDB;")
  PGConn.Open()
   
  ' Read a row with a Polygon item
  Dim comando As New NpgsqlCommand("select * from yourtable where yourcolumnname = 'gggg'", PGConn)
  Dim PGReader As NpgsqlDataReader
  
  PGReader = comando.ExecuteReader() Try
  
     If (PGReader.HasRows()) Then
        PGReader.Read()       ' The Polygon item has the index 2 in my table
        Vertexes = PGReader.Item(2)       ' Example about how to get a vertex (x,y point) from the polygon item
  
        Point = Vertexes.Item(8)
        MsgBox("X=" + Point.X.ToString() + ",  Y=" + Point.Y.ToString()) Catch ex As Exception
  
        MsgBox(ex.Message)
  Finally
        If Not (PGReader.IsClosed()) Then
            PGReader.Close()
        End If
        comando.Dispose()
  End Try

   

• ---

  

  Murat Yasar | Reply

  Sunday, March 11, 2012 8:13:52 AM
  
  

  A good sample. Thanks.