listview rows hiding vb.net

[marfi95]

Is there a way to hide a row in a listview w/o removing it ?

Or if I have to use a hidden listview to store another view, a way to
duplicate the contents extremely fast. there could be thousands of
rows in the list.

[rb]

ma*****@yahoo.com wrote:

>Is there a way to hide a row in a listview w/o removing it ?

Or if I have to use a hidden listview to store another view, a way to
duplicate the contents extremely fast. there could be thousands of
rows in the list.

have you tried a query?

Dim connDB As New ADODB.Connection
Dim sqlcmd As New ADODB.Command
Dim rs As New ADODB.Recordset

your connection string to database

sqlcmd.ActiveConnection = connDB

sqlcmd.CommandText = "sql statement" or use a text string to
create adhoc query
sqlcmd.CommandType = ADODB.CommandTypeEnum.adCmdText

rs = sqlcmd.Execute

Populate listview.