C#-Access-connection

Question

Hello

I am totaly new on the c# and access area....
i have a access 2000 format database with 6 culums where informations of articles and books are saved and need to write a database connection with c#.

I basicly just want to search the database with different keywords, like author, name, category) and display the results.

What would u say is the easiest way to do that in c#!
Some tips and how to get started would be great!

Thank you for the comments!!!!

cheers, miky

Mahesh Chand · Answer

From MS KB: =================== SUMMARY loadTOCNode(1 'summary'); This article shows you how to create a parameter query to search for all the records in a table that begin with or that contain a certain letter. MORE INFORMATION loadTOCNode(1 'moreinformation'); An easy way to search for records that begin with a certain letter is to create a parameter query that prompts for a character to search for. You can use the LIKE operator with the wildcard character (*) to accomplish this task. This example uses the Employees table in the sample database Northwind.mdb. Method to Create Parameter Query Using the LIKE Operator loadTOCNode(2 'moreinformation'); 1. Create a new query that is based on the Employees table. 2. Drag LastName to the Field row and then type the following line in the Criteria row for the LastName field: LIKE [Enter the first char to search by: ] & * -or- LIKE * & [Enter any char to search by: ] & * NOTE : The Parameters dialog box is a fixed width dialog box; therefore if the prompt is too long not all of the characters will be displayed. 3. When you run this query you will be prompted with the message that you specified in the LIKE statement. The first LIKE statement finds all the last names that begin with the letter that you type into the parameter prompt. For example to find records where the last name starts with a L type L and begin the search. The second LIKE statement finds all the last names that have the letter that you type into the parameter prompt anywhere in the field. For example to find records where the last name has a L anywhere in the field type L and begin the search.