1 Replies - 504 Views - Last Post: 22 February 2018 - 11:41 PM Rate Topic: -----

#1 itsmethecoder101   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 14-January 18

Bindingsource.filter datagridview realtime search vb.net

Posted 22 February 2018 - 09:49 AM

I have three fields in my access database
ID, Name, Description

I have manually inserted the database into the datagridview

It loads fine.

I try to carry out a search
     'Me.DrugsBindingSource.Filter = "ID like '%" & Tbx_SearchMedication.Text & "%'"      


Says something about missing operator. I am new to databases would appreciate the help! it works however if its just

Me.DrugsBindingSource.Filter = "ID like '%" & Tbx_SearchMedication.Text & "%'"     


however I want the textbox to filter all three fields when its searching

Thanks a lot !

just realised that I copy and pasted the code when it was commented because i was testing ! so that is not the reason why it is not working :)

Is This A Good Question/Topic? 0
  • +

Replies To: Bindingsource.filter datagridview realtime search vb.net

#2 andrewsw   User is online

  • RequestedRangeNotSatisfiable
  • member icon

Reputation: 6552
  • View blog
  • Posts: 26,562
  • Joined: 12-December 12

Re: Bindingsource.filter datagridview realtime search vb.net

Posted 22 February 2018 - 11:41 PM

The statement you say does not work, and the one you say works, are the same..?
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1