《c#chart图生成与属性设置l》由会员分享,可在线阅读,更多相关《c#chart图生成与属性设置l(5页珍藏版)》请在金锄头文库上搜索。
1、數據綁定private void BoundList() dt1 = new DataTable();/ dt1.Columns.Add(lb); dt1.Columns.Add(close1); dt1.Columns.Add(noclose1); dt1.Columns.Add(sum); dt1.Columns.Add(date1); dt1.Columns.Add(date2); string sql1 = select distinct(a.Partlb),ifnull(b.close1,0) close1,ifnull(c.noclose1,0) noclose1 from zl_
2、py_list a +left join (SELECT Partlb,count(*) close1 FROM zl_py_list WHERE Isclose=結案 AND Partlb!= and Partlb is not NULL; if (TextBox1.Text!= ) sql1 = sql1 + and Date= + TextBox1.Text + ; if (TextBox2.Text != ) sql1 = sql1 + and Date= + TextBox1.Text + ; if (TextBox2.Text != ) sql1 = sql1 + and Date
3、0 and a.Partlb!= GROUP BY Partlb; ds1 = MySqlHelper.ExecuteDataset(constr, sql1); if (ds1.Tables0.Rows.Count 0) for (int i = 0; i 0) this.Chart1.DataSource = dt1; /綁定數據 this.Chart1.DataBind(); this.GridView1.DataSource = dt1; /可以绑定到Gridview 、datalist等数据控件上,此处为Gridview this.GridView1.DataBind(); else this.Chart1.DataSource = null; this.Chart1.DataBind(); this.GridView1.DataSource = null; this.GridView1.DataBind();