drop down select list Items after plotting the line graph

Please help on subject mail.

Plesae find the below code.

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="TagIndexdemo.aspx.cs" Inherits="TagIndexdemo" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
"http://www.w3.org/1999/xhtml">
"server">
"logo_73492.gif" style="height: 63px; width: 267px; margin-top: 0px" />
"form1" runat="server">
"ScriptManager1" runat="server">

"ddltagindex" runat="server" Width="119px" >

-------Select ----

TagIndex1

TagIndex2

TagIndex3

TagIndex4

TagIndex5

TagIndex6

"lblFromdate" runat="server" Text="FromDate">

"txtfromdate" runat="server">

"FromYearTxt_CalendarExtender" runat="server" Enabled="True"

TargetControlID="txtfromdate" Format="yyyy-MM-dd hh:mm:ss">

"lbltodate" runat="server" Text="ToDate">

"txttodate" runat="server">

"CalendarExtender1" runat="server" Enabled="True"

TargetControlID="txttodate" Format="yyyy-MM-dd hh:mm:ss">

"Btnsubmit" runat="server" Text="Submit" Font-Bold="True" Font-Names="Times New Roman" OnClick="Btnsubmit_Click" />
"Chart" width="1000" height="700">

"https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js">

"https://cdnjs.cloudflare.com/ajax/libs/Chart.js/1.0.2/Chart.js">

"text/javascript">

$(function () {

var ctx = document.getElementById("Chart").getContext('2d');

$.ajax({

url: "TagIndexdemo.aspx/getChartData",

type: "POST",

contentType: "application/json; charset=utf-8",

dataType: "json",

success: function (response) {

var chartLabel = eval(response.d[0]); //Labels

var chartData = eval(response.d[1]); //Data

var chartData1 = eval(response.d[2]); //Data

var chartData2 = eval(response.d[3]); //Data

var chartData3 = eval(response.d[4]); //Data

var chartData4 = eval(response.d[5]); //Data

var barData = {

labels: chartLabel,

datasets: [

{

fillColor: "rgba(255, 0, 0, 0.0)",//"rgba(220,220,220,0.2)",

strokeColor: "red",//"rgba(220,220,220,1)",

pointColor: "red",//"rgba(220,220,220,1)",

pointStrokeColor: "#fff",

pointHighlightFill: "#fff",

pointHighlightStroke: "rgba(220,220,220,1)",

data: chartData

{

label: 'PowerFactor',

fillColor: "rgba(225,225,225,0.2)",

strokeColor: "Crimson",

pointColor: "blue",

pointStrokeColor: "HotPink",

pointHighlightFill: "",

pointHighlightStroke: "rgba(220,220,220,1)",

data: chartData1

}, {

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.Data.SqlClient;
using System.Text;
using System.Configuration;
using System.IO;
using System.Web.Services;
public partial class TagIndexdemo : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
[WebMethod]
public static List<string> getChartData()
{
var returnData = new List<string>();
var Con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["demoConnectionString2"].ConnectionString);
Con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "ProCreateTagIndex1 ";
//cmd.Parameters.AddWithValue("@FromDate", FromDate);
//cmd.Parameters.AddWithValue("@ToDate", ToDate);
cmd.Connection = Con;
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
try
{
adapter.Fill(ds);
}
catch (Exception ex)
{
throw ex;
}
finally
{
Con.Close();
Con.Dispose();
}
var chartLabel = new StringBuilder();
var chartData = new StringBuilder();
var chartData1 = new StringBuilder();
var chartData2 = new StringBuilder();
var chartData3 = new StringBuilder();
var chartData4 = new StringBuilder();
chartLabel.Append("[");
chartData.Append("[");
chartData1.Append("[");
chartData2.Append("[");
chartData3.Append("[");
chartData4.Append("[");
foreach (DataRow row in ds.Tables[0].Rows)
{
chartLabel.Append(string.Format("'{0}',", row["DateAndTime"].ToString()));
chartData.Append(string.Format("'{0}',", row["TagIndex1"].ToString()));
chartData1.Append(string.Format("'{0}',", row["TagIndex2"].ToString()));
chartData2.Append(string.Format("'{0}',", row["TagIndex3"].ToString()));
chartData3.Append(string.Format(" '{0}',", row["TagIndex4"].ToString()));
chartData4.Append(string.Format("' {0}',", row["TagIndex5"].ToString()));
}
chartData.Length--; //For removing ','
chartData.Append("]");
chartData1.Length--; //For removing ','
chartData1.Append("]");
chartData2.Length--; //For removing ','
chartData2.Append("]");
chartData3.Length--; //For removing ','
chartData3.Append("]");
chartData4.Length--; //For removing ','
chartData4.Append("]");
chartLabel.Length--; //For removing ','
chartLabel.Append("]");
returnData.Add(chartLabel.ToString());
returnData.Add(chartData.ToString());
returnData.Add(chartData1.ToString());
returnData.Add(chartData2.ToString());
returnData.Add(chartData3.ToString());
returnData.Add(chartData4.ToString());
return returnData;
}
protected void Btnsubmit_Click(object sender, EventArgs e)
{
txtfromdate.Text = "";
txttodate.Text = "";
}
}