ADO.NET 접속

using System;

using System.Collections.Generic;

using System.Text;

using System.Data;

using System.Data.SqlClient;

namespace ConsoleApplication51

{

class Program

{

static void Main(string[] args)

{

string source = "server=KWANG-SIK\\sql2005 ; database= pubs ; uid=sa; pwd=p@ssw0rd!";

SqlConnection conn = new SqlConnection(source);

try

{

conn.Open();

Console.WriteLine("접속성공");

}

catch (Exception)

{

Console.WriteLine("접속실팽");

}

finally

{

if(conn != null)

Console.WriteLine("접속해제");

           conn.Close(); 

        Console.WriteLine("끝");

}

}

}

}