I need some help getting started. I created a connection to a Access DataBase, I was able to import the Data onto a DataGrid Easily. Now I have to make a search that will search for names, ID's and such... One problem i have is that the Table Field names are "Customer ID" or "Contact Name" which have spaces in them. How do I handle those?
My options that I see are either the DataView or use a OleDBCommand what are the syntax for using those? so i can filter out the ones I do not need. I also want to be able to use WildCards to search partial properties.
I'm not looking for a full solution really just some help to get started or Links to websites where i can read up on it