C#柱状图

绘图工具

直接拉到界面上，效果如下：

chart的属性选择：

!](https://img-blog.csdnimg.cn/20210508213644922.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0FhMTIzNjQ1Njc=,size_16,color_FFFFFF,t_70)

 void select1()
        {
            chart1.Series[0].Points.Clear();
            chart1.Series[0].Color = System.Drawing.Color.Blue;
            chart1.Series[0].Name = "销售总数量";
            string time1 = dateTimePicker1.Value.ToString("yyyyMMdd");
            string time2 = dateTimePicker2.Value.ToString("yyyyMMdd");
            string name = comboBox1.Text;
            DataCon link = new DataCon();//DataCon为自己定义的数据库连接类，详细方法见本博客最后的链接
            string sql = " select sa_record.c_id 商品编号,c_name 商品名称,sum(sa_moun) 销售总量, sum(sa_count) 总金额  from sa_record,inventory where sa_record.c_id=inventory.c_id and(sa_date between '" + time1 + "' and '" + time2 + "') group by  sa_record.c_id ,c_name order by sum(sa_moun) ";
            SqlDataReader r = link.query(sql);
            DataRow pDataRow = null;
            DataSet pDataSet = new DataSet();
            DataTable pDataTable = new DataTable();
            pDataTable.Load(r, LoadOption.Upsert, null);
            if (pDataTable.Rows.Count != 0)
            {
                pDataRow = pDataTable.Rows[0];
            }
            for (int i = 0; i < pDataTable.Rows.Count; i++)
            {
                chart1.Series[0].Points.AddXY(pDataTable.Rows[i][1], pDataTable.Rows[i][2]);
            }
        }

数据库连接类的方法