How to sort grid view Data Month and year wise

Question

0.00/5 (No votes)

See more:

how to sort datagridview data month and year wise. Where i have two combobox one of month and second for year and a button name "Search". when click on search button it should sort datagridview data according to the value which are selected on combobox.
For example i select month as "January" and year as "2013" so it should show me the data of January 2013 in datagridview.

Posted 26-Feb-14 4:46am

Member 10445097

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2014-02-26T04:50:00

The easiest way is to use a BindingSource[^] - you sepecify the DataDource of the BindingSource, then set the DataGridView.DataSource to the BindingSource.
You then set the Filter property to select the displayed records: http://msdn.microsoft.com/en-us/library/system.windows.forms.bindingsource.filter(v=vs.110).aspx[^]

An example from my code:

C#

private static void FillCalculated(List<CalculatedRepEntry> fullData, List<repEntry> repData, DataGridView dgv)
    {
    MovingAverage aveAll = new MovingAverage();
    MovingAverage ave30 = new MovingAverage(30);
    MovingAverage ave10 = new MovingAverage(10);
    int lastRep = int.MinValue;
    foreach (RepEntry rep in repData)
        {
        fullData.Add(new CalculatedRepEntry(rep, lastRep, aveAll, ave30, ave10));
        lastRep = rep.RBasis;
        }

    // Convert to DataTable for DataView (there is no DataView constructor that works with a List)
    DataTable dt = fullData.ToDataTable();
    DataView dv = new DataView(dt);
    BindingSource bs = new BindingSource();
    bs.DataSource = dv;
    dgv.DataSource = bs;
    dgv.Tag = bs;           // Save the BindingSource for filter declaration.
    // And prep the display column formats.
    dgv.Columns["Est1Mav"].DefaultCellStyle.Format = "dd/MM/yyyy";
    dgv.Columns["Est1M30Av"].DefaultCellStyle.Format = "dd/MM/yyyy";
    dgv.Columns["Est1M10Av"].DefaultCellStyle.Format = "dd/MM/yyyy";
    FormatNumericColumn(dgv, "RBasis");
    FormatNumericColumn(dgv, "Delta");
    FormatNumericColumn(dgv, "Average");
    FormatNumericColumn(dgv, "Av30Day");
    FormatNumericColumn(dgv, "Av10Day");
    }

Then to filter by date:

C#

private void dtpFromDate_ValueChanged(object sender, EventArgs e)
    {
    DateTime limit = dtpFromDate.Value.Date;
    BindingSource bs = dgvRBasis.Tag as BindingSource;
    if (bs != null)
        {
        bs.Filter = DateTime.Now.Date > limit ? "Date > '" + limit + "'" : "";
        }
    }