I am creating the Bar chart where in X-axis I am assigning "MeterNumber" which is of type String. But in my line chart it displays 0 where
the Meter Number is string.
I am attaching the screenshots, in legend you can see for MeterNumber Meter555, Meter556 , in the x-axis it is displaying 0.
Below is the code:
<telerik:RadChart ID="RadChart1" runat="server" Width="710px" OnItemDataBound="RadChart1_ItemDataBound">
<Series>
<telerik:ChartSeries Type="Bar">
<Appearance LegendDisplayMode="ItemLabels">
</Appearance>
</telerik:ChartSeries>
</Series>
<Legend>
<Appearance GroupNameFormat="#VALUE" >
</Appearance>
</Legend>
<ChartTitle>
<TextBlock Text="Energy consumption">
</TextBlock>
</ChartTitle>
</telerik:RadChart>
Code behind:
public partial class BarChart_Sample : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
List<RT_prcGetReadingBasedOnMeterType_POCResult> readingList = new Model().GetReadingBasedOnMeterType(null);
RadChart1.DataSource = readingList;
RadChart1.Series[0].DataYColumn = "MeterReading";
RadChart1.PlotArea.XAxis.DataLabelsColumn = "MeterNumber";
RadChart1.PlotArea.XAxis.Appearance.TextAppearance.TextProperties.Font
= new System.Drawing.Font("Ariel", 8);
RadChart1.DataBind();
}
public void RadChart1_ItemDataBound(object sender, Telerik.Charting.ChartItemDataBoundEventArgs e)
{
e.SeriesItem.Name = ((DataRowView)e.DataItem)["MeterNumber"].ToString();
}
}
The Procedure are:
public List<RT_prcGetReadingBasedOnMeterType_POCResult> GetReadingBasedOnMeterType(string meterType)
{
try
{
List<RT_prcGetReadingBasedOnMeterType_POCResult> list = DBContext.RT_prcGetReadingBasedOnMeterType_POC(meterType).ToList();
return list;
}
catch (Exception ex)
{
throw ex;
}
}