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: