Geek asks and answers

How to filter a DataGridView in C # Win Forms?

Guys I created a simple datagridview through the toolbar and the selected data through the wizard (without code in the .cs file) from the database. It works flawlessly, as you can see in the image below. DataGridView1

Now I want to filter out entries in it by the name of the contact person. I have a text box and a search button, so when a user enters a "contact name", for example, "Altaf" and then clicks on a search, the gridview should be updated and only the entry with ticket 4 should appear.

The only code in the .cs file: (it was automatically generated)

       private void Form2_Load(object sender, EventArgs e)
    { 
        this.tblTicketDetailTableAdapter.Fill(this.sTDataSet1.tblTicketDetail); //auto-generated
    }

I tried this in the buttonClick event, as suggested by someone, but it throws an error: "Unable to interpret token" {"at position 27"

        BindingSource bs = new BindingSource();
        bs.DataSource = dataGridView1.DataSource;
        bs.Filter = issuerNameDataGridViewTextBoxColumn + "like '%" + txtbxSearch.Text.Trim().Replace("'", "''") + "%'";
        dataGridView1.DataSource = bs.DataSource;

datagridviews , , , . .

.

+3
3

, , . , , .

, :

    public void btnSearch_Click(object sender, EventArgs e)
    {
        BindingSource bs = new BindingSource();
        bs.DataSource = dataGridView1.DataSource;
        bs.Filter = dataGridView1.Columns[5].HeaderText.ToString() + " LIKE '%" + txtbxSearch.Text + "%'";
        dataGridView1.DataSource = bs;
    }

.

+6

:

foreach (System.Windows.Forms.DataGridViewRow r in MyGridView.Rows)
{
      if ((r.Cells[5].Value).ToString().ToUpper().Contains(searchText.ToUpper()))
      {
            MyGridView.Rows[r.Index].Visible = true;
            MyGridView.Rows[r.Index].Selected = true;
      }
      else
      {
            MyGridView.CurrentCell = null;
            MyGridView.Rows[r.Index].Visible = false;
      }
 }
+5

Hope I understood your problem well.

string whereClause = "ContactPerson=" +textbox.text;
(datagridview.DataSource as DataTable).DefaultView.RowFilter = whereClause;
+1
source

More articles:


All Articles