how could i can connect C# with ms access 2007 as i want to use the data in a form of table in my C# program.As im creating a system to input the marks of the student and the list of student is in ms access so need to input that list in C#.
In order to connect to the MS Access 2007 you should use this snippet of code:
string ConnStr = @"Provider=Microsoft.ACE.OLEDB.12.0;
Jet OLEDB:Database Password=password";
OleDbConnection DBCon = new OleDbConnection(ConnStr);
When you have established a connection with the db, all you have to do is to create a DataAdapter Object in order to run the query you want, and then create a Dataset Object to store the information that you got from the db.
(In order to fill the Dataset object, use the .Fill() function of the DataAdapter Object)