Lucene .NET index display in <asp.treeview> control

See more:

.NET

treeview

Lucene

Hi,

I have an issue while searching the Lucene (built in Azure Storage Blob) using SimpleFacetSearch and display each unique value in tree (with facet count)

Industry Tree Example:
SIC2(100)
SIC4(50)
SIC4(50)

Country Tree Example:
US (100)
VA (50)
DC (50)

etc

I stored the denormalized table's index built in Lucene

Any ideas would be appreciated.

Thanks,
Jay

What I have tried:

_query = New MatchAllDocsQuery("SIC2_Code")

sfs = New SimpleFacetedSearch(_Reader, "SIC2_Code") 'Search SIC 2 Code
hits = sfs.Search(_query, 1000000000)
totalHits = hits.TotalHitCount

For Each hpf In hits.HitsPerFacet
hitCountPerGroup = hpf.HitCount

For Each doc As Document In hpf.Documents
SIC2 = doc.GetField("SIC2_Code").StringValue
SIC4 = doc.GetField("SIC4_Code").StringValue
SIC2Desc = doc.GetField("SIC2Desc").StringValue
SIC4Desc = doc.GetField("SIC4Desc").StringValue

'Add nodes to Tree
Next
Next


_query = New MatchAllDocsQuery("Country")

sfs = New SimpleFacetedSearch(_Reader, "Country") 'Search Country
hits = sfs.Search(_query, 1000000000)
totalHits = hits.TotalHitCount

For Each hpf In hits.HitsPerFacet
hitCountPerGroup = hpf.HitCount
For Each doc As Document In hpf.Documents
State = doc.GetField("StateCode").StringValue

'Add nodes to Tree
Next
Next