Here I will explain how to create dynamic Ajax pie chart in asp.net with database using c#, vb.net or create pie chart in asp.net with database example in c#, vb.net.
First design table one table countrydetails in your database like as
shown below
Data Type
|
Allow Nulls
|
|
ID
|
Int(set
identity property=true)
|
No
|
name
|
Varchar(50)
|
no
|
value
|
Int
|
no
|
Once we create table we need to enter some dummy
data for our application purpose.
To implement Ajax pie chart with
database first we need to add AjaxControlToolkit to your bin folder and
design your aspx page like this
<%@ Register TagPrefix="ajaxToolkit"
Assembly="AjaxControlToolkit"
Namespace="AjaxControlToolkit"
%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>Pie Chart Example with
Database in asp.net</title>
</head>
<body>
<form id="form1"
runat="server">
<div style="width:40%">
<ajaxToolkit:ToolkitScriptManager ID="scriptmanager1"
runat="server"
/>
<ajaxToolkit:PieChart ID="countrychart"
runat="server"
ChartHeight="300"
ChartWidth="450" ChartTitle="World
wide Data usage %" ChartTitleColor="#0E426C">
</ajaxToolkit:PieChart>
</div>
</form>
</body>
</html>
|
C# Code
In code
behind add the following namespaces
using System;
using System.Data;
using System.Data.SqlClient;
|
After
adding namespaces and write the following code in page load
protected void Page_Load(object
sender, EventArgs e)
{
DataTable dt = new DataTable();
using (SqlConnection con = new
SqlConnection("Data
Source=SureshDasari;Integrated Security=true;Initial Catalog=MySampleDB"))
{
con.Open();
SqlCommand cmd = new SqlCommand("select name,total=value from countrydetails order
by total desc", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
con.Close();
}
foreach(DataRow dr in
dt.Rows)
{
countrychart.PieChartValues.Add(new
AjaxControlToolkit.PieChartValue
{
Category = dr["name"].ToString(),
Data = Convert.ToDecimal(dr["total"]),
});
}
}
|
VB.NET Code
Imports System.Data
Imports System.Data.SqlClient
Partial Class VBCode
Inherits System.Web.UI.Page
Protected Sub Page_Load(sender As
Object, e As EventArgs) Handles
Me.Load
Dim dt As New DataTable()
Using con As New SqlConnection("Data
Source=SureshDasari;Integrated Security=true;Initial Catalog=MySampleDB")
con.Open()
Dim cmd As New SqlCommand("select
name,total=value from countrydetails order by total desc", con)
Dim da As New SqlDataAdapter(cmd)
da.Fill(dt)
con.Close()
End Using
For Each dr As DataRow In
dt.Rows
countrychart.PieChartValues.Add(New
AjaxControlToolkit.PieChartValue() With { _
.Category = dr("name").ToString(),
_
.Data = Convert.ToDecimal(dr("total")) _
})
Next
End Sub
End Class
0 comments:
Post a Comment