I am using VB.NET, I have an access database includes 2 tables (A,B) which I am viewing in the windows form by 2 DATAGRIDVIEW (1,2).
Now I can filter any DATAGRIDVIEW for any item, but the problem is that i want to filter the second DATAGRIDVIEW according to the results in the 1st.
I filtered DATAGRIDVIEW 1 (which contains table A) and I got 20 results, so I need DATAGRIDVIEW 2(which contains table B) to filter for all the items which got a matching cell with DATAGRIDVIEW 1.
I don't have any table relations.
I think it should be done with array, But I don't know how.
To Filter I am using
SuppliersITEMSDataGridView.DataSource = Me.DATABASEDataSet.SuppliersITEMS.Select(("Convert(Description, 'System.String') LIKE '" & textbox1.text & "'")
I load the datagridview Using Visual studio, I drag the datagridview database and it load automaticly