Can I get a sample to showlayer map taken from the table sql sever 2008 ... ???
perhaps also for database postgrees
first you have to store layer name and path of shape files on your db and retriv
I've got on the table, with the field type shape(geom) polyline, polygon andpoint to the field of X and Y.
and I have an example in aspmap :
oconn="Data Source=myServer;Persist Security Info=True;Password=12345;User ID=sa;Initial Catalog=my_DATABASE"
sqlSelect = "SELECT *, geom.STAsBinary() as WkbGeometry FROM [TL_AREA]"Dim adapter As SqlClient.SqlDataAdapter = New SqlClient.SqlDataAdapter(sqlSelect, oconn)
Dim dataTable As DataTable = New DataTable()
Dim LayerProp As Layer = map.AddSpatialDataLayer(dataTable, "WkbGeometry")
how in actualmap....???!!
Seems as you are using an old version of AspMap.
See the Using ActualMap/Mapping Basics/Spatial Databases/SQL Server topic on how to add/edit data from SQL Server, Postgre etc.