TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
nitish rai
NA
319
18.5k
how to select drop down box list in my data sheet
Jan 15 2018 5:50 AM
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="TagIndexdemo.aspx.cs" Inherits="TagIndexdemo" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<img src="logo_73492.gif" style="height: 63px; width: 267px; margin-top: 0px" />
</head>
<body>
<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<div>
<table>
<tr>
<td>
<asp:DropDownList ID="ddltagindex" runat="server" Width="119px">
<asp:ListItem>-------Select ----</asp:ListItem>
<asp:ListItem>TagIndex1</asp:ListItem>
<asp:ListItem>TagIndex2</asp:ListItem>
<asp:ListItem>TagIndex3</asp:ListItem>
<asp:ListItem>TagIndex4</asp:ListItem>
<asp:ListItem>TagIndex5</asp:ListItem>
<asp:ListItem>TagIndex6</asp:ListItem>
</asp:DropDownList>
</td>
<td>
<asp:Label ID="lblFromdate" runat="server" Text="FromDate"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtfromdate" runat="server"></asp:TextBox>
<asp:CalendarExtender ID="FromYearTxt_CalendarExtender" runat="server" Enabled="True"
TargetControlID="txtfromdate" Format="yyyy-MM-dd hh:mm:ss"></asp:CalendarExtender>
</td>
<td>
<asp:Label ID="lbltodate" runat="server" Text="ToDate"></asp:Label>
</td>
<td>
<asp:TextBox ID="txttodate" runat="server"></asp:TextBox>
<asp:CalendarExtender ID="CalendarExtender1" runat="server" Enabled="True"
TargetControlID="txttodate" Format="yyyy-MM-dd hh:mm:ss"></asp:CalendarExtender>
</td>
</tr>
</table>
<br />
<br />
<br />
<table>
<tr>
<td>
<asp:Button ID="Btnsubmit" runat="server" Text="Submit" Font-Bold="True" Font-Names="Times New Roman" OnClick="Btnsubmit_Click" />
</td>
</tr>
</table>
<canvas id="Chart" width="1000" height="700"></canvas>
</div>
</form>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/1.0.2/Chart.js"></script>
<script type="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
},
{
label: 'Voltage',
fillColor: "rgba(225,225,225,0.2)",
strokeColor: "orange",
pointColor: "Green",
pointStrokeColor: "Red",
pointHighlightFill: "",
pointHighlightStroke: "rgba(220,220,220,1)",
data: chartData2
}, {
label: 'Current',
fillColor: "rgba(225,225,225,0.2)",
strokeColor: "Cyan",
pointColor: "orangeS",
//pointStrokeColor: "Aqua",
pointHighlightFill: "",
pointHighlightStroke: "rgba(220,220,220,1)",
data: chartData3
}, {
label: 'frequency',
fillColor: "rgba(225,225,225,0.2)",
strokeColor: "Coral",
pointColor: "Black",
//pointStrokeColor: "black",
pointHighlightFill: "",
pointHighlightStroke: "rgba(220,220,220,1)",
data: chartData4
},
]
};
var skillsChart = new Chart(ctx).Line(barData);
}
});
}
);
</script>
</body>
</html>
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 = "ProCreateTagIndex ";
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)
{
}
}
Please check & revert on urgent basis.
Reply
Answers (
1
)
How can i do voice broadcasting in my window application?
How to store Username and password in app.config file in c#