Hello,
I am novice programmer in c# field. I am trying to implement a search
function in to filter my google charts. I am unable to figure out, how do
I go about doing this functionality, any help or example, would be very
much appreciated.
I would like the search criteria to filter chart data by name.
aspx.
<%@ Page Title="Home Page" Language="C#" MasterPageFile="~/Site.master"
AutoEventWireup="true"
CodeFile="Default.aspx.cs" Inherits="_Default" %>
<asp:Content ID="HeaderContent" runat="server"
ContentPlaceHolderID="HeadContent">
<script type="text/javascript"
src="https://www.google.com/jsapi></script></asp:Content><asp:Content
ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
<h2>
Visual Search Testing with 'iFrame
</h2>
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.8.0/jquery.min.js"
type="text/javascript"></script>
<script type="text/javascript" src="//www.google.com/jsapi"></script>
<script type="text/javascript">
google.load('visualization', '1', { packages: ['corechart'] });
</script>
<script type="text/javascript">
$(document).ready(function ()
$('#btnSearch').click(function() {
$.ajax({
type: 'POST',
dataType: 'json',
contentType: 'application/json',
url: 'Default.aspx/GetData',
data: '{}',
success:
function (response) {
drawVisualization(response.d);
}
});
})
function drawVisualization(dataValues) {
var data = new google.visualization.DataTable();
data.addColumn('string', 'Column Date');
data.addColumn('number', 'Column Value');
for (var i = 0; i < dataValues.length; i++) {
data.addRow([dataValues[i].Date, dataValues[i].Value]);
}
new
google.visualization.LineChart(document.getElementById('visualization')).
draw(data, { title: "" });
}
</script>
<asp:Label ID="Label1" runat="server" Text="Name/Ids"></asp:Label>
<asp:TextBox ID="btnSearch" runat="server" ></asp:TextBox>
<div id="visualization" style="width: 600px; height: 400px;"></div>
</asp:Content>
c#
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Data.SqlClient;
using System.Text;
using System.Collections.Generic;
using System.Web.Services;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
[WebMethod]
public static List<Data> GetData()
{
List<Data> dataList = new List<Data>();
dataList.Add(new Data("CLAVS 2007-1 M2A", 77, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 0, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 78, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 82, "Oct"));
dataList.Add(new Data("CLAVS 2007-1 M2A", 425, "Oct"));
return dataList;
}
}
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/groups/opt_out.
