且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何从visual studio C#连接到MS office数据库

更新时间:2021-08-11 22:39:17

检查:访问连接字符串 - ConnectionStrings.com [ ^ ]



正确的C#声明是:

Check this: Access connection strings - ConnectionStrings.com[^]

A proper C# statement is:
string sconn = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\YourFolder\YourAccessFile.accdb;Persist Security Info=False;"





你看到了区别吗?



更多来自MSDN:

演练:连接到Access数据库中的数据(Windows窗体) [ ^ ]

连接到Access数据库 [ ^ ]

如何:使用SqlDataSource控件连接到Access数据库 [ ^ ]



Do you see the difference?

More at MSDN:
Walkthrough: Connecting to Data in an Access Database (Windows Forms)[^]
Connect to an Access Database[^]
How to: Connect to an Access Database Using the SqlDataSource Control[^]