Dificulties using Repeater (new to this control)

Hi, I have a page that shows data from a sql database. The output is to show ID and Name and the Name should be a hyperlink. The list is long so I would like to show as repeated columns. ID. Name. ID. Name. ID. Name I have been used to using Gridview but I think I should be using a Repeater control or data list. I am not sure about the coding for these and the HTML layout language. Seen some notes on Gridview nested in a Repeater but I confess I do not understand the requirements to make it work and layout. Many thanks

Re: Dificulties using Repeater (new to this control)

Wouldn't a GridView with paging enabled do the job?

Re: Dificulties using Repeater (new to this control)

Hi,

Yes I see your point. However I really do not want to have just two columns down page.

It would not look quite right. Four colums much better. Thanks

Re: Dificulties using Repeater (new to this control)

One of the simple option is design the model accordingly. For eg:

public class Detail
{
        public int Id1 { get; set; }
        public string Name1 { get; set; }

        public int Id2 { get; set; }
        public string Name2 { get; set; }

        public int Id3 { get; set; }
        public string Name3 { get; set; }
}

and bind the repeater

<asp:Repeater ID="Repeater1" runat="server">
        <HeaderTemplate>
            <table>
                <tr>
                    <td>Id</td>
                    <td>Name</td>
                    <td>Id</td>
                    <td>Name</td>
                    <td>Id</td>
                    <td>Name</td>
                </tr>
        </HeaderTemplate>
        <ItemTemplate>
            <tr>
                <td><asp:Label Text='<%# Eval("Id1") %>' runat="server" />
                </td>
                <td><asp:HyperLink Text='<%# Eval("Name1") %>' runat="server" />
                </td>
                <td><asp:Label ID="Label1" Text='<%# Eval("Id2") %>' runat="server" />
                </td>
                <td><asp:HyperLink ID="HyperLink1" Text='<%# Eval("Name2") %>' runat="server" />
                </td>
                <td><asp:Label ID="Label2" Text='<%# Eval("Id3") %>' runat="server" />
                </td>
                <td><asp:HyperLink ID="HyperLink2" Text='<%# Eval("Name3") %>' runat="server" />
                </td>
            </tr>
        </ItemTemplate>
        <FooterTemplate>
            </table>
        </FooterTemplate>
    </asp:Repeater>

Re: Dificulties using Repeater (new to this control)

Hi,

Thanks for that.

However, I do not have a database column which shows Id1, Id2, Id3 and Name 1, Name2, Name3.

So if I change to my actual headings I get three duplicate columns showing the same data.

Of course what I want is the first two colums to show ID 1,2 3, 4 etc with associated names. Then the next two colums to show ID 10,11,12, etc with

associated names.

Also how do I add an associated lnk url to the hyperlink.

I hope this is clear. Many thanks.

Re: Dificulties using Repeater (new to this control)

You can use NavigateUrl property of HyperLink

<asp:HyperLink Text='<%# Eval("Name1") %>' NavigateUrl="~/Default.aspx" runat="server" />

Re: Dificulties using Repeater (new to this control)

That means you want to display 2 fields in 4 columns isn't it? ( Say values 1 to 10 in first 2 columns and 11 to 20 in next 2 columns ?)

I don't think it is possible by getting values directly from DB.

One possiblity is after getting values displayed in repeater, the cell values are transferred to another table re-arranging the display.

Re: Dificulties using Repeater (new to this control)

Hi,

You have want I wish to achieve correctly.

I do not know how to transfer cell values to another but I understand your thoughts

Thanks

Re: Dificulties using Repeater (new to this control)

Another way I think possible is

To select odd and even rows of the database AS some 2 different names and bind it to Repeater. Can you try it?

I think even and odd rows can be selected in separate statements. I don'tget how to select Odd and Even rows separately in a sigle statement. Try it and inform me if succeed.

Good Luck

Re: Dificulties using Repeater (new to this control)

I would try to return it in that format from SQL and stick to the GridView, since you said you are familiar with it.

Try something like (just make sure it works correctly with uneven number of records.) Depending on what you want to do with it once you have it in the GridView...keep in mind that it would be two SQL records but 1 GridView Record

SELECT A.FullName, A.CreatedOn, B.FullName, B.CreatedOn
FROM
(
	SELECT TOP 50 PERCENT FullName, CreatedOn,ROW_NUMBER() OVER(ORDER BY FullName ASC) AS RowNumber
	FROM SystemUser
	ORDER BY FullName ASC
) A

LEFT JOIN
(
	SELECT TOP 50 PERCENT FullName, CreatedOn,ROW_NUMBER() OVER(ORDER BY FullName DESC) AS RowNumber
	FROM SystemUser
	ORDER BY FullName DESC
) B
ON A.RowNumber = B.RowNumber

Re: Dificulties using Repeater (new to this control)

Hi Basquait

won't it show same records in both column in different sort order?

can you try somethging like

SELECT ID AS 1d1, fullName as fullname1 from Table where Mod (id, 2)= 0

LEFT JOIN

SELECT ID as Id2, fullName as fullname2 from Table where Mod (id,2)<> 0

provided ID is an identirty column - ineger type

.. I am not very falilier with SQL queries.

Re: Dificulties using Repeater (new to this control)

Hi No it won't be the same records. The one list is sorted ASC and the other DESC and then I am only selecting the 1st 50% of each list. Your method is probably better. If there is no ID integer in his table, he could still use my Rownumber

Re: Dificulties using Repeater (new to this control)

OK I agree.. Thank you for clarifying it.

Then Can you please give the complete query if we use the method I suggested.

Re: Dificulties using Repeater (new to this control)

In SQL % is used for MOD. I think it was MOD pre SQL 2005.

Assuming there is no incremental integer and we have to create one.

SELECT *,Row_number () over(ORDER BY Fullname)as RowNumber
INTO #TempA
FROM
(
	SELECT Fullname, CreatedON , Row_number () over(ORDER BY Fullname) % 2 AS Remainder
	FROM SystemUser
)xxx
WHERE Remainder = 0

SELECT *,Row_number () over(ORDER BY Fullname)as RowNumber
INTO #TempB
FROM
(
	SELECT Fullname, CreatedON , Row_number () over(ORDER BY Fullname) % 2 AS Remainder
	FROM SystemUser
)xxx
WHERE Remainder <> 0

SELECT #TempA.FullName, #TempA.CreatedOn, #TempB.FullName, #TempB.CreatedOn
FROM #TempA
FULL OUTER JOIN #TempB
ON #TempA.RowNumber = #TempB.RowNumber

Re: Dificulties using Repeater (new to this control)

Will it work

Here, there is only one table

Re: Dificulties using Repeater (new to this control)

It'll work. I first created 2 Temp tables and then joined them.