topic How to create query layer based upon SQL Server Spatial and display it on map cntrl in ArcObjects SDK Questions https://community.esri.com/t5/arcobjects-sdk-questions/how-to-create-query-layer-based-upon-sql-server/m-p/715446#M19074 <HTML><HEAD></HEAD><BODY><SPAN>I am stumped.&nbsp; I have a sql server database, and I have a table with valid geometry fields.&nbsp;&nbsp; I am able to define the ISqlWorkspace, and build the IQueryDescription&nbsp; by doing a "select * from maptable" (and I have tried specifiying manually the fields, no change.&nbsp;&nbsp; I am able to retrieve the column names and values via the SqlWorkspace.GetColumns() call.&nbsp;&nbsp; But when I try to take this queryDescription and SqlWorkspace, I am unable to cast it to a featureclass.&nbsp; Is there any samples or tutorials or ideas on how to make the MapControl to display a table with Sql Server 2008 R2 Spatial's geometry column in c# or vb.net?&nbsp;&nbsp; Any help would be appreciated.</SPAN><BR /><BR /><SPAN>Steve</SPAN></BODY></HTML> Fri, 11 May 2012 18:57:12 GMT StevenPaplanus 2012-05-11T18:57:12Z How to create query layer based upon SQL Server Spatial and display it on map cntrl https://community.esri.com/t5/arcobjects-sdk-questions/how-to-create-query-layer-based-upon-sql-server/m-p/715446#M19074 <HTML><HEAD></HEAD><BODY><SPAN>I am stumped.&nbsp; I have a sql server database, and I have a table with valid geometry fields.&nbsp;&nbsp; I am able to define the ISqlWorkspace, and build the IQueryDescription&nbsp; by doing a "select * from maptable" (and I have tried specifiying manually the fields, no change.&nbsp;&nbsp; I am able to retrieve the column names and values via the SqlWorkspace.GetColumns() call.&nbsp;&nbsp; But when I try to take this queryDescription and SqlWorkspace, I am unable to cast it to a featureclass.&nbsp; Is there any samples or tutorials or ideas on how to make the MapControl to display a table with Sql Server 2008 R2 Spatial's geometry column in c# or vb.net?&nbsp;&nbsp; Any help would be appreciated.</SPAN><BR /><BR /><SPAN>Steve</SPAN></BODY></HTML> Fri, 11 May 2012 18:57:12 GMT https://community.esri.com/t5/arcobjects-sdk-questions/how-to-create-query-layer-based-upon-sql-server/m-p/715446#M19074 StevenPaplanus 2012-05-11T18:57:12Z