c#chart

        /// <summary>
        /// ar trebui sa iau numarul de imprumuturi facute in fiecare luna din fiecare an.
        /// </summary>

        void usercountview(DateTime data)
        {
            OleDbConnection connection = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data source = freebook.accdb;");
            connection.Open();
            OleDbCommand command = new OleDbCommand(
                @"SELECT
                        Count(Year(data_imprumut)) as cate,
                        month(data_imprumut) as luna,
                        year(data_imprumut) as an
            FROM imprumut
            WHERE
                    (((Year([data_imprumut])) <= year(@data_imprumut)
                    And
                    (Year([data_imprumut])) >= year(@data_imprumut)-1))
            GROUP BY Year(data_imprumut), month(data_imprumut);", connection);
            command.Parameters.AddWithValue("data_imprumut", data);
            OleDbDataReader read = command.ExecuteReader();
            while(read.Read())
            {
                listBox1.Items.Add(read["cate"].ToString() + " " + read["luna"].ToString() + " " + read["an"].ToString());
                chartUsers.Series["Luna"].Points.AddXY(read["luna"].ToString(), read["cate"].ToString());
            }
            read.Close();
            connection.Close();
        }

        private void cbAni_SelectedIndexChanged(object sender, EventArgs e)
        {

            DateTime data = new DateTime(int.Parse(cbAni.Items[cbAni.SelectedIndex].ToString()), 1, 1);
            usercountview(data);
        }

        /// cele mai mari 4 valori luate dupa imprumuturi.