title: Filtering rows in view
body: <p>I'm new in database and C# but i would like to learn it. So sorry if i ask noby question but i couldn't find answer anywhere I've tried ( I have found a lot answers with SQL databases but not with access databases )</p>
  
  <p>I want to make simple program with contacts to workers:</p>
  
  <ul>
  <li>there will be Name of Company and then all necessarily info to contact the dealer of this company.</li>
  <li>The idea is to allow user to search company and then by button in <code>gridview</code> -> open all contacts which i have to this company like phones to dealers, boss, fax, email etc. )</li>
  </ul>
  
  <p>I've already loaded data to my <code>gridview</code> by this code:</p>
  
  <pre><code>OleDbConnection connect = new OleDbConnection();
  connect.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\User\Documents\Programy\Baza Danych Kontakty\Dane.accdb";
  connect.Open();
  
  OleDbCommand command = new OleDbCommand();
  command.Connection = connect;
  command.CommandText = "SELECT * FROM Firma";
  
  OleDbDataReader reader = command.ExecuteReader();
  while (reader.Read())
  {
      dataGridView1.Rows.Add();
      dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[0].Value = reader[2].ToString();
      dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[1].Value = reader[0].ToString();
  }
  connect.Close();
  </code></pre>
  
  <p>but I have really big problem to filter records.. This database should have few hundredths of records with way more contacts so filtering it from hand aren't good idea I guess. And also I would like to filter data by typing in <code>textbox</code>..</p>
  
  <p>example: i start typing : B ( it shows me every Company name which have B in her name ) then O ( it shows companies with BO ) + E ( BOE ) + I ( BOEI )  +N ( BOEIN ) and +G ... it should filter in real time ( without button "search").</p>
  
  <p>Like i said i found many answers for SQL data users, but any for access data users.. And better for me to stay in access since I must make school project in this data.</p>
  
  <p>I hope I am clear enough with my needs, and hope that someone know how to help me.</p>
  
  <p>Thanks a lot and sorry for my bad English.</p>