復制代碼 代碼如下:

using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
// Do work here.
}

復制代碼 代碼如下:

using (OleDbConnection connection = new OleDbConnection(connectionString))
{
connection.Open();
// Do work here.
}

復制代碼 代碼如下:

using (OdbcConnection connection = new OdbcConnection(connectionString))
{
connection.Open();
// Do work here.
}

復制代碼 代碼如下:

using (OracleConnection connection = new OracleConnection(connectionString))
{
connection.Open();
// Do work here.
}
OracleConnection nwindConn = new OracleConnection("Data Source=MyOracleServer;Integrated Security=yes;");
nwindConn.Open();

復制代碼 代碼如下:

stringconStr=@"provider=microsoft.Jet.OleDb.4.0;datasource=d://accessData.mdb;uid=sa;pwd=dd";

復制代碼 代碼如下:

stringconStr=@"Server=bwj;database=demo;uid=sa;pwd=";

復制代碼 代碼如下:

stringconStr=@"Provider=MSDAORA.1;Password=pwd;UserID=user_name;Data Source=link_str"