How to: populate TreeView control from a database in VB.NET

[sumair4u]

Dear Mkaatr,, i tried it with my SQLSERVER Database, but it gave me the following error:

"There is already an open DataReader associated with this Command which must be closed first."

After that I Surrounded the Filltree by Catch Try,

it didnot gave the error mention above, but not working propely, i mean it showing only Parent items, not child,,

plz tell me whats the problem

Thank you

[mkaatr]

@sumair4u

Hi there...

Sorry for the late response. In SQL Server, each time you open a DataReader, you can't open another one unless you close the previous first.

To solve this, add the following to the end of the connection string:

MultipleActiveResultSets=True

yours sincerely.

[dnivye21]

brilliant!!



[mellwell2005]

This tutorial is very helpful... THANK YOU!

[mkaatr]

@mellwell2005

You are welcome.

[bopert]

thank you sir!

[aalamnaryab]

how to populate tree view from All drives>folders>files of all disks

[mkaatr]

@aalamnaryab

Hi there...

search the website for : "Re: alamnaryab - view hard disk dir in treeview" or just search the questions and answers section. I uploaded a video for that.

yours

[neilmas]

gracias.

[waroftheworldseu]

I thought this was YUI 2 TreeView... maybe should write VB into the title :)

[mkaatr]

@waroftheworldseu

Sorry about that, I updated the title as suggested.

yours.

[ddsharper]

thanks so much!