Hi all.
I have problem to bind two series in chart using same executereader. The graph only show series 1 only. series 2 not display.
Here is my code behind using vb.net:
If Not IsPostBack Then Dim sqltext6 As String sqltext6 = "" sqltext6 = sqltext6 & " SELECT DATENAME(MONTH, ISR_DateCreated) AS Month, count(V_ISRMasterlist.InputQuantity) AS InputQuantity, COUNT(ISR_ShipmentQty) AS ShippingQuantity FROM ISR INNER JOIN " sqltext6 = sqltext6 & " V_ISRMasterlist ON ISR.ISR_No = V_ISRMasterlist.ISRNo WHERE DATENAME(MONTH, ISR_DateCreated) <> DATENAME(MONTH, GETDATE()) GROUP BY DATENAME(MONTH, ISR_DateCreated) ORDER BY DATENAME(MONTH, ISR_DateCreated) DESC " Using myConnection As New SqlConnection myConnection.ConnectionString = ConfigurationManager.ConnectionStrings("OESConnectionString").Connect ...

Go to the complete details ...