Query Builder

Jose_LuisGarcinuno-Oporto

Situation : you have a layer in TOC, then right click and properties display, then go to Definition Query then Query Builder.

I been trying to mimic this procedure using Arc objects with C#,

as an example : 

 IQueryFilter pQueryfilter = new QueryFilterClass();
pQueryfilter.WhereClause = "Num ='" + comboBox2.Text + "'";
IFeatureSelection pfeatureselection = pFeatureLayer as IFeatureSelection;
pfeatureselection.SelectFeatures (pQueryfilter, esriSelectionResultEnum.esriSelectionResultNew, false);

but the code above it doesn't do what I want : the code above select the features eventually will zoom into......, but still,   if I go to my table I can see all the records and highlighter the selected ones, I just want to see in my table those ones selected as it is under Query Builder. It is possible to do it?. 

I know that there is a way to create a new layer from the selected features and added to the project depending in the selection but this is not what I want either.

Thanks

MaxMax2

Just cast your layer to IFeatureLayerDefinition2 and set its DefinitionExpression property. This property is actually the same thing that you set via layer's properties definition query.

<SPAN class="keyword token">var</SPAN> featureLayerDefinition <SPAN class="operator token">=</SPAN> featureLayer <SPAN class="keyword token">as</SPAN> IFeatureLayerDefinition2<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>featureLayerDefinition <SPAN class="operator token">!=</SPAN> <SPAN class="keyword token">null</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; featureLayerDefinition<SPAN class="punctuation token">.</SPAN>DefinitionExpression <SPAN class="operator token">=</SPAN> $<SPAN class="string token">"Num = '{comboBox2.Text}'"</SPAN><SPAN class="punctuation token">;</SPAN>‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>