隨便寫寫的新天地

using System.Data.OleDb

String strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\TestDbData.mdb;";
OleDbConnection AccessCon = new OleDbConnection(strCon);
AccessCon.Open();

...

 AccessCon.Close()           //關閉對資料庫的連接

using System.Data.OleDb

...

builder.Cear();

using System.Data.OleDb

String strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\TestDbData.xls;ExtendedProperties=Excel 8.0;"
OleDbConnection ExcelCon = new OleDbConnection(strCon);
ExcelCon.Open();

...

 ExcelCon.Dispose();                //釋放 Component 所使用的資源

using System.Data.OleDb

using System.Data.SqlClient

//用 Windows 身份驗證
String strCon = "Data Source=(local);Initial Catalog=TestDb;Integrated Security=SSPI;";

//用 SQL Server 身份驗證
String strCon = @"Data Source=.\SQLExpress;Database=TestDb;Uid=sa;Pwd=1234;";

SqlConnection SqlSvrCon = new SqlConnection(strCon);
SqlSvrCon.Open();

...

using System.Data.SqlClient

//SqlConnectionStringBuilder 類別
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder["Data Source"] = "(local)";
builder["integrated Security"] = true;
builder["Initial Catalog"] = "TestDb;NewValue=Bad";

SqlConnection SqlSvrCon = new SqlConnection(builder.ConnectionString);
SqlSvrCon.Open();

...

using System.Data.Sql;                         //引用 SqlDataSourceEnumerator 類別
using System.Data;                               //引用 ADO.NET 基礎物件(DataTable)

SqlDataSourceEnumerator instance = SqlDataSourceEnumerator.Instance;
DataTable table = instance.GetDataSources();

foreach (DataRow row in table.Rows)
{
    foreach (DataColumn col in table.Columns)
    {
        lstSqlSvr.Items.Add(col.ColumnName + " = " + row[col]);
    }
}

using (SqlConnection SqlSvrCon = new SqlConnection(strCon))
{
 

    SqlSvrCon.Open();
    SqlDataAdapter da=new SqlDataAdapter("select name from sysdatabases",SqlSvrCon);
    DataTable dt=new DataTable("sysdatabases");
    da.Fill(dt);
    lstData.DataSource=dt;
    lstData.DisplayMember = "name";
    lstData.ValueMember = "name";

}

...//連接資料庫

string strSql = "exec sp_detach_db @dbname=TestDB";
string strExc = "alter database TestDB set single_user with rollback immediate "+strSql;
//請先將資料庫設為 SINGLE_USER 模式以取得獨佔存取權，才能進行卸離

SqlCommand cmd=new SqlCommand();
cmd.Connection=SqlSvrCon;
cmd.CommandText = strExc;
cmd.ExecuteNonQuery();

Transact-SQL 語法：

sp_detach_db [ @dbname = ] 'dbname' [ , [ @skipchecks = ] 'skipchecks' ]

using System.Text;                       //引用 StringBuilder 類別

...//連接資料庫

StringBuilder sb = new StringBuilder();
sb.Append("sp_attach_single_file_db @dbname=TestDB,");
sb.Append("@physname=\"C:\\TestDb.MDF\"");
SqlCommand cmd=new SqlCommand();
cmd.Connection=SqlSvrCon;
cmd.CommandText = sb.ToString();
cmd.ExecuteNonQuery();

Transact-SQL 語法：

sp_attach_single_file_db [ @dbname = ] 'dbname] , [@physname = ] 'physname'

using System.Data.SqlClient

SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder["Data Source"] = "(local)";
builder.IntegratedSecurity = true;            
builder.AttachDBFilename = @"E:\Linpo\DB\TestDB.MDF";
builder.UserInstance = false;
builder.InitialCatalog = "TestDB";