This is a multi-part message in MIME format.

------=_NextPart_000_003E_01C1EBAE.35299900
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: 7bit

Hi
 
How can I get the SQL server to out put XML which could then populate a
treeview ?
 

Best Regards

Robert Sindall
______________________________
Home: robert@t...
Hotmail: robert_sindall@h...
______________________________
Tel: +44 (0)1242 518955



 

Hi ! It's a good question.... There are following options (at least I know):
1) Use XML output stream and process it by VB code to suitable for TreeView 
view.
2) Use XML output strem and process it by XSL (I can send You mine if you 
need)
3) Create composite control, witch will get table-like Dataset and built 
TreeView, by manipulating with its object model.

As far as i know neither XQL not SQL XML can built a suitable (e.g. 
hierachical XML, al least elegant). So up to You what to choose...

Cheers.




>From: "Robert Sindall" <robert@t...>
>Reply-To: "aspx_beginners" <aspx_beginners@p...>
>To: "aspx_beginners" <aspx_beginners@p...>
>Subject: [aspx_beginners] Treeview-XML-SQL
>Date: Wed, 24 Apr 2002 16:36:32 +0100
>
>Hi
>
>How can I get the SQL server to out put XML which could then populate a
>treeview ?
>
>
>Best Regards
>
>Robert Sindall
>______________________________
>Home: robert@t...
>Hotmail: robert_sindall@h...
>______________________________
>Tel: +44 (0)1242 518955
>
>
>
>
>
>


_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com

Of course, I told about TreeView of Microsoft IE Web Controls set.


>From: "Robert Sindall" <robert@t...>
>Reply-To: "aspx_beginners" <aspx_beginners@p...>
>To: "aspx_beginners" <aspx_beginners@p...>
>Subject: [aspx_beginners] Treeview-XML-SQL
>Date: Wed, 24 Apr 2002 16:36:32 +0100
>
>Hi
>
>How can I get the SQL server to out put XML which could then populate a
>treeview ?
>
>
>Best Regards
>
>Robert Sindall
>______________________________
>Home: robert@t...
>Hotmail: robert_sindall@h...
>______________________________
>Tel: +44 (0)1242 518955
>
>
>
>
>
>


_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com

Do you have any example code of vb.net building the xml for a treeview ?

Best Regards

Robert Sindall
______________________________
Home: robert@t...
Hotmail: robert_sindall@h...
______________________________
Tel: +44 (0)1242 518955





-----Original Message-----
From: Dmitry Brook [mailto:brook74@h...] 
Sent: 24 April 2002 20:05
To: aspx_beginners
Subject: [aspx_beginners] Re: Treeview-XML-SQL


Hi ! It's a good question.... There are following options (at least I
know):
1) Use XML output stream and process it by VB code to suitable for
TreeView 
view.
2) Use XML output strem and process it by XSL (I can send You mine if
you 
need)
3) Create composite control, witch will get table-like Dataset and built

TreeView, by manipulating with its object model.

As far as i know neither XQL not SQL XML can built a suitable (e.g. 
hierachical XML, al least elegant). So up to You what to choose...

Cheers.




>From: "Robert Sindall" <robert@t...>
>Reply-To: "aspx_beginners" <aspx_beginners@p...>
>To: "aspx_beginners" <aspx_beginners@p...>
>Subject: [aspx_beginners] Treeview-XML-SQL
>Date: Wed, 24 Apr 2002 16:36:32 +0100
>
>Hi
>
>How can I get the SQL server to out put XML which could then populate a

>treeview ?
>
>
>Best Regards
>
>Robert Sindall
>______________________________
>Home: robert@t...
>Hotmail: robert_sindall@h... ______________________________
>Tel: +44 (0)1242 518955
>
>
>
>
>
>
>---
>Change your mail options at http://p2p.wrox.com/manager.asp or to 
>unsubscribe send a blank email to 


_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com