///////////////////////////////////// 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();
}
}
