Dynamically generate pie chart in asp.net for students marks

thanks for all of your reply friends ,

finally i have done this task well with following codes ,

1.chart.aspx just like below

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="test.aspx.cs" Inherits="demo_Summa" %>

Test Series

Student Page

2.C# code like this

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Web.Services;

using System.Configuration;

using System.Data.SqlClient;

public partial class demo_Summa : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

SqlConnection con = Connection.DBConn();

string totalQuestions = "select COUNT(*) from tbl_testseries where subject='Chemistry' and status='A'";

SqlCommand cmdtotalQuestions = new SqlCommand(totalQuestions, con);

int counttotalQuestions = (Int32)cmdtotalQuestions.ExecuteScalar();

lblTotal.Text = "Total No of Questions = " + " " + " " + counttotalQuestions.ToString();

}

[WebMethod]

public static List GetData()

{

SqlConnection con = Connection.DBConn();

string Correct = string.Empty;

string Answer = string.Empty;

//Total No of questions

string totalQuestions = "select COUNT(*) from tbl_testseries where subject='Chemistry' and status='A'";

SqlCommand cmdtotalQuestions = new SqlCommand(totalQuestions, con);

int counttotalQuestions = (Int32)cmdtotalQuestions.ExecuteScalar();

// incorrect answer

string incorrect = "select COUNT(*) from tbl_tsAnswer where userid='101' and correct='0' and status='A'";

SqlCommand cmdincorrect = new SqlCommand(incorrect, con);

int incorrectCount = (Int32)cmdincorrect.ExecuteScalar();

//correct

string correct = "select COUNT(*) from tbl_tsAnswer where userid='101' and correct='1' and status='A'";

SqlCommand cmdcorrect = new SqlCommand(correct, con);

int correctCount = (Int32)cmdcorrect.ExecuteScalar();

//strAttendedCount

string strAttendedCount = "select COUNT(*) from tbl_tsAnswer where userid='101' and status='A'";

SqlCommand cmdAttendedCount = new SqlCommand(strAttendedCount, con);

int countAttended = (Int32)cmdAttendedCount.ExecuteScalar();

int NotAttended = counttotalQuestions - countAttended;

List dataList = new List();

dataList.Add(new Data("No of Questions Not Attended", NotAttended));

dataList.Add(new Data("", 0));

dataList.Add(new Data("Questions Answered Incorrectly", incorrectCount));

dataList.Add(new Data("Questions Answered Correctly", correctCount));

return dataList;

}

public class Data

{

public string ColumnName = "";

public int Value = 0;

public Data(string columnName, int value)

{

ColumnName = columnName;

Value = value;

}

thats all ,

Paul.S

man becomes what he thinks about

5 Replies

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

Raja T8y ago
Accepted answer
Hi Paul, Please follow below steps

1. you need required dataset/datatable from database.
2. there are more third party js exists in google for charts.
3. I have prepared to chartjs. please check more details about the chartjs...
https://www.sitepoint.com/introduction-chart-js-2-0-six-examples/
4. you can identify returns the data from database that results only showing in chart.
Raja T8y ago
Hi Paul, Most welcome Pauly... Happy coding :)
Paul Rajs8y ago
thanks for all of your reply friends ,

finally i have done this task well with following codes ,

1.chart.aspx just like below

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="test.aspx.cs" Inherits="demo_Summa" %>
Test Series

Student Page

2.C# code like this

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Web.Services;
using System.Configuration;
using System.Data.SqlClient;
public partial class demo_Summa : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = Connection.DBConn();
string totalQuestions = "select COUNT(*) from tbl_testseries where subject='Chemistry' and status='A'";
SqlCommand cmdtotalQuestions = new SqlCommand(totalQuestions, con);
int counttotalQuestions = (Int32)cmdtotalQuestions.ExecuteScalar();
lblTotal.Text = "Total No of Questions = " + " " + " " + counttotalQuestions.ToString();
}
[WebMethod]
public static List GetData()
{
SqlConnection con = Connection.DBConn();
string Correct = string.Empty;
string Answer = string.Empty;
//Total No of questions
string totalQuestions = "select COUNT(*) from tbl_testseries where subject='Chemistry' and status='A'";
SqlCommand cmdtotalQuestions = new SqlCommand(totalQuestions, con);
int counttotalQuestions = (Int32)cmdtotalQuestions.ExecuteScalar();
// incorrect answer
string incorrect = "select COUNT(*) from tbl_tsAnswer where userid='101' and correct='0' and status='A'";
SqlCommand cmdincorrect = new SqlCommand(incorrect, con);
int incorrectCount = (Int32)cmdincorrect.ExecuteScalar();
//correct
string correct = "select COUNT(*) from tbl_tsAnswer where userid='101' and correct='1' and status='A'";
SqlCommand cmdcorrect = new SqlCommand(correct, con);
int correctCount = (Int32)cmdcorrect.ExecuteScalar();
//strAttendedCount
string strAttendedCount = "select COUNT(*) from tbl_tsAnswer where userid='101' and status='A'";
SqlCommand cmdAttendedCount = new SqlCommand(strAttendedCount, con);
int countAttended = (Int32)cmdAttendedCount.ExecuteScalar();
int NotAttended = counttotalQuestions - countAttended;
List dataList = new List();
dataList.Add(new Data("No of Questions Not Attended", NotAttended));
dataList.Add(new Data("", 0));
dataList.Add(new Data("Questions Answered Incorrectly", incorrectCount));
dataList.Add(new Data("Questions Answered Correctly", correctCount));
return dataList;
}
}
public class Data
{
public string ColumnName = "";
public int Value = 0;
public Data(string columnName, int value)
{
ColumnName = columnName;
Value = value;
}
}

thats all ,

Paul.S
man becomes what he thinks about
Raja T8y ago
how to you get the data from database using web method /web api..

if you can use easy web method /web api get data and bind the data in AJAX. Because im recently working on that using Chart JS library...
Paul Rajs8y ago
thanks raj , you are right , but i want to bind the records from database

will you suggest me anyother option