<asp:Chart ID="Chart1" runat="server" DataSourceID="SqlDataSource1" Height="245px" Width="285px"> <Titles> <asp:Title Text="Coils status"></asp:Title> </Titles> <Series> <asp:Series Name="Series1" ChartType="Line"> </asp:Series> </Series> <ChartAreas> <asp:ChartArea Name="ChartArea1"> <AxisY Title="coil id"> </AxisY> <AxisX Title="status"> </AxisX> </asp:ChartArea> </ChartAreas> </asp:Chart>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" SelectCommand="SELECT PDL_ID_COIL, PDL_CD_STATUS FROM V_PR_DATA_IP_CG2 WHERE (PDL_CD_STATUS = 'UP') OR (PDL_CD_STATUS = 'WW') OR (PDL_CD_STATUS = 'WS') OR (PDL_CD_STATUS = 'WC') ORDER BY PDL_CD_STATUS"> </asp:SqlDataSource>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)