<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1543" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=425314012-07082006><FONT face=Arial
color=#0000ff size=2>Haven't tried these myself with PostGIS, but I think these
might be good libraries to try if you are doing pure .NET
development.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=425314012-07082006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=425314012-07082006><FONT face=Arial
color=#0000ff size=2><A
href="http://sharpmap.iter.dk/">http://sharpmap.iter.dk/</A> (this I have
tried with shape but not yet with postgis in VB.NET ASP.NET 2.0
environment.)</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=425314012-07082006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=425314012-07082006><FONT face=Arial
color=#0000ff size=2><A
href="http://www.monogis.org/">http://www.monogis.org/</A> (haven't tried
this one at all, but looks promising. </FONT></SPAN><SPAN
class=425314012-07082006><FONT face=Arial color=#0000ff
size=2></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=425314012-07082006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=425314012-07082006><FONT face=Arial
color=#0000ff size=2>UMN mapserver also has a .NET interface via SWIG, but its
been a while since I've tried it and I got some threading issues with it when I
did and I think its most suitable for web development and not for desktop
development. I could be wrong since I don't do much desktop and haven't
attempted to use in desktop.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=425314012-07082006><FONT face=Arial
color=#0000ff size=2><A
href="http://ms.gis.umn.edu/">http://ms.gis.umn.edu/</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=425314012-07082006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=425314012-07082006>
<DIV dir=ltr align=left><SPAN class=425314012-07082006><FONT face=Arial
color=#0000ff size=2>the examples are in C#, but its a fairly trivial exercise
to convert snippets of them to Vb.NET format using one of the online c# to vb
converters </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=425314012-07082006><FONT face=Arial
color=#0000ff size=2>e.g.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=425314012-07082006><FONT face=Arial
color=#0000ff size=2><A
href="http://www.kamalpatel.net/ConvertCSharp2VB.aspx">http://www.kamalpatel.net/ConvertCSharp2VB.aspx</A></FONT></SPAN></DIV></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=425314012-07082006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=425314012-07082006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=425314012-07082006></SPAN><FONT
face=Arial><FONT color=#0000ff><FONT size=2>R<SPAN
class=425314012-07082006>egina</SPAN></FONT></FONT></FONT></DIV><FONT face=Arial
color=#0000ff size=2></FONT><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>gates
jr<BR><B>Sent:</B> Saturday, August 05, 2006 7:48 PM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users]
Calculate the distance<BR></FONT><BR></DIV>
<DIV></DIV>I’m Gates, a university student. I got two problems:
<OL>
<LI>
<DIV style="MARGIN-BOTTOM: 0cm">I have a table called “state_point table”. I
calculate the distance between a new point to all point in my table with
query:</DIV></LI></OL>
<DIV style="MARGIN-BOTTOM: 0cm; MARGIN-LEFT: 0.64cm"><BR></DIV>
<DIV style="MARGIN-BOTTOM: 0cm; MARGIN-LEFT: 1.27cm"><I>CREATE TABLE distance
AS</I></DIV>
<DIV style="MARGIN-BOTTOM: 0cm; MARGIN-LEFT: 1.27cm"><I>SELECT
distance(state_point.the_geom, geomfromtext('POINT(100000 200000)',-1)) AS
distance, state_id, state_name</I></DIV>
<DIV style="MARGIN-BOTTOM: 0cm; MARGIN-LEFT: 1.27cm"><I>FROM
state_point</I></DIV>
<DIV style="MARGIN-BOTTOM: 0cm; MARGIN-LEFT: 1.27cm"><I>order by
distance</I></DIV>
<DIV style="MARGIN-BOTTOM: 0cm; MARGIN-LEFT: 1.27cm"><BR></DIV>
<DIV style="MARGIN-BOTTOM: 0cm; MARGIN-LEFT: 1.27cm">My Question is : what
measure unit that’s return by this query? Meters? Miles? Or another? If it’s not
in meters how could I convert it to meters?</DIV>
<DIV style="MARGIN-BOTTOM: 0cm; MARGIN-LEFT: 1.27cm"><BR></DIV>
<OL start=2>
<LI>
<DIV style="MARGIN-BOTTOM: 0cm">I want to make user interface in VB.NET 2005,
which driver or connection should I use to show my map? Is there any VB.net or
another language samples, which use postgreSQL/postgis database, that I can
access in the internet? (a link site? ) I’m a kind of people that learn by
example.</DIV></LI></OL>
<DIV style="MARGIN-BOTTOM: 0cm"><BR></DIV>
<DIV style="MARGIN-BOTTOM: 0cm"><BR></DIV>
<DIV style="MARGIN-BOTTOM: 0cm">Thank</DIV>
<DIV style="MARGIN-BOTTOM: 0cm"><BR></DIV>
<DIV style="MARGIN-BOTTOM: 0cm">Gates</DIV>
<DIV style="MARGIN-BOTTOM: 0cm"><BR></DIV>
<DIV style="MARGIN-BOTTOM: 0cm"><BR></DIV>
<DIV style="MARGIN-BOTTOM: 0cm"> </DIV>
<P>
<HR SIZE=1>
See the all-new, redesigned Yahoo.com. <A
href="http://us.rd.yahoo.com/evt=40762/*http://www.yahoo.com/preview">Check it
out.</A> </BODY></HTML>
<HTML><BODY><P><hr size=1></P><br>
<P><STRONG><br>
The substance of this message, including any attachments, may be<br>
confidential, legally<br>
privileged and/or exempt from disclosure pursuant to Massachusetts<br>
law. It is intended<br>
solely for the addressee. If you received this in error, please<br>
contact the sender and<br>
delete the material from any computer.<br>
</STRONG></P></BODY></HTML>