Dear friends,

I'm new to VB.net(2005). I want to ask, how can we filter just to show the data in List View in design mode. Example like this situation.

 
No.         Item.     Occur   

1              X             10

2              y              15

3              X             10

4              Z              4

5              X             10

 

In this case I want to display only like this. No redundant record.

No.         Item     Occur   

1              X             10

2              y              15

3              Z              4

 
I believe it can just setting at List View properties but I don’t have any any idea to do it.
Thank you in advanced.

 

 Can do this in the SQL?

 SELECT DISTINCT [Occur], [Item], [No] FROM
 

MichaelW, Thank you on your respond. Actually I'm not access from DB. Just from .TXT file. I'm scan that file and populate it. I want display it without redundant record. How can I do this ?

 Hi,

Anybody can help me to solve this problem. I'm really need to solve it to finished up my course project. 

 Use a DictionaryEntry class or an List generic class to store the lines that you have taken. Use the Item object like the key... now..., before to add the line into the ListView control.. you must to check into the collection for the Item keys using the Contains method. Surely the info into the text file is delimited by a character (i.e. a comma)... You can split the line into an array using the Split method available in the String class. Then, store the first cell or item in the array into a collection that implements the IDictionaryEntry class, to decide if the line will be included into the ListView control (using the Contains or ContainsKey method).

 

Regards 

Dear Friend,

I'm already solve this problem Thank a lot on your help.