dataGridView. Фильтрация по нескольким условиям
Фильтрация по кнопке: private void button3_Click(object sender, EventArgs e) { BindingSource bds = new BindingSource(); List<string> filterParts = new List<string>(); if (tB_w_ID.Text != "") filterParts.Add("W_ID LIKE '%" + tB_w_ID.Text + "%'"); if (tB_w_Name.Text != "") filterParts.Add("W_NAME LIKE '%" + tB_w_Name.Text + "%'"); if (tB_w_Surname.Text != "") filterParts.Add("W_SURNAME LIKE '%" + tB_w_Surname.Text + "%'"); if (tB_w_Patronymic.Text != "") filterParts.Add("W_Patronymic LIKE '%" + tB_w_Patronymic.Text + "%'"); string filter = string.Join(" AND ", filterParts); workersBindingSource.Filter = filter; }