I''m creating a bar chart control but nothing is being display
i''m trying to display each week how much auction has been created
but nothing
work can someone take a look to my code pleaase
Dim conn As New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\Chloé\Desktop\Ajax Saving\App_Data\VirgoPlaza.mdf;Integrated Security=True;User Instance=True")
conn.Open()
Dim cmd As New SqlCommand("SELECT datepart(year, StartDate) Year, COUNT(Auction.AuctionID) AS Expr1 FROM Auction INNER JOIN Item ON Auction.ItemID = Item.ItemID GROUP BY Auction.StartDate", conn)
Dim da As New SqlDataAdapter(cmd)
Dim dt As New DataTable()
da.Fill(dt)
Dim x As String() = New String(dt.Rows.Count - 1) {}
Dim y As Decimal() = New Decimal(dt.Rows.Count - 1) {}
For i As Integer = 0 To dt.Rows.Count - 1
...
Go to the complete details ...