Rowfilter

[justputitdown]

i have the following code:

 [LEFT]filesData.ReadXml(Server.MapPath("users/" & m_User.ID.ToString) & "/myfiles.xml")

filesData.Tables("file").DefaultView.RowFilter = "fileid <> '00000000'"

dgdMyFiles.DataSource = filesData

dgdMyFiles.DataBind()[/LEFT]

where filesData is a dataset and dgdMyFiles is a datagrid. In the xml file there is a a record in which the fileid tag contains 00000000. I dont want this to show up in the datagrid but when i use the above code the datagrid still displays the record whose fileid = 00000000



Any ideas?​

http://www.vbdotnetforums.com/

 

[lingsn]

Well, it look ok for me, unless your fileid got extra space like '00000000 ', may be using the trim to try it out:

filesData.Tables("file").DefaultView.RowFilter = "TRIM(fileid) <> '00000000'"