Bind chart data to datepicker to show custom timeline

See more:

C#

SQL-Server

Visual-Studio

, +

i a very new to c#

I have created a bar chart in my WinForms application , by connecting them to MSSQL stored procedure as the data source , but i needed to provide a date picker function (from and to) and when user selects the date , only that much filtered data should be populated to the chart , but whenever i click the update button , the chart is getting data additionally(see the image) instead f filtering.



my code for chart in winform:

private void GraphToprej()
            {
                SqlConnection con = new SqlConnection(cs);
                SqlCommand cmd = new SqlCommand("Toprej", con);
                cmd.Parameters.AddWithValue("@fromDate", dtfrom.Value);
                cmd.Parameters.AddWithValue("@toDate", dtto.Value);
                cmd.CommandType = CommandType.StoredProcedure;
                con.Open();
                SqlDataReader dr = cmd.ExecuteReader();
                while (dr.Read())
                {
                    Rejcategory.Add(dr.GetString(0));
                    RejSum.Add(dr.GetInt32(1));
                }
                ChartTopRej.Series[0].Points.DataBindXY(Rejcategory, RejSum);
                dr.Close();
                con.Close();
            }
private void datefil_Click(object sender, EventArgs e)
        {
            GraphToprej();
        }

What I have tried:

my procedure for chart:

create proc toprej
@fromDate date,
@toDate date
as
select top 10 RejectReason1 as Reason, Sum(NetWt) as Quantity
from IP_Spools
Where status = 'Reject' AND DOE between  @fromDate  and  @toDate
group by RejectReason1
order by Sum(NetWt) desc
g

result:
https://i.stack.imgur.com/vz3qH.png[^]