protected void ButtonShow_Click(object sender, EventArgs e) { int[] data = { 12, 10, 131, 18, 112, 17 }; int[] data2 = { 237, 115, 13, 8, 125, 16 }; string[] legend = { "ich", "bin", "hier", "auch", "die", "welt" }; GCG c = new GCG(); DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("Zeit", typeof(string))); dt.Columns.Add(new DataColumn("Wert", typeof(int))); foreach(int i in data2) { DataRow newR = dt.NewRow(); newR[1] = i; dt.Rows.Add(newR); } c.ChartData = (dt); c.Width = int.Parse(TextBoxWidth.Text); c.Height = int.Parse(TextBoxHeight.Text); if (RadioButtonPie.Checked) c.ChartType = GCG.ChartTypes.Pie; if (RadioButtonBar.Checked) c.ChartType = GCG.ChartTypes.Bar; if (RadioButtonLine.Checked) c.ChartType = GCG.ChartTypes.Line; c.ChartTitle = TextBoxTitel.Text; string url = c.ImageUrl; ImageGoogleChart.ImageUrl = url; TextBoxUrl.Text = url; }
protected void ButtonShow_Click(object sender, EventArgs e) { int[] data = { 12, 10, 131, 18, 112, 17 }; int[] data2 = { 237, 115, 13, 8, 125, 16 }; string[] legend = { "ich", "bin", "hier", "auch", "die", "welt" }; GCG c = new GCG(); DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("Zeit", typeof(string))); dt.Columns.Add(new DataColumn("Wert", typeof(int))); foreach (int i in data2) { DataRow newR = dt.NewRow(); newR[1] = i; dt.Rows.Add(newR); } c.ChartData = (dt); c.Width = int.Parse(TextBoxWidth.Text); c.Height = int.Parse(TextBoxHeight.Text); if (RadioButtonPie.Checked) { c.ChartType = GCG.ChartTypes.Pie; } if (RadioButtonBar.Checked) { c.ChartType = GCG.ChartTypes.Bar; } if (RadioButtonLine.Checked) { c.ChartType = GCG.ChartTypes.Line; } c.ChartTitle = TextBoxTitel.Text; string url = c.ImageUrl; ImageGoogleChart.ImageUrl = url; TextBoxUrl.Text = url; }
protected void Page_Load(object sender, EventArgs e) { // TODO - den Code aus der Testseite *DRINGEND* wieder löschen DataTable dataTable; // die muss gefüllt werden string constr = ConfigurationManager.ConnectionStrings["LotboxConnectionString"].ConnectionString; SqlConnection con = new SqlConnection(constr); string sql = "select top 20 "; sql += " datediff(ww, created, lastlogindate) AS AktiveWochen, "; sql += " count(*) AS AnzahlSpieler "; sql += " from playerview "; sql += " where SumOfPayIn > 0 and status=0 "; sql += " group by datediff(ww, created, lastlogindate) "; sql += " order by datediff(ww, created, lastlogindate) "; SqlCommand cmd = new SqlCommand(sql, con); SqlDataAdapter ad = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); ad.Fill(ds); dataTable = ds.Tables[0]; // -- Daten sind fertig GridView1.DataSource = dataTable; GridView1.DataBind(); GCG g = new GCG(); g.ChartData = dataTable; g.ChartTitle = "erster Test"; g.ChartType = GCG.ChartTypes.Line; g.Width = 300; g.Height = 200; string url = g.ImageUrl; Image1.ImageUrl = url; }