Query?

[drummerboy24]

I'm trying to figure out how to get a query for multiple columns in my dataviewgrid.. So far i havn't even been able to make a single column query work, when i search something in First_Name for example, it returns nothing. ive used query builer, ive written the code myself, nothing seems to work. thanks a lot. if you need any of my code or names of objects just ask. thanks again.

[jmcilhinney]

Follow the Database FAQ link in my signature and check out the ADO.NET resources there. You should check them all out but one is my own ADO.NET code examples from the CodeBank. If you try to emulate what I demonstrate there and it doesn't work then show us what you did, i.e. post the relevant code, and tell us what happened, including any error messages.

[drummerboy24]

Thanks man but I figured it out, it was because I kept putting the filters under the same 'filter' column instead of the 'Or...' :/ I do have another issue though, whenever i change code or close the project and re open it and then debug i get one extra entry that i don't want, like i want it to start fresh without previous entries. how do i clear that one without corrupting my tables?

[jmcilhinney]

That question has nothing to do with the topic of this thread so it doesn't belong in this thread. Please keep each thread to a single topic and each topic to a single thread. I suggest that you start a new thread dedicated to the new topic and provide a more complete description of exactly what you want, exactly what you're doing and exactly what's happening.