Change Query for Query Layer with code

Discussion created by jamasigEsri on Dec 19, 2012
Latest reply on Oct 8, 2018 by SEria-esristaff

Like • Show 0 Likes0
Comment • 3

i currently have projects that add a map layer from our sql postgres (Postgis) to a project.

my problem is how to change the connection of datasource (connection with postgres) by code (arcobject .net).

i think taht i shoud get the query of the query layer and relodit by the new connection with the new parametrs

but how can i get the query for the query layer to do that?

would anyone have any code they could share to show how someone would use .?

thanks!

Outcomes

3 Replies

jamasigEsri Dec 20, 2012 2:05 AM
I found the solution for the problem, and i want to share it with you, if never some one has the same problem

Dim pTable As ITable = featureLayer.FeatureClass
Dim pDataset As IDataset = pTable
Dim pQueryTableName As IQueryTableName
pQueryTableName = pDataset.FullName
Dim query As String = pQueryTableName.QueryDescription.Query

Jamal Hanine
Like • Show 0 Likes0
Actions
- ganders @ jamasigEsri on Feb 6, 2018 3:21 AM
  Hi
  
  does anyone know, how the querylayer itself is created? i need to do exactyl the same as described (change the source of an existing querylayer). so the solution for getting the information of the existing layer is allready provided. but how do i create the new querylayer from the new source?
  
  best regards
  george
  Like • Show 1 Like1
  Actions
SEria-esristaff Oct 8, 2018 11:09 AM
Hello,
Here is some sample code that shows how to create a Query Layer:

IWorkspaceFactory2 workspaceFactory = new SqlWorkspaceFactoryClass();
string connectionString = "dbclient=oracle11g;" + "serverinstance=190.100.100.200/MYMAP;" + "USER=SDE;" + "PASSWORD=SDE";
ISqlWorkspace sqlWorkspace = workspaceFactory.OpenFromString(connectionString, 0) as ISqlWorkspace;
IQueryDescription queryDescription = sqlWorkspace.GetQueryDescription("SELECT * FROM SDE.MYTABLE");

ITable table = pSqlWorkspace.OpenQueryClass("TestQueryTable", queryDescription);
IFeatureClass featureClass = table as IFeatureClass;
featureLayer.FeatureClass = featureClass;
axMapControl1.Map.AddLayer(pFeatureLayer as ILayer);

This is based on code posted by a user on another forum (https://code.csdn.net/snippets/229166).
Like • Show 0 Likes0
Actions

GeoNet

The Esri Community

Change Query for Query Layer with code

Outcomes

Related Content

Recommended Content