hi,
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#.
aowais
0
Newbie Poster
Recommended Answers
Jump to PostHi there,
In order to connect to the MS Access 2007 you should use this snippet of code:
string ConnStr = @"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=C:\resources\pw.accdb; Jet OLEDB:Database Password=password"; OleDbConnection DBCon = new OleDbConnection(ConnStr);
When you have established a connection with the db, all you have to do …
All 3 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.