티스토리 뷰

using System.Data.SqlClient; using System;   namespace JGTestLibs { class Program { static void Main(string[] args) { SqlConnection conn = new SqlConnection(); conn.ConnectionString = getConnectionString("192.168.0.10","dbname","sa","password");   try { conn.Open(); Console.WriteLine("데이터베이스 연결성공.."); } catch(Exception e) { Console.WriteLine("데이터베이스 연결 실패.."); Console.WriteLine("LOG >>> "+e.ToString()); } finally { if (conn != null) { conn.Close(); } Console.WriteLine("데이터베이스 연결해제"); } } static private string getConnectionString(string ipaddr, string dbname, string id, string password) { return "Server=" + ipaddr + ";database=" + dbname + ";uid="+id+";pwd="+password+";"; } } }


댓글
댓글쓰기 폼