ThinkGeo.com    |     Documentation    |     Premium Support

Create and Edit Shapes in SQL 2008 using Geometry fields

#1

Hi,


Does Map Suite support directly editing the shape information found in the Geometry fields of SQL 2008?



#2

Steve,


Yes, you can do it just like other Feature layers.

 


Feature feature = sql2008Layer.QueryTools.GetFeatureById("1", new string[] { "CNTRY_Name" });
feature.ColumnValues["CNTRY_Name"] = "Country1";
BaseShape shape = feature.GetShape();
//Do some eidit on the shape
shape.Id = feature.Id;
Feature newFeature = new Feature(shape, feature.ColumnValues);

sql2008Layer.EditTools.BeginTransaction();
sql2008Layer.EditTools.Update(newFeature);
sql2008Layer.EditTools.CommitTransaction();



Hope it helps.


Thanks,

ThinkGeo Support