Search access database with multiple criterias

Question

Hey My first time here. Im completly new to programming and i guess the way i have done the application might not be right (most of the code i have got from somewhere along time ago) I have a small problem that i cant figure out. I have a windows form with 2 textboxes and a button. its connected to an access database. I have no trouble searching the database just using 1 textbox. But when im trying to get 2 searchcriteria to work everything goes bad well sorta it works in a way but not as i want to. when i search for just Firstname i want everyone with that firstname to come up and ONLY them. when i search for lastname i want everyone with that firstname to come up and ONLY them. And ofcourse when i put something in both boxes i want the perfect match person to come up. As i said im really new to this and this might be something obvoius but my brain limits me:) attaching sourcecode

Suthish Nair · Answer

refer article: http://www.mikesdotnetting.com/Article/26/Parameter-Queries-in-ASP.NET-with-MS-Access

Crish · Answer

Hi You can search data in many ways. but you can use Query for search i will give you one syntax for it. SELECT * FROM account_master WHERE acc_no LIKE '__044' You can search data depends on different criteria.