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 ...