Data Access and Grid control
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?