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
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.Windows.Forms.DataVisualization.Charting;
using MySql.Data.MySqlClient;
namespace WindowsFormsApplication4
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
MySqlConnection con = new MySqlConnection();
}
private void Form1_Load(object sender, EventArgs e)
{
Chart1.Series["Series1"].ChartType = SeriesChartType.Column;
try
{
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.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.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();
}
}
}