Data Access and Grid control

[lis75]

Hi,
Could some one please help me with the following :-
I have a table in the MS Access DataBase. And I need to access the table (inorder to display, add and edit the records) ALL Through CODE.
Could someone help me with the code for setting up a connection and reading the records for manipulation and storing the changed records back into the table?
I want the results to be populated in a tabluar form. What control is best for the same? If I use a Gridcontrol can I edit the fields? I mean, I need one field(column in the grid) to be a combo box since, while adding a new record in the grid, the user should be able to choose a value from a drop down list of values which come from another table!
Could someone guide me since I am kind of new to .NET?

[mendhak]

Although I could help, I would still suggest that you learn ADO.NET for this.

I see no point in accomplishing something without understanding how it works.

Once you're familiar with ADO.NET, it'll be easy for you.