Hi,
How to open multiple recordset inside loop in ASP.Net
Usually i do it in Classic-ASP (for your information i have furnished my ASP code here:)
Please take a look on the below ASP code and let me know how to do the same in ASP.NET3.5
Expecting your valuable reply.
Regards,
Thiru.
DB structure: table name :tblcustomer
field 1 : name
field 2 : city
field 3 : referredby
Table Data: name city referredby
thiru chennai funda
A pune thiru
B mumbai thiru
C pune A
D pune C
E delhi A
From the above data - i can show the referrence chain of a customer "D" in Classic ASP as:
Assume that i have opened the DB connection (conn) and declared recordset (A-sql,B-sql,C-sql)
set A-sql=conn.execute("select * from tblcustomer where name='D'")
do until A-sql.eof
response.write("Name: " & A-sql("name") & " referredby: " & A-sql("referredby")) & "<br>"
set B-sql=conn.execute("select * from tblcustomer where name='" & A-sql("referredby") & "'")
do until B-sql.eof
response.write("Name: " & B-sql("name") & " referredby: " & B-sql("referredby")) & "<br>"
set C-sql=conn.execute("select * from tblcustomer where name='" & B-sql("referredby") & "'")
do until C-sql.eof
response.write("Name: " & C-sql("name") & " referredby: " & C-sql("referredby")) & "<br>"
C-sql.movenext
loop
B-sql.movenext
loop
A-sql.movenext
loop
Output is: Name: D referredby: C
Name: C referredby: A
Name: A referredby: thiru