Wednesday 28 June 2017

Dynamic Chart binding in asp.net using enitity Framework

<system.webServer>
    <validation validateIntegratedModeConfiguration="false" />
    <handlers>
      <!--<remove name="ChartImageHandler" />-->
      <add name="ChartImageHandler" preCondition="integratedMode" verb="GET,HEAD,POST" path="ChartImg.axd" type="System.Web.UI.DataVisualization.Charting.ChartHttpHandler, System.Web.DataVisualization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />

    </handlers>
  </system.webServer>


using Online_test.Models;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace Online_test
{
    public partial class demo : System.Web.UI.Page
    {
        Database1Entities db = new Database1Entities();
        Tbl_option qt = new Tbl_option();
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                Getchartdata();
            }
        }

        protected void Getchartdata()
        {
            var ab = (from a in db.Tbl_option.ToList()
                      select new
                          {
                              name = a.ans,
                              repeattype = a.ansId
                          }).ToList();
            foreach (var a in ab.ToList())
            {
                Chart1.Series["Series1"].Points.AddXY(Convert.ToString(a.name), Convert.ToInt32(a.repeattype));
            }
        }
    }
}



<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="demo.aspx.cs" Inherits="Online_test.demo" %>

<%@ Register Assembly="System.Web.DataVisualization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" Namespace="System.Web.UI.DataVisualization.Charting" TagPrefix="asp" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">

    <title></title>
</head>
<body>
    <form id="form1" runat="server">
        <asp:ScriptManager runat="server"></asp:ScriptManager>
        <asp:Chart ID="Chart1" runat="server">
            <Series>
                <asp:Series Name="Series1" ChartArea="ChartArea1" ChartType="Pie" YValuesPerPoint="2">
                </asp:Series>
            </Series>
            <ChartAreas>
                <asp:ChartArea Name="ChartArea1">
                    <AxisX Title="name"></AxisX>
                    <AxisY Title="repeattype"></AxisY>
                </asp:ChartArea>
            </ChartAreas>
        </asp:Chart>

    </form>
</body>
</html>

No comments:

Post a Comment