Hi
I am using a repeator control that loads Months from an array LOADMONTH(). What i am trying to do is to get the Month number as well so that with January it will return 1 and so on...


Thanks


*********************************************
<td>
        <asp:Repeater ID="RPTMonth" runat ="server" >
        <ItemTemplate>
            <% Dim NCategory As String = Request.QueryString("Category")
                Dim NYear As String = Request.QueryString("Year")

                %>


        <a href ='http://localhost/Bounty_NewsArchive/default.aspx?Category=<%=NCategory%>&Month=<%=NMon th%>&Year=<%#Container.DataItem%>'><%#Container.Da taItem%> - <%=NYear%> - <%=NCategory%></a>

        </ItemTemplate>
           <SeparatorTemplate ><br /></SeparatorTemplate>

        </asp:Repeater>

    </td>


    <td>
    <asp:Repeater ID="RPTYear" runat="server">
          <ItemTemplate>
          <%
                 Dim Ncategory As String = Request.QueryString("Category")
                 Dim NMonth As String = Request.QueryString("Month")
          %>

        <a href ='http://localhost/Bounty_NewsArchive/default.aspx?Category=<%=NCategory%>&Month=0&Year= <%#Container.DataItem%>'><%#Container.DataItem%> News Archive</a>

         </ItemTemplate>
         <SeparatorTemplate ><br /></SeparatorTemplate>
    </asp:Repeater></td>

*******************************************
 Public Function LoadMonths() As Array
        Dim Month(11) As String
        Month(0) = "January"
        Month(1) = "February"
        Month(2) = "March"
        Month(3) = "April"
        Month(4) = "May"
        Month(5) = "June"
        Month(6) = "July"
        Month(7) = "August"
        Month(8) = "September"
        Month(9) = "October"
        Month(10) = "November"
        Month(11) = "December"

        Return Month
    End Function

Why are you using an array? You an enum; this is exactly what they are for :)
Put the enum in the global code, and you'll be able to reuse it throughout the project. I'm not entirely sure of the exact name, as it's been a while since I worked with TBH, but there's definitly something like "Globals", that I use for similar stuff.

Another tip I would give you is to first use a date, and then a month. I.e. 200802 for February 2008, and 200803 for March. The easiest way to accomplish this is by doing something along the lines of the following:

SQL: SELECT YEAR(GETDATE()) * 100 + MONTH(GETDATE())
C#: Convert.ToString(((DateTime.Now.Year * 100) + DateTime.Now.Month))

Reason for this is that it’s far easier to perform calculations and proper sorting :)

HTH.



http://entropia-online.blogspot.com/