Chart sql

using ZqzWebChart.Charting;
        string strProvider = "Server=.;DataBase=dbname;UID=sa;PWD=sa";
        string mySelectQuery = "SELECT * FROM ProjectStage";
        SqlConnection MyConn = new SqlConnection(strProvider);
        SqlCommand sqlCmd = new SqlCommand(mySelectQuery, MyConn);             
        Chart1.DataSource = sqlCmd;
        Chart1.Series["Series 1"].XValueMember = "StageID";
        Chart1.Series["Series 1"].YValueMembers = "Manhours";
        Chart1.DataBind();

        sqlCmd.Dispose();
        MyConn.Close();

原文地址:https://www.cnblogs.com/greencolor/p/1726860.html