Open it in chrome and see what the error console says (ctrl+shift+j to
open).
On Monday, March 4, 2013 6:04:12 AM UTC-5, Matevz Uros Pavlic wrote:
>
> Hi all,
>
> I've created a site where I get the data from SQL server and draw a
> chart. Now everything works perfectly on my local machine (localhost), but
> when I deploy it on the server, the chart don't show. Here's the code i use
> :
>
> @using System.Data;
> @using System.Collections.Generic;
> @using System.Data.SqlClient;
> @{
> Layout = null;
>
> string connectionString="Server=192.168.1.125,1433\\sqlexpress;
> Database=HEK; Uid=sa; Pwd=lubelincek12121";
> DataTable dt = new DataTable();
>
> String rows = "";
>
> using (SqlConnection conn = new SqlConnection(connectionString))
> {
> conn.Open();
> using (SqlDataAdapter adapter = new
> SqlDataAdapter("SELECT TOP 500 Datum, Sava, P1, P2, P3 FROM vws ORDER BY
> DATUM DESC", conn))
> {
> adapter.Fill(dt);
>
> List<string> rowsList = new List<string>();
>
> // rowsList.Add("['Datum', 'Sava', 'RPWS1']");
> foreach (DataRow row in dt.Rows)
> {
> //Converts your object into a DateTime (so that it's
> properties can be accessed properly
> DateTime yourDate = Convert.ToDateTime(row["Datum"]);
> rowsList.Add("[new Date(" + yourDate.Year + ", " +
> (yourDate.Month - 1) + ", " + yourDate.Day + ", " + yourDate.Hour + ", " +
> yourDate.Minute + ", " + yourDate.Second + "), "
> + row["Sava"] + ", "
> + row["P1"] + ","
> + row["P2"] + ","
> + row["P3"] + "]");
> }
> rows = String.Join(", ", rowsList);
> };
> };
> }@if (Roles.IsUserInRole("admin")||(Roles.IsUserInRole("hek"))){
> <span style="color: rgba(0,0,0,.33)"><b></b>.</span>}else{
> Response.Redirect("~/members/AdminError");}<html><head>
> <title>Test Graph</title><script type='text/javascript'
> src="http://www.google.com/jsapi";></script><script type="text/javascript"
> src="/java/asgallant.LineChartAsAnnotatedTimeline[0.4b].js"></script><script
> type="text/javascript">
> function drawChart() {
> var data1 = new google.visualization.DataTable()
> data1.addColumn('datetime', 'Datum');
> data1.addColumn('number', 'Sava');
> data1.addColumn('number', 'P1');
> data1.addColumn('number', 'P2');
> data1.addColumn('number', 'P3');
>
> data1.addRows([@Html.Raw(rows)]);
>
> var chart = new
> asgallant.LineChartAsAnnotatedTimeline(document.getElementById('chart_div'));
> chart.draw(data1, {
> title: 'Absolutni nivo vode',
> height: 350,
> width:850,
> vAxis: {
> minValue: 162,
> maxValue: 164
>
> }
>
> });
> }
> google.load('visualization', '1', { 'packages': ['controls'] });
> google.setOnLoadCallback(drawChart);</script></head>
>
> <body>
> <div id="chart_div"></div>
> </body></html>
>
>
> I've copied the whole folder with all java files and everything.
>
>
> Any idead would be appreciated , m
>
>
--
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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
