search in different places

Question

Hello

i have a project where you insert data. It's for teachers, so there are teachers who teach more than 1 course. So they insert in up to 5 different textboxes there courses. But if one teacher types math in the first and an other teachers types math in the second. They will be saved in 2 different columns. So if i filter the data and want to search for math, i get only the results of 1 column.

var ThisCust = from Custs in DB.Leerkrachtens
                           where Custs.LkVakken1 == "math"
                           select Custs;

            dataGridView1.DataSource = ThisCust;

what's your solution.

Answer 1

var ThisCust = from Custs in DB.Leerkrachtens
                           where Custs.LkVakken1 == "math" || Custs.LkVakken2 == "math"
                           select Custs;

---

Coding Light - Illuminated Ideas and Algorithms in Software
Coding Light Wiki • LinkedIn • ForumsBrowser

Answer 2

thanks

do you also know how i can have a gridview with data of more than 1 table. In a windows form, when you search on the internet for it, it's always a solution for asp.net.

Answer 3

Start a new thread.  One thread per question, please.  

---

Coding Light - Illuminated Ideas and Algorithms in Software
Coding Light Wiki • LinkedIn • ForumsBrowser