Select rows in Datagridview depending of each line in a Multilite Textbox

Question

4.00/5 (1 vote)

See more:

I have a Datagridview full of data, from a Dataset, I'm using access.
I also have a Multiline Textbox and a Button to execute the code in the Onclick event.

I want to show the Datagridview rows that match with the lines in the Multiline Textbox.

For example: my Datagridview have two columns: "Name" and "Last_Name"...

In the Textbox when I type in the first line 'John' and in the second line I type 'Mary', I want the Datagridview to show me only the rows that have these names in the "Name" Column. So in the Datagridview we'll have two rows 'John' in one row and 'Mary' in the other row, and if I keep typing in others lines into the Multiline Textbox keep doing the or search and/or filter...

Can someone help me with this please?

Thanks in advance!

Posted 6-Aug-12 3:25am

Jaasiel

Add a Solution

Comments

Aditya Mangipudi 6-Aug-12 9:27am

Can you post some code? Where exactly are you having problems?

[no name] 6-Aug-12 9:29am

Help with what? The only question in here is, "Can someone help me with this please?". What is the specific problem that you have? Where is the code that demonstrates this problem?

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)

Kenneth Haugland · Answer 1 · 2012-08-06T04:32:00

If you are going to hard code this the only option I see is to use this code here:
http://social.msdn.microsoft.com/Forums/en/wpf/thread/a5fd5413-f055-4b56-83af-6d6bdb1d6fe9[^]

The esayer thing, and fare more efficient thing is to do a search in the DataTable that you bind the DataGridView to, and you could highlight it with the code in the first link.

There is also the question on what to filter the data with, Id use either link or the build in filter function in the DataGridVeiw-

Jaasiel · Answer 2 · 2012-08-06T04:55:00

Thanks for answering!

I got something, it's close but the issue is that I'll need to write any single line that I'd like to use in the Multiline Textbox, not good...

Would be great do it with a simple code or a loop or some like that.

Hope somebody helps!

Code Below, Thanks,

C#

string[] lines = textBox1.Lines;


         string sql = "Select Name_Column FROM Database";


         OleDbDataAdapter da = new OleDbDataAdapter();
         da = new OleDbDataAdapter(sql, conneccionDB);
         DataSet ds = new DataSet();
         da.Fill(ds, "Database");


         DataView dtv = new DataView(ds.Tables[0], "Name_Column LIKE '%" +  lines[0] + "%' OR Name_Column LIKE '%" + lines[1] + "%'", "Name_Column", DataViewRowState.CurrentRows);

          lineIndex++;
          datagrid_catnumRef.DataSource = dtv;

Select rows in Datagridview depending of each line in a Multilite Textbox

2 solutions

Solution 1

Solution 4

Add your solution here

Preview 0