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(); } }