Nested datalist with related queries

S

sorCrer

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
one.

How do I manage this in ASP.net? 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:

A
A100
A100100
A100200

With each child being a member of the parent code!

Idea's?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,733
Messages
2,569,440
Members
44,832
Latest member
GlennSmall

Latest Threads

Top