Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
trying to search an access db, no luck
I'm using Visual Basic.NET 2003 professional. I am having problems doing a search on an Access database. No matter what I try it's always returning false. I can fill the dataset with an entire table but have had no luck filling it with a specific 'recordset' or return set. I've tried using commandselect.commandtext = "SELECT * FROM [scannerlog] WHERE [Department = & "'cbdep.selecteditem & '" I've tried a lot of different (syntax)variations thinking maybe I am syntactically incorrect. I've also tried a dataview and the .filterrow or .rowfilter function. It doesn't work either. It returns false as well, UNLESS I put in the string department; then it returns true. It's not the specific word 'department' I want to compare, it's THE specific department(i.e. shipping, recieving, HR). If it finds 1 match or 100 matches it SHOULD display all the data in the table relative to the matches it finds. Any code ideas on HOW to search an access database and fill the dataset respectivley would be greatly apperaited.