ASP.NET Chart usage with LINQ

table

1, user :  ID username password

2, userdata: ID UID datetime HR BR

ASPX

<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeBehind="Diagram.aspx.cs" Inherits="WebRole1.Diagram" %>
<asp:Content ID="Content1" ContentPlaceHolderID="Head" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="Content" runat="server">
<h1>Diagram</h1>
    <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="true" 
        onselectedindexchanged="DropDownList1_SelectedIndexChanged">
        <asp:ListItem Value="0">Please Select one Item</asp:ListItem>
        <asp:ListItem Value="HR">HR</asp:ListItem>
        <asp:ListItem Value="BR">BR</asp:ListItem>
    </asp:DropDownList>

    <asp:Chart ID="Chart1" runat="server">
        <Series>
            <asp:Series Name="Series1" ChartType="Spline">
            </asp:Series>
        </Series>
        <ChartAreas>
            <asp:ChartArea Name="ChartArea1">
            </asp:ChartArea>
        </ChartAreas>
    </asp:Chart>


  

<br />
<br />
<br />
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="Footer" runat="server">
</asp:Content>
<asp:Content ID="Content4" ContentPlaceHolderID="AfterBody" runat="server">
</asp:Content>

ASPX.CS 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace WebRole1
{
    public partial class Diagram : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Session["HealthCareLogin"] == "" || Session["HealthCareLogin"] == null)
            {

                Response.Redirect("LoginPage.aspx");
            }
        }

        protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
        {
            using (var dc = new DCHealthCaresDataContext())
            {
                var CurrentUserID = dc.Users.Where(c=>c.Username == Session["HealthCareLogin"]).Select(c=>c.UID).SingleOrDefault();

                if (DropDownList1.SelectedValue == "HR")
                {
                    var HRSource = from o in dc.UsersDates
                                   where o.UID == CurrentUserID
                                   select new { HR = o.HR };

                    foreach (var o in HRSource)
                    {
                        Chart1.Series["Series1"].Points.AddY(o.HR);
                    }


                }
                else if (DropDownList1.SelectedValue == "BR")
                {
                    var BRSource = from o in dc.UsersDates
                                   where o.UID == CurrentUserID
                                   select new { BR = o.BR };

                    foreach (var o in BRSource)
                    {
                        Chart1.Series["Series1"].Points.AddY(o.BR);
                    }
                }
            
            }
        }

        
        }
    }

OUTPUT: