ASP.NET

ASP.NET RSS

Big Repeater Question for you all

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: Sep 2007

Posts: 1,080

Reputation: SheSaidImaPregy is an unknown quantity at this point

Solved Threads: 68

SheSaidImaPregy SheSaidImaPregy is offline

Offline

Veteran Poster

Big Repeater Question for you all

Nov 6th, 2007

I have a page that a client asked me to make that consists of the following:

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
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
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.

Last edited by SheSaidImaPregy; Nov 6th, 2007 at 5:38 pm.

•

Join Date: Sep 2007

Posts: 1,080

Reputation: SheSaidImaPregy is an unknown quantity at this point

Solved Threads: 68

SheSaidImaPregy SheSaidImaPregy is offline

Offline

Veteran Poster

Re: Big Repeater Question for you all

Nov 6th, 2007

Nevermind, I resolved it. By including many select statements in one, I can then use the "with" statement and bind the rest that way. Thanks anyway!

•

Join Date: Sep 2007

Posts: 1,080

Reputation: SheSaidImaPregy is an unknown quantity at this point

Solved Threads: 68

SheSaidImaPregy SheSaidImaPregy is offline

Offline

Veteran Poster

Re: Big Repeater Question for you all

Nov 7th, 2007

Nevermind... as I thought I solved it, my data provider does not allow multiple queries (Odbc). Any suggestions in combining these queries above? The only thing common they share are the User's ID. I am horrible at creating MySQL queries that are joined or unioned with other selects. Thanks.