Hi theunclevince,
Refer below sample code.
HTML
<asp:Chart ID="Chart1" runat="server" Height="300px" Width="600px">
<Titles>
<asp:Title ShadowOffset="3" Name="Items" />
</Titles>
<Series>
<asp:Series Name="Default" />
</Series>
<ChartAreas>
<asp:ChartArea Name="ChartArea1" BorderWidth="0" />
</ChartAreas>
</asp:Chart>
Namespaces
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web.UI.DataVisualization.Charting;
using System.Drawing;
Code
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
DataTable dt = new DataTable();
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
string sql = "SELECT ShipCity, count(OrderID) AS Total FROM Orders WHERE ShipCountry = 'Brazil' GROUP BY ShipCity";
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlDataAdapter sda = new SqlDataAdapter(sql, con))
{
sda.Fill(dt);
}
}
string[] x = new string[dt.Rows.Count];
int[] y = new int[dt.Rows.Count];
int index = 0;
foreach (DataRow row in dt.Rows)
{
x[index] = row["ShipCity"].ToString();
y[index] = Convert.ToInt32(row["Total"]);
index++;
}
Chart1.Series[0].Points.DataBindXY(x, y);
Chart1.Series[0].ChartType = SeriesChartType.Line;
Chart1.ChartAreas["ChartArea1"].Area3DStyle.Inclination = 0;
Chart1.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = false;
Chart1.ChartAreas["ChartArea1"].AxisX.LabelStyle.Angle = 0;
Chart1.ChartAreas["ChartArea1"].AxisX.IsLabelAutoFit = false;
Chart1.ChartAreas["ChartArea1"].AxisX.LabelStyle.Font = new Font("Arial", 9);
Chart1.ChartAreas["ChartArea1"].AxisX.LabelStyle.IsStaggered = false;
Chart1.ChartAreas["ChartArea1"].AxisX.LabelStyle.Enabled = true;
Chart1.ChartAreas["ChartArea1"].AxisY.LabelStyle.Format = "##,#";
Chart1.ChartAreas["ChartArea1"].AxisX.IsMarginVisible = true;
Chart1.ChartAreas["ChartArea1"].AxisY.LineColor = Color.FromArgb(0, 0, 205);
Chart1.ChartAreas["ChartArea1"].AxisX.LineColor = Color.FromArgb(0, 0, 205);
Chart1.ChartAreas["ChartArea1"].AxisX.LineDashStyle = ChartDashStyle.Solid;
Chart1.ChartAreas["ChartArea1"].AxisX.LineWidth = 2;
Chart1.ChartAreas["ChartArea1"].AxisY.LineWidth = 2;
Chart1.ChartAreas["ChartArea1"].AxisY.Minimum = 0;
Chart1.ChartAreas["ChartArea1"].AxisY.Maximum = 500;
Axis ay = Chart1.ChartAreas["ChartArea1"].AxisY;
ay.MajorGrid.Interval = 50;
Chart1.ChartAreas["ChartArea1"].AxisX.Title = "Days";
Chart1.ChartAreas["ChartArea1"].AxisY.Title = "Numbers";
Chart1.ChartAreas["ChartArea1"].AxisX.TitleFont = new Font("Microsoft Sans Serif", 14);
Chart1.ChartAreas["ChartArea1"].AxisY.TitleFont = new Font("Microsoft Sans Serif", 14);
Chart1.ChartAreas["ChartArea1"].AxisX.MajorGrid.Enabled = false;
Chart1.ChartAreas["ChartArea1"].AxisY.MajorGrid.Enabled = true;
Chart1.ChartAreas["ChartArea1"].BorderDashStyle = ChartDashStyle.Solid;
Chart1.ChartAreas["ChartArea1"].BorderWidth = 1;
Chart1.BorderSkin.SkinStyle = BorderSkinStyle.Emboss;
Chart1.BorderlineColor = Color.FromArgb(26, 59, 105);
Chart1.BorderlineWidth = 2;
Chart1.BackColor = Color.AliceBlue;
Chart1.AntiAliasing = AntiAliasingStyles.All;
Chart1.TextAntiAliasingQuality = TextAntiAliasingQuality.High;
}
}
Screenshot
