How to display values inside pie chart using xaml

Hi Satyabrata Rout,

Try this,

[WebMethod]
publicstaticListGetData()
{
SqlConnectionconn=newSqlConnection("DataSource=10.0.0.101;uid=sa;pwd=sql;database=QuestionDB;");
DataSetds=newDataSet();
DataTabledt=newDataTable();
conn.Open();
stringcmdstr="selecttop5First_name,COUNT(A.Dept_Id)as[Department]fromEmployeeAgroupbyFirst_name";
SqlCommandcmd=newSqlCommand(cmdstr,conn);
SqlDataAdapteradp=newSqlDataAdapter(cmd);
adp.Fill(ds);
dt=ds.Tables[0];
ListdataList=newList();
stringcat="";
intval=0;
foreach(DataRowdrindt.Rows)
{
cat=dr[0].ToString();
val=Convert.ToInt32(dr[1]);
dataList.Add(newData(cat,val));
}
returndataList;
}

<htmlxmlns="http://www.w3.org/1999/xhtml">
<headrunat="server">
<title>title>
<scriptsrc="//ajax.googleapis.com/ajax/libs/jquery/1.8.0/jquery.min.js"type="text/javascript">script>
<scripttype="text/javascript"src="//www.google.com/jsapi">script>
<scripttype="text/javascript">
google.load('visualization','1',{packages:['corechart']});
script>
<scripttype="text/javascript">
$(document).ready(function(){
$.ajax({
type:'POST',
dataType:'json',
contentType:'application/json',
url:'Default.aspx/GetData',
data:'{}',
success:
function(response){
drawVisualization(response.d);
}
});
})
functiondrawVisualization(dataValues){
vardata=newgoogle.visualization.DataTable();
data.addColumn('string','ColumnName');
data.addColumn('number','ColumnValue');
for(vari=0;i<dataValues.length;i++){
data.addRow([dataValues[i].ColumnName,dataValues[i].Value]);
}
newgoogle.visualization.PieChart(document.getElementById('visualization')).
draw(data,{title:"GoogleChartdemo"});
}
script>
head>
<body>
<formid="form1"runat="server">
<divid="visualization"style="width:600px;height:350px;">div>
<div><asp:ButtonID="btnExport"runat="server"Text="Export"OnClick="btnExport_Click"/>div>
form>
body>
html>

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abhilash J A10y ago
Accepted answer
Hi Satyabrata Rout,
Try this,
[WebMethod]
publicstaticListGetData()
{
SqlConnectionconn=newSqlConnection("DataSource=10.0.0.101;uid=sa;pwd=sql;database=QuestionDB;");
DataSetds=newDataSet();
DataTabledt=newDataTable();
conn.Open();
stringcmdstr="selecttop5First_name,COUNT(A.Dept_Id)as[Department]fromEmployeeAgroupbyFirst_name";
SqlCommandcmd=newSqlCommand(cmdstr,conn);
SqlDataAdapteradp=newSqlDataAdapter(cmd);
adp.Fill(ds);
dt=ds.Tables[0];
ListdataList=newList();
stringcat="";
intval=0;
foreach(DataRowdrindt.Rows)
{
cat=dr[0].ToString();
val=Convert.ToInt32(dr[1]);
dataList.Add(newData(cat,val));
}
returndataList;
}
<htmlxmlns="http://www.w3.org/1999/xhtml">
<headrunat="server">
<title>title>
<scriptsrc="//ajax.googleapis.com/ajax/libs/jquery/1.8.0/jquery.min.js"type="text/javascript">script>
<scripttype="text/javascript"src="//www.google.com/jsapi">script>
<scripttype="text/javascript">
google.load('visualization','1',{packages:['corechart']});
script>
<scripttype="text/javascript">
$(document).ready(function(){
$.ajax({
type:'POST',
dataType:'json',
contentType:'application/json',
url:'Default.aspx/GetData',
data:'{}',
success:
function(response){
drawVisualization(response.d);
}
});
})
functiondrawVisualization(dataValues){
vardata=newgoogle.visualization.DataTable();
data.addColumn('string','ColumnName');
data.addColumn('number','ColumnValue');
for(vari=0;i<dataValues.length;i++){
data.addRow([dataValues[i].ColumnName,dataValues[i].Value]);
}
newgoogle.visualization.PieChart(document.getElementById('visualization')).
draw(data,{title:"GoogleChartdemo"});
}
script>
head>
<body>
<formid="form1"runat="server">
<divid="visualization"style="width:600px;height:350px;">div>
<div><asp:ButtonID="btnExport"runat="server"Text="Export"OnClick="btnExport_Click"/>div>
form>
body>
html>
Satyabrata Rout10y ago
Hi Abhilash ,
Thanx for your suggestion but i am using xaml.
IndependentValuePath="Key"
ItemsSource="{Binding}">
Can you suggest me any thing