Click here to Skip to main content
15,879,490 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hai
i have tried to write the coding for presenting a graph from mysql database data in C# coding but i get the error like chart1 is not excit in the current context.

I don't know how to clear the error if u have any idea please reply me

I attached the following code I did

C#
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Web;
//using System.Web.UI;
//using System.Web.UI.WebControls;
using System.Windows.Forms.DataVisualization.Charting;
using MySql.Data.MySqlClient;

namespace WindowsFormsApplication4
{
    public partial class Form1 : Form
    {
   
        public Form1()
        {
            InitializeComponent();
            MySqlConnection con = new MySqlConnection();
            //Chart Chart1.Series["Series1"].ChartType = SeriesChartType.Column;
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            Chart1.Series["Series1"].ChartType = SeriesChartType.Column;
            try
            {
            // TODO: This line of code loads data into the 'testDataSet.periodicdata' table. You can move, or remove it, as needed.
            this.periodicdataTableAdapter.Fill(this.testDataSet.periodicdata);
             MySqlConnection con = new MySqlConnection();
            con.ConnectionString = "server=localhost;user id=root;password=vinoth;database=test";
            MySqlCommand cmd = new MySqlCommand();

           
                //con.ConnectionString = "server=localhost;user id=root;password=******;database=test";
                //con.ConnectionString = "server=.\\mysqlexpress;database=test;integrated security=true;";
                con.Open();
        
            }
            catch (Exception ex) { MessageBox.Show(ex.ToString()); }
        }


        private void button1_Click(object sender, EventArgs e)
        {
            Chart1.Series["Series1"].ChartType = SeriesChartType.Column;
            Chart1.Series["Series1"]["DrawingStyle"] = "Emboss";
            //Chart1.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true;
            Chart1.Series["Series1"].IsValueShownAsLabel = true;

            FillData();
        }

        private void FillData()
        {
            DataTable dt = new DataTable();
            DataColumn dc;

            dc = new DataColumn();
            dc.ColumnName = "date_time";
            dt.Columns.Add(dc);
            dc = new DataColumn();
            dc.ColumnName = "Volt1";
            dt.Columns.Add(dc);

            Chart1.DataSource = dt;
            Chart1.Series["Series1"].XValueMember = "date_time";
            Chart1.Series["Series1"].YValueMembers = "Volt1";
            Chart1.DataBind();
            //throw new NotImplementedException();
        }
    }
}
Posted
Updated 28-Jan-13 0:40am
v2
Comments
StM0n 28-Jan-13 6:44am    
On which line did the error occur?

Try using zedgraph, see this link: ZedGraph in a C# web application in a Medium trust environment[^]

Good Luck,
z3ngew
 
Share this answer
 
 
Share this answer
 
hello you can direct draw graph by using ajax new functinality for drawing graph.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900