Chart DataBindTable Example

Text version of the video
http://csharp-video-tutorials.blogspot.com/2014/10/chartdatabindtable-example.html

Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help.
https://www.youtube.com/channel/UC7sEwIXM_YfAMyonQCrGfWA/?sub_confirmation=1

Slides
http://csharp-video-tutorials.blogspot.com/2014/10/chartdatabindtable-example_18.html

All ASP .NET Chart Control Text Articles and Slides
http://csharp-video-tutorials.blogspot.com/2014/10/aspnet-chart-control-tutorial.html

ASP.NET Charts Playlist
https://www.youtube.com/playlist?list=PL6n9fhu94yhXmzt5lcI1_BQNHdqQbkdLi

All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd

All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists

In Part 5 of this video series, we discussed binding data to the chart control using DataSource property. In this video we will discuss binding data to chart control using DataBindTable() method. We will continue with the example we worked with in Part 5, so please watch Part 5 before proceeding with this video.

Steps to use DataBindTable() method

Step 1 : When the DataBindTable() method is called, it automatically creates and adds a new series to the chart control. So, there is no need to specify the series in the HTML markup of the chart control. Delete the Series element from ChartControl.

[asp:Chart ID="Chart1" runat="server" Width="350px"]
[Titles]
[asp:Title Text="Total marks of students"]
[/asp:Title]
[/Titles]
[Series]
[/Series]
[ChartAreas]
[asp:ChartArea Name="ChartArea1"]
[AxisX Title="Student Name"]
[/AxisX]
[AxisY Title="Total Marks"]
[/AxisY]
[/asp:ChartArea]
[/ChartAreas]
[/asp:Chart]

Step 2 : Modify the code in the code-behind file as shown below. The code is commented and self explanatory.
using System;
using System.Configuration;
using System.Data.SqlClient;
using System.Web.UI.DataVisualization.Charting;
using System.Web.UI.WebControls;

namespace ChartsDemo
{
public partial class WebForm1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
GetChartData();
GetChartTypes();
}
}

private void GetChartData()
{
string cs = ConfigurationManager.ConnectionStrings["CS"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
// Query to retrieve the 2 columns (1 column for X-AXIS and the other for Y-AXIS)
// of data required for the chart control
SqlCommand cmd = new SqlCommand("Select StudentName, TotalMarks from Students", con);
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
// Pass the datareader object that contains the chart data and specify the column
// to be used for X-AXIS values. The other column values will be automatically
// used for Y-AXIS
Chart1.DataBindTable(rdr, "StudentName");
}
}

private void GetChartTypes()
{
foreach (int chartType in Enum.GetValues(typeof(SeriesChartType)))
{
ListItem li = new ListItem(Enum.GetName(typeof(SeriesChartType), chartType), chartType.ToString());
DropDownList1.Items.Add(li);
}
}

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
GetChartData();
// Retrieve the series by index and then set the ChartType property value
this.Chart1.Series[0].ChartType = (SeriesChartType)Enum.Parse(typeof(SeriesChartType), DropDownList1.SelectedValue);
// Alternatively, FirstOrDefault() linq method can also be used
// this.Chart1.Series.FirstOrDefault().ChartType = (SeriesChartType)Enum.Parse(typeof(SeriesChartType), DropDownList1.SelectedValue);
}
}
}