Calculation Of Values

Hi.

i have the code :

cmd = New SqlCommand("SELECT sales,country,year FROM salesTable WHERE (country = " & (CountryBlk) & " AND branch = " & (NameSnif) & " AND datepart(yyyy,year)=" & (YearBlk) & ") order by datepart(mm,year) ", cnn)
        cnn.Open()
        rdr = cmd.ExecuteReader( _
        CommandBehavior.CloseConnection)
      

  While x < 12
             If rdr.Read = Nothing Then
                Exit While
            End If
            
             varcount(x) = rdr("sales")

            TempMonth = rdr("year")
            MonthNumber(x)=datepart(DateInterval.Month,TempMonth)
            x = x + 1
        End While

 

i want to calculate and put into the varcount(x) value all sales of the same month

 

thanks