How Do I Filter The Rows In Dgv In Simple Way

Question

0.00/5 (No votes)

See more:

Is there an easier way to filter rows in the DataGridView of this way ?

C#

private void Reread()
{
    string nameFilter = txtSearch.Text;
    string addressFilter = comboBox1.SelectedIndex > 0 ? comboBox1.Text : "";
    string depFilter = comboBox2.SelectedIndex > 0 ? comboBox2.Text : "";
    DateTime? birthdate = chkBirthdate.Checked ? dateTimePicker1.Value.Date : (DateTime?) null;
    DateTime? fromDate = chkRange.Checked ? dateTimePicker2.Value.Date : (DateTime?)null;
    DateTime? toDate = chkRange.Checked ? dateTimePicker3.Value.Date : (DateTime?)null;

    using (DbDataContext db = new DbDataContext())
    {
        var result = from p in db.Persons
                     where
                        (nameFilter.Length > 0 && p.FullName.Contains(nameFilter) || nameFilter.Length == 0)
                     && (addressFilter.Length > 0 && p.Address == addressFilter || addressFilter.Length == 0)
                     && (depFilter.Length > 0 && p.Department == depFilter || depFilter.Length == 0)
                     && (birthdate == null || (birthdate != null && p.Birthdate == birthdate))
                     && ((fromDate == null || toDate == null) || (fromDate != null && toDate != null && p.Birthdate >= fromDate && p.Birthdate <= toDate))

                     select p;

        var resultData = result.ToList();

        dataGridView1.DataSource = resultData;
    }

Posted 4-Feb-15 8:28am

Ahmed Dabas

Add a Solution

Comments

Sinisa Hajnal 5-Feb-15 2:48am

There is, put filters as parameters to storeed procedure and call it after changing parameters to return only the data you need from the filter instead of getting every person in the table as datasource :)

Alternative, not necessarily better, but easier to format is to get the data (db.Persons) into datatable object and use DataTable.Select method for which you can prepare filter with all the conditions before using it (more readable).

Ahmed Dabas 5-Feb-15 3:44am

mr. Sinisa Hajnal , can u give me a real example how can i put filters as parameters to storeed

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)

George Swan · Answer 1 · 2015-02-05T08:36:00

C#

//Build the query in stages taking advantage of deferred execution.
         //select all Persons
         var query = from p in db.Persons select p;
         //apply nameFilter if valid
         if (!string.IsNullOrEmpty(nameFilter))
         {
             query = query.Where(
                 n => n.fullName.Contains(nameFilter));
         }
         //apply addressFilter, if valid
         if (!string.IsNullOrEmpty(addressFilter))
         {
             query = query.Where(a => a.Address == addressFilter);
         }
         //apply departmentFilter, if valid
         if (!string.IsNullOrEmpty(depFilter))
         {
             query = query.Where(d => d.Department == depFilter);
         }
         //apply birthdateFilter, if valid
         if (birthdate != null)
         {
             query = query.Where(b => b.Birthdate == birthdate);
         }
         //apply dateRangeFilter, if valid
         if (birthdate != null && toDate != null && fromDate != null)
         {
             query = query.Where(dr.Birthdate >= fromDate && dr.Birthdate <= toDate);
         }
         //run the query
         var results = query.ToList();