C# Access2003/2007 連接字串總結

標籤：style   blog   color   io   os   sp   資料   div   on   

串連 Access 2007 的操作方法//無密碼的連接字串stringconStr = "Provider=Microsoft.Ace.OleDb.12.0;";conStr += @"Data Source=E:\資料庫\XiaoZhen.accdb;";conStr += "Persist Security Info=False;";//有密碼的連接字串stringconStr = "Provider=Microsoft.Ace.OleDb.12.0;";conStr += @"Data Source=E:\資料庫\XiaoZhen.accdb;";conStr += "Jet OleDb:DataBase Password=‘829321‘;";串連 Access 2003的操作方法//無密碼的連接字串stringconStr = "Provider=Microsoft.Jet.OleDb.4.0;";conStr += @"Data Source=E:\資料庫\XiaoZhen.mdb;";conStr += "Persist Security Info=False;";//有密碼的連接字串stringconStr = "Provider=Microsoft.Jet.OleDb.4.0;";conStr += @"Data Source=E:\資料庫\XiaoZhen.mdb;";conStr += "Jet OleDb:DataBase Password=‘829321‘;";<connectionStrings><add name="ConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\TeacherSystem\App_Data\db.mdb;Jet OLEDB:Database Password=123"providerName="System.Data.OleDb"/></connectionStrings>

 

C# Access2003/2007 連接字串總結