How Filtering Datagridview?

Question

1.00/5 (1 vote)

See more:

Hello!
From lasttopic i have question about filtering rows DataGridView.
This is link on topic, where you can see how shapes DataGrig:

C#

ListCards.DataSource = BLL.Cards.GetListCards(); (View layer)

At manual MSDN i found following:

C#

BindingSource bs = new BindingSource();
bs.DataSource = dataGridView1.DataSource;
bs.Filter = "yourColumnName like '%" + textBox1.Text + "%'";
dataGridView1.DataSource = bs;

_________________________________
In the first i want to fill Grid and show it: ListCards.DataSource = BLL.Cards.GetListCards();
When i enter text to TextBox i want to do sort by Name Grid and how make it?
Try such:
BindingSource bs = new BindingSource();

C#

<pre lang="c#">

....Event
bs.DataSource = BLL.Cards.GetListCards();
bs.Filter = "yourColumnName like '%" + textBox1.Text + "%'";
ListCards.DataSource = bs;

Posted 16-Apr-13 11:06am

Junoli

Add a Solution

Comments

[no name] 16-Apr-13 17:16pm

Example:

// Create a BindingSource and set its DataSource property to
// the DataView.
BindingSource source1 = new BindingSource();
source1.DataSource = view1;

// Set the data source for the DataGridView.
datagridview1.DataSource = source1;
I must change view1 to BLL.Cards.GetListCards();?

//The Filter string can include Boolean expressions.
source1.Filter = "artist = 'Dave Matthews' OR cd = 'Tigerlily'";

2 solutions

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)

Dilan Shaminda · Answer 1 · 2013-04-16T12:59:00

Solution 1

Check this Junoli...

http://msdn.microsoft.com/en-us/library/system.windows.forms.bindingsource.filter.aspx[^]

Posted 16-Apr-13 12:59pm

Dilan Shaminda

Comments

[no name] 17-Apr-13 2:30am

I reed it but question left up

[no name] 17-Apr-13 2:51am

I tried such, but does not filter:
ListCards.DataSource = list;
ListCards.Columns["StartDay"].Visible = false;
ListCards.Columns["EndDay"].Visible = false;

BindingSource bn = new BindingSource();
bn.DataSource = ListCards.DataSource;
//bn.Filter = "IdUser = " + textBox1.Text + "";
bn.Filter = "Username like '%" + textBox1.Text + "%'";
ListCards.DataSource = bn;

Dilan Shaminda 17-Apr-13 2:50am

did you try do it? i mean did you try coding ?

[no name] 17-Apr-13 2:54am

I have DataSource not a DataTable, i have my own type List

Junoli · Answer 2 · 2013-04-16T20:59:00

Solution 3

So, i made:

XML

BindingList<Cards.Model.Cards> filtered = new BindingList<Cards.Model.Cards>(list.Where(
                                 p => p.Username.Contains(""+textBox1.Text+"")).ToList());
            ListCards.DataSource = filtered;

Posted 16-Apr-13 20:59pm

Junoli