none
Chart control .net 4.0 - How to getting a third value from database RRS feed

  • Question

  • Hello,

    I have a chart control on ASP.Net 4.0, I have sat the X and Y values that will be retrieved from the the database.

    I sat X = column C_NAME, Y = column SERV and it is working correctly.

    I need to get the value of column c which is the City that correspond to column a and display it in the axis label?

    The below code I have will only display the X value:

    this.Chart1.Series[0].PostBackValue = "#AXISLABEL";

    The below code is the query that rerieve the X and Y values:

    SELECT COUNT(HOST) AS SERV, C_NAME, CITY FROM Table11 WHERE (C_NAME = 'PB2') AND (CITY = 'Seattle') GROUP BY C_NAME, CITY

    Thank you,

    Rad


    Radshaykho

    • Moved by Leo Liu - MSFT Wednesday, April 4, 2012 8:44 AM Moved for better support. (From:Visual C# Express Edition)
    Tuesday, April 3, 2012 1:49 AM

All replies