public void drawchart(DataTable t)
{
String s = "SELECT " + t.Rows[0][5].ToString() + ", " + t.Rows[0][7].ToString() + " FROM [" + t.Rows[0][1].ToString() + " ];";
//DrawSaved_ChartUserControl.assingDataPoint(s);
//String connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;
//SqlConnection connection = new SqlConnection(connectionstring);
//connection.Open();
//SqlCommand cmd = new SqlCommand(s, connection);
//SqlDataReader reader = cmd.ExecuteReader();
DrawSaved_ChartUserControl.READER = DatabaseClass.ExequteReaderQuery(s);
//DrawSaved_ChartUserControl.READER = reader;
//Chart1.Series["Series1"].Points.DataBindXY(reader, "xAxis", reader, "yaxis");
//Chart1.DataManipulator.Sort(PointSortOrder.Descending, "Series1");
//Chart1.DataManipulator.GroupByAxisLabel("SUM","Series1");
if (DatabaseClass.getTableDatafromTable(t.Rows[0][1].ToString()) != null)
{
DrawSaved_ChartUserControl.Visible = true;
/// DrawSaved_ChartUserControl.DATASETFORCHART = DatabaseClass.getTableDatafromTable(t.Rows[0][1].ToString());
DrawSaved_ChartUserControl.CHARTTITLE = t.Rows[0][3].ToString();
DrawSaved_ChartUserControl.CHARTTYPE = t.Rows[0][4].ToString();
DrawSaved_ChartUserControl.XVALUEMEMBER = t.Rows[0][5].ToString();
DrawSaved_ChartUserControl.YVALUEMEMBER = t.Rows[0][7].ToString();
DrawSaved_ChartUserControl.ENABLELEGEND = true;
DrawSaved_ChartUserControl.XAXISINTERVAL = 1;
DrawSaved_ChartUserControl.XAXISTITLE = t.Rows[0][6].ToString();
DrawSaved_ChartUserControl.YAXISTITLE = t.Rows[0][8].ToString();
DrawSaved_ChartUserControl.CHARTBACKGROUNDCOLOR = t.Rows[0][9].ToString();
DrawSaved_ChartUserControl.CHARTSERIESCOLOR = t.Rows[0][10].ToString();
if (t.Rows[0][11].ToString() == "1")
{
DrawSaved_ChartUserControl.ENABLE3D = true;
}
else
{
DrawSaved_ChartUserControl.ENABLE3D = false;
}
DrawSaved_ChartUserControl.SORTING = "Ascending";
DrawSaved_ChartUserControl.FORMULA = "Sum";
DrawSaved_ChartUserControl.CreateChart_UserControl();
}
DatabaseClass.closeReaderConnection();
DatabaseClass.closeConnection();
// connection.Close();
}
//call the usercontrol function to draw the chart
#region creat saved chart
public void CreateChartSaved_FromUserControl()
{
if (DatabaseClass.getTableDatafromTable(t.Rows[start][1].ToString()) != null)
{
DrawSaved_ChartUserControl.Visible = true;
//DrawSaved_ChartUserControl.DATASETFORCHART = DatabaseClass.getTableDatafromTable(t.Rows[start][1].ToString());
DrawSaved_ChartUserControl.CHARTTITLE = t.Rows[start][3].ToString();
DrawSaved_ChartUserControl.CHARTTYPE = t.Rows[start][4].ToString();
DrawSaved_ChartUserControl.XVALUEMEMBER = t.Rows[start][5].ToString();
DrawSaved_ChartUserControl.YVALUEMEMBER = t.Rows[start][7].ToString();
DrawSaved_ChartUserControl.ENABLELEGEND = true;
DrawSaved_ChartUserControl.XAXISINTERVAL = 1;
DrawSaved_ChartUserControl.XAXISTITLE = t.Rows[start][6].ToString();
DrawSaved_ChartUserControl.YAXISTITLE = t.Rows[start][8].ToString();
DrawSaved_ChartUserControl.CHARTBACKGROUNDCOLOR = t.Rows[start][9].ToString();
DrawSaved_ChartUserControl.CHARTSERIESCOLOR = t.Rows[start][10].ToString();
DrawSaved_ChartUserControl.FORMULA = t.Rows[start][11].ToString();
DrawSaved_ChartUserControl.SORTING = t.Rows[start][12].ToString();
if (t.Rows[start][11].ToString() == "1")
{
DrawSaved_ChartUserControl.ENABLE3D = true;
}
else
{
DrawSaved_ChartUserControl.ENABLE3D = false;
}
String chartcreatequery = "SELECT " + t.Rows[start][5].ToString() + " , " + t.Rows[start][7].ToString() + " FROM [" + t.Rows[start][1].ToString() + "]";
DrawSaved_ChartUserControl.READER = DatabaseClass.ExequteReaderQuery(chartcreatequery);
DrawSaved_ChartUserControl.CreateChart_UserControl();
DrawSaved_ChartUserControl.CreateChart_UserControl();
DatabaseClass.closeReaderConnection();
DatabaseClass.closeConnection();
}
}
