Best practice for showing data from diferent queries in same form

[Corobori]

I need to make something like this:

http://www.corobori.com/sos/picDemartti.jpg

That is the 1st time I am doing like this in ASP.NET (did it tons of
times in "old" ASP) so I would like to do it the "right way" from the
beginning.

Data to populate 1A and 1B are from one query, 2A and 2B from another
and 3A and 3B from a 3rd query. Each of them will be clickable with a
popup window showing a larger pic and more text.

It is not a list with paging or sorting. I just need to show 6 shoes. I
need to randomly select 2 children's shoes for the left column; 2
women's shoes for the central column and 2 men's shoes for the 3rd
column

So, what's the best to do this ?

Jean-Luc

[garethdjames]

How big are the datasets?

Can you cache them in memory as datatables then do a random selection?

[Corobori]

Very small datasets. I guess no more than 50 records

[Lucas Tam]

"Corobori" <jl****@corobor i.com> wrote in news:1115385907 .074223.168810
@o13g2000cwo.go oglegroups.com:

It is not a list with paging or sorting. I just need to show 6 shoes. I
need to randomly select 2 children's shoes for the left column; 2
women's shoes for the central column and 2 men's shoes for the 3rd
column

So, what's the best to do this ?

I would use a multi-statement random select and place it into a single
dataset.

On output, I would output the datagrid.

--
Lucas Tam (RE********@rog ers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/

[Corobori]

But how can I say that records 1 and 2 should got into 1st col 1st and
2nd row; records 3 and 4 in 2nd col 1st and 2nd row; records 5 and 6
in 3rd col 1st and 2nd row ?

[Corobori]

Here is how I did it:

1) I created a UserControl representing one cell including a repeater
and I bind it to the db with a parameter for selection

2) I created a form with 3 labels as a place holder. Then I added the
following code:

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
 
Dim tempUserControl = Page.LoadControl("Cell.ascx")
tempUserControl.DisplayDataType = "1"
cel1.Controls.Add(tempUserControl)
 
tempUserControl = Page.LoadControl("Cell.ascx")
tempUserControl.DisplayDataType = "2"
cel2.Controls.Add(tempUserControl)
 
tempUserControl = Page.LoadControl("Cell.ascx")
tempUserControl.DisplayDataType = "3"
cel3.Controls.Add(tempUserControl)
 
tempUserControl = Nothing
End Sub
 

My reference is
http://www.dotnetjunkies.com/Tutoria...9AF776E21.dcik

What do you think ?

Jean-Luc
http://www.corobori.com