Vb.net- show list of only what I select in datagrid

Question

0.00/5 (No votes)

See more:

i have a datagridview that shows 2 tables data (with left join relation).
i try to add to my form another datagrid of listbox that when i click on the first datagridview i'll see only the rows datagridview match it.

for instance, the 2 tables contain togther:
1 dad "aaaa"
2 dad "bbbb"
3 mom "cccc"
4 boy "ddddd"
5 girl "eeeee"
(i created a datatale in dataset contining those columns)

first datagridview rows shows:
dad
mom
boy
girl

1 dad "aaaa"
2 dad "bbbb"
3 mom "cccc"
4 boy "ddddd"
5 girl "eeeee"

when i click on the first row,
i'll see 3 lines in the oher datagridview or listbox with:
"aaaa"
"bbbb"

What I have tried:

try for hourse the binding tool in visual studio 2017 but i have'nt figure it out yet.

Posted 11-Feb-18 2:01am

Member 13672587

Updated 11-Feb-18 2:53am

v2

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)

Maciej Los · Accepted Answer · 2018-02-11T02:53:00

Solution 1

2 ways:

DataTable.Select Method (String) (System.Data)[^]

VB

Dim firstselection As String = "dad"
Dim filtereddata = dt.Select("familyfunction='" + firstselection + "'")

Enumerable.Select(TSource, TResult) Method (IEnumerable(TSource), Func(TSource, TResult)) (System.Linq)[^]

VB

Dim firstselection As String = "dad" 
Dim filteredData = dt.AsEnumerable().Where(Function(x) x.Field(Of String)("familyfunction") = firstselection)

Posted 11-Feb-18 2:53am

Maciej Los

Comments

Member 13672587 11-Feb-18 9:24am

thanks but can you be more specific.
where to put this lines?
sorry, i'm noob..
i mostly use the wizards in vb17

Maciej Los 11-Feb-18 10:06am

Let's say, you have got:
- 2 DataGridViews: dgv1 and dv2.
- 1 button: btn1
You have to create btn1_Click event (double click on button). Then add one of above method in that event. Finally: dgv1.DataSource = filteredData