Comments by Rams@music (Top 26 by date)

this is my cs code
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.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Text;

public partial class dashboard : System.Web.UI.Page
{
StringBuilder str = new StringBuilder();

//Get connection string from web.config

string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;

protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack == false)
{

BindChart();

}


}
private DataTable GetData()
{

DataTable dt = new DataTable();

string cmd = "select YEAR,sales from area_chart";

SqlDataAdapter adp = new SqlDataAdapter(cmd, constr);

adp.Fill(dt);

return dt;

}
private void BindChart()
{

DataTable dt = new DataTable();

try
{

dt = GetData();

str.Append(@" <script type='text/javascript'>

google.load('visualization', '1.0', {'packages':['controls']});




google.setOnLoadCallback(dashboardd);

function dashboardd() {

var data = google.visualization.arrayToDataTable([

['YEAR','sales',],");



int count = dt.Rows.Count - 1;

for (int i = 0; i <= count; i++)
{


if (i == count)
{

str.Append("['" + dt.Rows[i]["YEAR"].ToString() + "', " + dt.Rows[i]["sales"].ToString() + "]]);}");

}
else
{
str.Append("['" + dt.Rows[i]["YEAR"].ToString() + "', " + dt.Rows[i]["sales"].ToString() + "],");

}


}
// Create a dashboard.


str.Append("var dashboard = new google.visualization.Dashboard( document.getElementById('dashboard_div'));");

// Create a range slider, passing some options

str.Append(" var donutRangeSlider = new google.visualization.ControlWrapper({'controlType': 'NumberRangeFilter', 'containerId': 'filter_div','options': { 'filterColumnLabel': 'sales' }});");

// Create a pie chart, passing some options
str.Append("var pieChart = new google.visualization.ChartWrapper({'chartType': 'PieChart','containerId': 'chart_div','options': {'width': 300, 'height': 300,'pieSliceText': 'value','legend': 'right'}});");


// Establish dependencies, declaring that 'filter' drives 'pieChart',
// so that the pie chart will only display entries that are let through
// given the chosen slider range.
str.Append(" dashboard.bind(donutRangeSlider, pieChart);");

// Draw the dashboard.
str.Append("dashboard.draw(data);");



//str.Append("var options = { title:'year And Expance',hAxis: {title: 'Year', titleTextStyle: {color: '#333'}},};var chart = new google.visualization.AreaChart(document.getElementById('chart_div'));");

//str.Append("chart.draw(data, options);};");


str.Append("</script>");


lt.Text = str.ToString();

}

catch
{

}

}

}

is there any other chart controles to work in offline and performence like google charts.

i do this one allready. it gives error

GO
/****** Object: Table [dbo].[area_chart] Script Date: 10/08/2015 16:08:57 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[area_chart](
[year] [int] NULL,
[sales] [int] NULL,
[expance] [int] NULL
) ON [PRIMARY]

GO
This Is My Data

Year Sales expance
2010 100000 50000
2012 500000 700000
2014 5000000 4000000
2016 150000 100000

ya i give data by table.
this is my query: select YEAR,sales from area_chart

and i provide this one into datatable function Like This
Code In C#:-
function drawRegionsMap() {

var data = google.visualization.arrayToDataTable([

['YEAR','sales'],");



int count = dt.Rows.Count - 1;

for (int i = 0; i <= count; i++)
{

str.Append("['" + dt.Rows[i]["YEAR"].ToString() + "', " + dt.Rows[i]["sales"].ToString() + "],");

if (i == count)
{

str.Append("['" + dt.Rows[i]["YEAR"].ToString() + "', " + dt.Rows[i]["sales"].ToString() + "]]);}");

}


}
when i give like this it through the run time error

if i give hardcoded values of year, sales it gives the o/p. when i give the values from datatable as backend error coming what can i do

hithank u.
copy this sourse and give in my aspx. and it give me output.
but in C# it gives error. plese check my C# code.
and tell me is there any changes to do.

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.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Text;

public partial class dashboard : System.Web.UI.Page
{
StringBuilder str = new StringBuilder();

//Get connection string from web.config

string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;

protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack == false)
{

BindChart();

}


}
private DataTable GetData()
{

DataTable dt = new DataTable();

string cmd = "select YEAR,sales from area_chart";

SqlDataAdapter adp = new SqlDataAdapter(cmd, constr);

adp.Fill(dt);

return dt;

}
private void BindChart()
{

DataTable dt = new DataTable();

try
{

dt = GetData();

str.Append(@" <script type='text/javascript'>

google.load('visualization', '1.0', {'packages':['controls']});




google.setOnLoadCallback(dashboardd);

function dashboardd() {

var data = google.visualization.arrayToDataTable([

['YEAR','sales'],");



int count = dt.Rows.Count - 1;

for (int i = 0; i <= count; i++)
{


if (i == count)
{

str.Append("['" + dt.Rows[i]["YEAR"].ToString() + "', " + dt.Rows[i]["sales"].ToString() + "]]);}");

}
else
{
str.Append("['" + dt.Rows[i]["YEAR"].ToString() + "', " + dt.Rows[i]["sales"].ToString() + "],");

}


}
// Create a dashboard.


str.Append("var dashboard = new google.visualization.Dashboard( document.getElementById('dashboard_div'));");

// Create a range slider, passing some options

str.Append(" var donutRangeSlider = new google.visualization.ControlWrapper({'controlType': 'NumberRangeFilter', 'containerId': 'filter_div','options': { 'filterColumnLabel': 'sales' }});");

// Create a pie chart, passing some options
str.Append("var pieChart = new google.visualization.ChartWrapper({'chartType': 'PieChart','containerId': 'chart_div','options': {'width': 300, 'height': 300,'pieSliceText': 'value','legend': 'right'}});");


// Establish dependencies, declaring that 'filter' drives 'pieChart',
// so that the pie chart will only display entries that are let through
// given the chosen slider range.
str.Append(" dashboard.bind(donutRangeSlider, pieChart);");

// Draw the dashboard.
str.Append("dashboard.draw(data);");



//str.Append("var options = { title:'year And Expance',hAxis: {title: 'Year', titleTextStyle: {color: '#333'}},};var chart = new google.visualization.AreaChart(document.getElementById('chart_div'));");

//str.Append("chart.draw(data, options);};");


str.Append("</script>");


lt.Text = str.ToString();

}

catch
{

}

}

}
thank you.
you are good u help me alot

thank you.
these two are same i got this only.
it does show any o/p.
it give javascript runtime error
dashboard is null.

this is my source as you said.


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head><title>

</title>
<script type="text/javascript" src="https://www.google.com/jsapi"></script>




</head>
<body>
<form name="form1" method="post" action="dashboard.aspx" id="form1">
<div>
<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwUIOTEyNDUzNDYPZBYCAgMPZBYCAgEPFgIeBFRleHQF8QcgPHNjcmlwdCB0eXBlPSd0ZXh0L2phdmFzY3JpcHQnPg0KDQogICAgICAgICAgICAgICAgICAgICAgICAgZ29vZ2xlLmxvYWQoJ3Zpc3VhbGl6YXRpb24nLCAnMS4wJywgeydwYWNrYWdlcyc6Wydjb250cm9scyddfSk7DQoNCiAgICAgICAgICAgICAgICAgIA0KDQoNCiAgICAgICAgICAgICAgICAgICAgICAgICBnb29nbGUuc2V0T25Mb2FkQ2FsbGJhY2soZGFzaGJvYXJkZCk7DQoNCiAgICAgICAgICAgICAgICAgICAgICAgICAgZnVuY3Rpb24gZGFzaGJvYXJkZCgpIHsNCg0KICAgICAgICAgICAgICAgICAgICAgICAgICAgIHZhciBkYXRhID0gZ29vZ2xlLnZpc3VhbGl6YXRpb24uYXJyYXlUb0RhdGFUYWJsZShbDQoNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFsnWUVBUicsJ3NhbGVzJ10sWycyMDEwJywgIDEwMDAwMF0sWycyMDEyJywgIDUwMDAwMF0sWycyMDE0JywgIDUwMDAwMDBdLFsnMjAxNicsICAxNTAwMDBdXSk7fXZhciBkYXNoYm9hcmQgPSBuZXcgZ29vZ2xlLnZpc3VhbGl6YXRpb24uRGFzaGJvYXJkKCBkb2N1bWVudC5nZXRFbGVtZW50QnlJZCgnZGFzaGJvYXJkX2RpdicpKTsgdmFyIGRvbnV0UmFuZ2VTbGlkZXIgPSBuZXcgZ29vZ2xlLnZpc3VhbGl6YXRpb24uQ29udHJvbFdyYXBwZXIoeydjb250cm9sVHlwZSc6ICdOdW1iZXJSYW5nZUZpbHRlcicsICdjb250YWluZXJJZCc6ICdmaWx0ZXJfZGl2Jywnb3B0aW9ucyc6IHsgJ2ZpbHRlckNvbHVtbkxhYmVsJzogJ3NhbGVzJyB9fSk7dmFyIHBpZUNoYXJ0ID0gbmV3IGdvb2dsZS52aXN1YWxpemF0aW9uLkNoYXJ0V3JhcHBlcih7J2NoYXJ0VHlwZSc6ICdQaWVDaGFydCcsJ2NvbnRhaW5lcklkJzogJ2NoYXJ0X2RpdicsJ29wdGlvbnMnOiB7J3dpZHRoJzogMzAwLCAnaGVpZ2h0JzogMzAwLCdwaWVTbGljZVRleHQnOiAndmFsdWUnLCdsZWdlbmQnOiAncmlnaHQnfX0pOyBkYXNoYm9hcmQuYmluZChkb251dFJhbmdlU2xpZGVyLCBwaWVDaGFydCk7ZGFzaGJvYXJkLmRyYXcoZGF0YSk7PC9zY3JpcHQ+ZGR8xnemBsi93hinamaHe0yPCW974Q==" />
</div>

<div>



<script type='text/javascript'>

google.load('visualization', '1.0', {'packages':['controls']});




google.setOnLoadCallback(dashboardd);

function dashboardd() {

var data = google.visualization.arrayToDataTable([

['YEAR','sales'],['2010', 100000],['2012', 500000],['2014', 5000000],['2016', 150000]]);}var dashboard = new google.visualization.Dashboard( document.getElementById('dashboard_div')); var donutRangeSlider = new google.visualization.ControlWrapper({'controlType': 'NumberRangeFilter', 'containerId': 'filter_div','options': { 'filterColumnLabel': 'sales' }});var pieChart = new google.visualization.ChartWrapper({'chartType': 'PieChart','containerId': 'chart_div','options': {'width': 300, 'height': 300,'pieSliceText': 'value','legend': 'right'}}); dashboard.bind(donutRangeSlider, pieChart);dashboard.draw(data);</script>
<div>

<div id="dashboard_div">


<div id="filter_div"></div>
<div id="chart_div"></div>
</div>

</div>
</div>
</form>
</body>
</html>

thank you i put sales.
but showing error as same dashboard is null.
iam trying this from backend(C#).
when iam trying with Aspx there is no problem. i got o/p with google code

hi thank you. it is working when i give in aspx directly. but trying with c# its getting error.
i want it from back end

the error is occured these 3 Lines
1)google.visualization.Dashboard(document.getElementById('dashboard_div'));");
2)var yearslider = new google.visualization.ControlWrapper({ 'controlType': 'NumberRangeFilter', 'containerId': 'filter_div',
'options': { 'filterColumnLabel': 'YEAR' }});");
3)var pieChart = new google.visualization.ChartWrapper({'chartType': 'PieChart','containerId': 'chart_div', 'options': { 'width': 300,'height': 300,'pieSliceText': 'value', 'legend': 'right' } });");

error is occured at these 3 Lines

hi.
thank you for reply
can u edit my code please.
iam new to .net. idnt know how to use web methods

where i get .js file for visuvlization.
help me.
Thank you.

how to do that?
i dont understand. help me

thank u

thank u

hi thanks for reply i dnt know much more about jquery iam new to jquery and this type of menus. but i will try to some example from google but they are not work. please can u explain me breafly regarding to this.
thank you

hi thanks for reply i try this but in this i dont get submenus..

i got menus. with this i dont have any problem. actuvally i want menus in coloumn wise

ex:-when i put cursor on about us. what ever the submenus releted to aboutus are comes in coloumn wise like this

aboutus
|
|
AboutOrganigetion ourclient
Location Contactus


like this i want submenus in column wise

i got menus and sub menus from database but my requirement is all the sub menus are comes in 2 or more coloumns but in menu controle these are comes in vertical or horizontal.
is there any way to do like this web site menu http://www.yvr.ca/en/Default. menus from sqlserver