ADO.NET DB 데이터베이스 연결 Connection

///////////////////////////////////// MS-SQL ////////////////////////////

using System;

using System.Data;

using System.Data.SqlClient;

class ConsoleConnection 

{

static void Main()

{

SqlConnection conn = new SqlConnection();

conn.ConnectionString = "Server = KWANG-SIK\\SQL2005;database = PUBS; uid = sa ; pwd=p@ssw0rd!;";

//KWANG-SIK\\SQL2005

//Addr=KWANG-SIK\\SQL2005;Initial Catalog=PUBS

//data Source=KWANG-SIK\\SQL2005 ;database=PUBS

//data Source=KWANG-SIK\\SQL2005;

//  Initial Catalog=pubs; Integrated Security=True; 

    //윈도우 인증접속↑

try

{

conn.Open();

Console.WriteLine("데이터베이스 연결성공");

}

catch(Exception ex)

{

Console.WriteLine("데이터베이스 연결 실패 ");

}

finally

{

if (conn != null)

{

conn.Close();

Console.WriteLine("데이터베이스 연결해제");

}

}

}

}

///////////////////////////////////// OleDB ////////////////////////////

using System;

using System.Data;

//using System.Data.SqlClient;

using System.Data.OleDb;

class ConsoleConnection 

{

static void Main()

{

string source = @"Provider = Microsoft.jet.OLEDb.4.0; data Source=c:\\Database1.mdb";

OleDbConnection conn = new OleDbConnection(source);

// MS-SQL 방식

//SqlConnection conn = new SqlConnection();

//conn.ConnectionString = "Server = KWANG-SIK\\SQL2005;database = PUBS; uid = sa ; pwd=p@ssw0rd!;";

//KWANG-SIK\\SQL2005

//Addr=KWANG-SIK\\SQL2005;Initial Catalog=PUBS

//data Source=KWANG-SIK\\SQL2005 ;database=PUBS

try

{

conn.Open();

Console.WriteLine("데이터베이스 연결성공");

}

catch(Exception ex)

{

Console.WriteLine("데이터베이스 연결 실패 ");

}

finally

{

if (conn != null)

{

conn.Close();

Console.WriteLine("데이터베이스 연결해제");

}

}

}

}

using System;

using System.Data;

using System.Data.SqlClient;

class Class1

{

static void Main()

{

Console.WriteLine("암호를 입력하세요");

string pwd=Console.ReadLine();

string source = @"Server=KWANG-SIK\SQL2005 ;uid =sa ;pwd ="+pwd+";database = pubs ";

//1. 데이터베이스 연결

SqlConnection conn = new SqlConnection(source);

//sqlConnectin Conn = new SqlConncerton(source);

conn.Open();

//2. 명령문 만들기

string sql = "SELECT * FROM authors";

SqlCommand cmd = new SqlCommand(sql, conn);

// SqlCommand cmd = new SqlCommand();

// cmd.CommandText = sql;

// cmd.Connection = conn;

//3. 명령실행

SqlDataReader reader = cmd.ExecuteReader();

//4. 실행결과 보여주기

while (reader.Read())

{

Console.WriteLine("{0,-10},{1,-10},{2,-10}", reader[0], reader[1], reader[2]);

}

//5.데이터베이스 닫기

reader.Close();

conn.Close();

}

}