Rowfilter won't pass value

I'm fairly new so please bear with me.

I'm trying to pass a dataview value to a textbox that will then be used to populate a datatree. After struggling in vain with a hittest and datagrid for awhile, I took a step back and decided to just pass the value through a dataview to a text box. When I search using the Rowfilter property, I'm unable to get it to find any records in my designated column that start with "00". What am I doing wrong here?

Thanks in advance for any help offered!


Dim sortedView As DataView = DataSet11.Tables("PartMaster").DefaultView
With sortedView
.Sort = "[Cytopeia PN]"
While .RowFilter = "[Cytopeia PN]='00%'"

Dim i As Integer
For i = 0 To sortedView.Count - 1
txtBom.Text = (sortedView(i)("[Cytopeia PN]").ToString())
Next
End While

I'm fairly new so please bear with me.

I'm trying to pass a dataview value to a textbox that will then be used to populate a datatree. After struggling in vain with a hittest and datagrid for awhile, I took a step back and decided to just pass the value through a dataview to a text box. When I search using the Rowfilter property, I'm unable to get it to find any records in my designated column that start with "00". What am I doing wrong here?

Thanks in advance for any help offered!


Dim sortedView As DataView = DataSet11.Tables("PartMaster").DefaultView
With sortedView
.Sort = "[Cytopeia PN]"
While .RowFilter = "[Cytopeia PN]='00%'"

Dim i As Integer
For i = 0 To sortedView.Count - 1
txtBom.Text = (sortedView(i)("[Cytopeia PN]").ToString())
Next
End While
--------------------------------------------------------------------
I think instead of the filter "[Cytopeia PN]='00% you may want to try:
"[Cytopeia PN] like '00%'" since you are doing a pattern comparison.