I have a page that a client asked me to make that consists of the following:
Repeater1 (Client Data)
Label1 = Number of Records
Repeater2 (More data where ClientID supplied = ClientID on the table) (Limit 4 recs)
Label2 = Number of Records
Repeater3 (More data where ClientID supplied = ClientID on the table) (limit 12 recs)
Label3 = Number of Records
Repeater4 (More data where ClientID supplied = ClientID on the table) (limit 25 recs)
end repeater
How would you suggest I handle this to eliminate 4 separate queries hitting the database? This is all expecting that I will use the following queries based upon the situation above:
Repeater1 = "SELECT *, (SELECT COUNT(ID) FROM Table1) As Count1, (SELECT COUNT(ID) FROM Table2) As Count2, (SELECT COUNT(ID) FROM Table3) As Count3, FROM Table4 WHERE ID=ID"
How would you suggest I tap the other repeaters along with the first, if it is possible? Please give me suggestions.. should I use a DataSet or just a DataReader? Anything will help. Thank you.