# Display marker of my sql server table coordinates

**URL:** <https://community.thinkgeo.com/t/display-marker-of-my-sql-server-table-coordinates/6579>\
**Category:** WebForms\
**Created:** [July 29, 2015, 3:08am UTC](https://community.thinkgeo.com/t/display-marker-of-my-sql-server-table-coordinates/6579 "2015-07-29T03:08:20Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![raja1](https://community.thinkgeo.com/letter_avatar_proxy/v4/letter/r/85f322/32.png) [@raja1](https://community.thinkgeo.com/u/raja1)\
**Post date:** [July 29, 2015, 3:08am UTC](https://community.thinkgeo.com/t/display-marker-of-my-sql-server-table-coordinates/6579/1 "2015-07-29T03:08:20Z")

</div>

i&nbsp;need&nbsp;to&nbsp;display&nbsp;my&nbsp;sql&nbsp;server&nbsp;table&nbsp;coordinates&nbsp;in&nbsp;thinkgeo&nbsp;map&nbsp;my&nbsp;table&nbsp;structure&nbsp;is&nbsp;  
  
id,coordinates  
  
and&nbsp;data&nbsp;is&nbsp;like&nbsp;  
  
1,32.715,117.163  
  
  
  
  
  
is&nbsp;there&nbsp;is&nbsp;any&nbsp;server&nbsp;side&nbsp;code&nbsp;sample&nbsp;available&nbsp;to&nbsp;just&nbsp;display&nbsp;coordinates&nbsp;as&nbsp;marker&nbsp;point&nbsp;in&nbsp;thinkgeo&nbsp;map&nbsp;suite&nbsp;i&nbsp;am&nbsp;kind&nbsp;of&nbsp;new&nbsp;in&nbsp;thingeo&nbsp;but&nbsp;i&nbsp;dont&nbsp;see&nbsp;any&nbsp;server&nbsp;side&nbsp;code&nbsp;example&nbsp;in&nbsp;your&nbsp;code&nbsp;sample&nbsp;and&nbsp;tutoral&nbsp;please&nbsp;show&nbsp;me&nbsp;some&nbsp;sample&nbsp;data&nbsp;to&nbsp;only&nbsp;display&nbsp;coordinates&nbsp;from&nbsp;my&nbsp;sql&nbsp;table&nbsp;into&nbsp;thinkgeo&nbsp;map.

---

<div class="post-metadata">

**Author:** ![Ethan](https://community.thinkgeo.com/user_avatar/community.thinkgeo.com/ethan/32/19964_2.png) [@Ethan](https://community.thinkgeo.com/u/Ethan)\
**Post date:** [July 30, 2015, 1:07am UTC](https://community.thinkgeo.com/t/display-marker-of-my-sql-server-table-coordinates/6579/2 "2015-07-30T01:07:53Z")

</div>

Hi&nbsp;Raja,&nbsp;  
&nbsp;&nbsp;  
&nbsp;Our&nbsp;MsSql2008FeatureLayer&nbsp;is&nbsp;work&nbsp;for&nbsp;the&nbsp;scenario&nbsp;when&nbsp;you&nbsp;save&nbsp;your&nbsp;shapes&nbsp;in&nbsp;sql&nbsp;server.&nbsp;  
&nbsp;&nbsp;  
&nbsp;For&nbsp;your&nbsp;scenario,&nbsp;I&nbsp;think&nbsp;you&nbsp;can&nbsp;write&nbsp;your&nbsp;custom&nbsp;class&nbsp;for&nbsp;read&nbsp;table&nbsp;from&nbsp;sql&nbsp;server,&nbsp;then&nbsp;loop&nbsp;the&nbsp;data&nbsp;and&nbsp;add&nbsp;them&nbsp;to&nbsp;map&nbsp;as&nbsp;marker.&nbsp;  
&nbsp;&nbsp;  
&nbsp;You&nbsp;can&nbsp;use&nbsp;SqlConnection&nbsp;and&nbsp;SqlCommand&nbsp;to&nbsp;read&nbsp;data.&nbsp;  
&nbsp;&nbsp;  
&nbsp;For&nbsp;how&nbsp;to&nbsp;add&nbsp;marker,&nbsp;you&nbsp;can&nbsp;visit&nbsp;our&nbsp;sample&nbsp;AddAMarker&nbsp;in&nbsp;our&nbsp;HowDoISamples.&nbsp;  
&nbsp;&nbsp;  
&nbsp;Wish&nbsp;that’s&nbsp;helpful.&nbsp;  
&nbsp;&nbsp;  
&nbsp;Regards,&nbsp;  
&nbsp;&nbsp;  
&nbsp;Don&nbsp;  
&nbsp;&nbsp;

---

<div class="post-metadata">

**Author:** ![raja1](https://community.thinkgeo.com/letter_avatar_proxy/v4/letter/r/85f322/32.png) [@raja1](https://community.thinkgeo.com/u/raja1)\
**Post date:** [August 3, 2015, 2:36am UTC](https://community.thinkgeo.com/t/display-marker-of-my-sql-server-table-coordinates/6579/3 "2015-08-03T02:36:32Z")

</div>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;InMemoryFeatureLayer&nbsp;myData&nbsp;=&nbsp;new&nbsp;InMemoryFeatureLayer();  
  
myData.ZoomLevelSet.ZoomLevel01.DefaultPointStyle&nbsp;=  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;PointStyles.CreateSimpleCircleStyle(GeoColor.StandardColors.Blue,&nbsp;10);  
&nbsp;&nbsp;&nbsp;  
  
&nbsp;&nbsp;&nbsp;&nbsp;  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;myData.ZoomLevelSet.ZoomLevel01.DefaultLineStyle&nbsp;=  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;LineStyles.CreateSimpleLineStyle(GeoColor.SimpleColors.Green,&nbsp;6,&nbsp;false);  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//Make&nbsp;All&nbsp;Polygons&nbsp;Red&nbsp;with&nbsp;a&nbsp;black&nbsp;outline.  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;myData.ZoomLevelSet.ZoomLevel01.DefaultAreaStyle&nbsp;=  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;AreaStyles.CreateSimpleAreaStyle(GeoColor.StandardColors.Red,&nbsp;GeoColor.StandardColors.Black);  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//Add&nbsp;a&nbsp;Text&nbsp;Style&nbsp;to&nbsp;Label&nbsp;the&nbsp;shapes&nbsp;on&nbsp;the&nbsp;map.  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;myData.ZoomLevelSet.ZoomLevel01.DefaultTextStyle&nbsp;=&nbsp;TextStyles.CreateSimpleTextStyle("Name",&nbsp;"Arial",&nbsp;10,  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DrawingFontStyles.Bold,&nbsp;GeoColor.StandardColors.Black);  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;myData.ZoomLevelSet.ZoomLevel01.DefaultTextStyle.HaloPen&nbsp;=&nbsp;new&nbsp;GeoPen(GeoColor.StandardColors.White);  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//Apply&nbsp;these&nbsp;styles&nbsp;to&nbsp;all&nbsp;zoom&nbsp;levels  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;myData.ZoomLevelSet.ZoomLevel01.ApplyUntilZoomLevel&nbsp;=&nbsp;ApplyUntilZoomLevel.Level20;  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;myData;  
circle&nbsp;is&nbsp;display&nbsp;in&nbsp;thinkgeo&nbsp;map&nbsp;but&nbsp;now&nbsp;  
i&nbsp;wants&nbsp;to&nbsp;create&nbsp;a&nbsp;clickable&nbsp;marker&nbsp;on&nbsp;mydata&nbsp;i&nbsp;try&nbsp;like&nbsp;this  
MarkerOverlay&nbsp;markerOverlay&nbsp;=&nbsp;new&nbsp;FeatureSourceMarkerOverlay(myData.ToString());  
markerOverlay.Click&nbsp;+=&nbsp;btnsave\_OnClick;  
but&nbsp;it&nbsp;&nbsp;does&nbsp;not&nbsp;working&nbsp;please&nbsp;provide&nbsp;me&nbsp;information&nbsp;about&nbsp;this.&nbsp;thanks&nbsp;in&nbsp;advance

---

<div class="post-metadata">

**Author:** ![Ethan](https://community.thinkgeo.com/user_avatar/community.thinkgeo.com/ethan/32/19964_2.png) [@Ethan](https://community.thinkgeo.com/u/Ethan)\
**Post date:** [August 4, 2015, 3:34am UTC](https://community.thinkgeo.com/t/display-marker-of-my-sql-server-table-coordinates/6579/4 "2015-08-04T03:34:31Z")

</div>

Hi&nbsp;Raja,&nbsp;  
&nbsp;&nbsp;  
&nbsp;It&nbsp;looks&nbsp;you&nbsp;post&nbsp;this&nbsp;question&nbsp;in&nbsp;another&nbsp;topic,&nbsp;I&nbsp;will&nbsp;reply&nbsp;you&nbsp;there.&nbsp;  
&nbsp;&nbsp;  
&nbsp;Regards,&nbsp;  
&nbsp;&nbsp;  
&nbsp;Don