problem binding to filtered dataview
<p>I'm having a problem with the dtaview.  I'm dynamically creating new datacolumns, assigning  them values, and adding them into my datatable.  Before using a filter, this was fine when binding.  All values appeared.  </p>

<p>However, I have since chosen to reduce returned results by filtering (by letter), and my returned dataview doesn't seem to allow binding with the newly created data columns.  I've mined into the filtered view, and can see that the values are present that I need.  </p>

<p>I'm trying to avoid putting everything back into a table again after applying the filter.  An sql query based on letter is out of the question, as the whole original table is sitting in view state.</p>

<p>Here are some code snippets:</p>

<pre><code>        --Firstly create new datacolumn

        Dim ICount As System.Data.DataColumn = New System.Data.DataColumn
        ICount.DataType = System.Type.GetType("System.String")
        ICount.AllowDBNull = True
        ICount.ColumnName = "ICount"
        register.Columns.Add(ICount)

        --integer value is first calculated and then put into the datatable row

        row("ICount") = IntegerCount.ToString()

        --filtered view is created from datatable (returned from viewstate)

        Dim filteredView As New Data.DataView(pTable, FilterExpression, "Surname", Data.DataViewRowState.OriginalRows)

         --view is bound

         grd.DataSource = filteredView
         grd.DataBind()

         --Markup

         &lt;asp:TemplateField HeaderText ="ICount" SortExpression="ICount"&gt;
                        &lt;ItemTemplate&gt;
                            &lt;asp:Label ID="IC" runat="server"                     Text='&lt;%# Bind("ICount") %&gt;'&gt;&lt;/asp:Label&gt;
                        &lt;/ItemTemplate&gt;
                &lt;/asp:TemplateField&gt;
</code></pre>

<p>All of the non dynamic datacolumns are fine.  Mining into both the datatable and the filtered view show values are there.</p>

<p>Any help would be much appreciated!!!</p>
