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
Loading
Suthish NairPosted Dec 13, 2010, 12:44 PM
http://www.mikesdotnetting.com/Article/26/Parameter-Queries-in-ASP.NET-with-MS-Access
CrishPosted Dec 13, 2010, 5:25 AM
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.