<div>
<div class="content wysiwyg-content">
We have a drop-down list whose datasource is a dataview. We are filtering the drop-down based on the value of phase, which can be ‘A’, ‘E’ or ‘P’. Our filter looks at MST_Auxiliary_Value, which is either an empty string, ‘A’ or ‘&lt;&gt;A’. This code to set the filter:<br />
<br />
CType(EMP_Status.DataSourc<wbr />e, DataView).RowFilter = &quot;Trim(MST_Auxiliary_Value)<wbr /> = '' or IIF(LEN(MST_Auxiliary_Valu<wbr />e) &lt;&nbsp;3,MST_Auxiliary_Value = '&quot; &amp;&nbsp;phase &amp;&nbsp;&quot;',Substring(MST_Auxiliary<wbr />_Value,3,1<wbr />) &lt;&gt;&nbsp;'&quot; &amp;&nbsp;phase &amp;&nbsp;&quot;')&quot;<br />
<br />
This filter works fine on our computers. We are including rows with an empty auxiliary value and those that match the phase (or don’t match the phase in the ‘&lt;&gt;A’ case). On our client’s computer, we are getting the other rows but not the one where MST_Auxiliary_Value is an empty string. What could possibly be causing this discrepancy? <br />
<br />
We checked their data and everything has the right value and correct lengths. Our computers are Windows 7 and XP. The client’s computer that had the problem is XP.
</div>
</div>


We have a drop-down list whose datasource is a dataview. We are filtering the drop-down based on the value of phase, which can be ‘A’, ‘E’ or ‘P’. Our filter looks at MST_Auxiliary_Value, which is either an empty string, ‘A’ or ‘<>A’. This code to set the filter:

CType(EMP_Status.DataSource, DataView).RowFilter = "Trim(MST_Auxiliary_Value) = '' or IIF(LEN(MST_Auxiliary_Value) < 3,MST_Auxiliary_Value = '" & phase & "',Substring(MST_Auxiliary_Value,3,1) <> '" & phase & "')"

This filter works fine on our computers. We are including rows with an empty auxiliary value and those that match the phase (or don’t match the phase in the ‘<>A’ case). On our client’s computer, we are getting the other rows but not the one where MST_Auxiliary_Value is an empty string. What could possibly be causing this discrepancy? 

We checked their data and everything has the right value and correct lengths. Our computers are Windows 7 and XP. The client’s computer that had the problem is XP.

.Net Dataview Data Filter not always working

We have a drop-down list whose datasource is a dataview. We are filtering the drop-down based on the value of phase, which can be ‘A’, ‘E’ or ‘P’. Our filter looks at MST_Auxiliary_Value, which is either an empty string, ‘A’ or ‘&lt;&gt;A’. This code to set the filter:

CType(EMP_Status.DataSource, DataView).RowFilter = &quot;Trim(MST_Auxiliary_Value) = &#39;&#39; or IIF(LEN(MST_Auxiliary_Value) &lt; 3,MST_Auxiliary_Value = &#39;&quot; &amp; phase &amp; &quot;&#39;,Substring(MST_Auxiliary_Value,3,1) &lt;&gt; &#39;&quot; &amp; phase &amp; &quot;&#39;)&quot;

This filter works fine on our computers. We are including rows with an empty auxiliary value and those that match the phase (or don’t match the phase in the ‘&lt;&gt;A’ case). On our client’s computer, we are getting the other rows but not the one where MST_Auxiliary_Value is an empty string. What could possibly be causing this discrepancy? 

We checked their data and everything has the right value and correct lengths. Our computers are Windows 7 and XP. The client’s computer that had the problem is XP.

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.