Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Nested datalist with related queries

Thread Tools

Nested datalist with related queries

Posts: n/a
Hi All,

Something I can't get my head around!

In classic asp I could:

SELECT code FROM tblCodes
While not rs.eof

SELECT description FROM tblCodes WHERE code LIKE '" & rs.code &

i.e I could pass a nested query based on the resultset of the parent

How do I manage this in I understand related datalists/grids
but in this instance the relationship is wildcard based and uses a
like operator.

The codes in this instance are hierarchical data as follows:


With each child being a member of the parent code!

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
GridView nested in DataList - refreshing corresponding DataList row after updating GridView row H5N1 ASP .Net 0 04-26-2006 11:41 PM
xslt queries in xml to SQL queries Ian Roddis Python 3 02-26-2006 06:49 PM
Nested datalist - parent datalist refresh schapopa ASP .Net 1 01-12-2006 03:56 PM
Setting up a datalist control - Item_DataBound for a datalist in a datalist Nevyn Twyll ASP .Net 8 09-09-2004 10:13 PM
so many queries within queries I'm confused Abby Lee ASP General 11 08-06-2004 07:56 PM