C# MsSQL 원격 접속 및 query 출력

view plaincopy to clipboardprint?

1. using System;  
2. using MySql.Data.MySqlClient;  
3. using System.Data.SqlClient;  
4. namespace DatabaseTest  
5. {  
6.     class Program  
7.     {  
8.   
9.         static void Main(string[] args)  
10.         {  
11.   
12.             // db를 연결한다.  
13.             connectDb();  
14.   
15.         }  
16.   
17.         static private string getConnectionString()  
18.         {  
19.             // 데이터베이스 설정한다.  
20.             return "uid=DB아이디;pwd=DB패스워드;database=데이터베이스 이름;Server=아이피,포트";  
21.         }  
22.   
23.         static private void connectDb()  
24.         {  
25.             string connectionString = getConnectionString();  
26.   
27.             using(SqlConnection connection = new SqlConnection(connectionString))  
28.             {  
29.                 try  
30.                 {  
31.                     // db를 open 한다.  
32.                     connection.Open();  
33.                     Console.WriteLine("open");  
34.   
35.                     // query문을 생성한다.  
36.                     String query = "select * from dbo.grade";  
37.                     SqlCommand cmd = new SqlCommand(query, connection);  
38.   
39.                     // 쿼리의 결과를 받아온다.  
40.                     SqlDataReader reader = cmd.ExecuteReader();  
41.   
42.                     // 쿼리의 결과를 출력한다.  
43.                     while (reader.Read())  
44.                     {  
45.                         Console.WriteLine(String.Format("{0}, {1}, {2}",  
46.                             reader[0], reader[1], reader[2]));  
47.                     }  
48.   
49.                     // db를 close  
50.                     connection.Close();  
51.   
52.                     // 리소스를 해제한다.  
53.                     connection.Dispose();  
54.   
55.                 }  
56.                 catch (Exception e)  
57.                 {  
58.                     //오류 메시지  
59.                     Console.WriteLine("error");  
60.                 }  
61.             }  
62.         }  
63.     }  
64. }  

using System; using MySql.Data.MySqlClient; using System.Data.SqlClient; namespace DatabaseTest { class Program { static void Main(string[] args) { // db를 연결한다. connectDb(); } static private string getConnectionString() { // 데이터베이스 설정한다. return "uid=DB아이디;pwd=DB패스워드;database=데이터베이스 이름;Server=아이피,포트"; } static private void connectDb() { string connectionString = getConnectionString(); using(SqlConnection connection = new SqlConnection(connectionString)) { try { // db를 open 한다. connection.Open(); Console.WriteLine("open"); // query문을 생성한다. String query = "select * from dbo.grade"; SqlCommand cmd = new SqlCommand(query, connection); // 쿼리의 결과를 받아온다. SqlDataReader reader = cmd.ExecuteReader(); // 쿼리의 결과를 출력한다. while (reader.Read()) { Console.WriteLine(String.Format("{0}, {1}, {2}", reader[0], reader[1], reader[2])); } // db를 close connection.Close(); // 리소스를 해제한다. connection.Dispose(); } catch (Exception e) { //오류 메시지 Console.WriteLine("error"); } } } } }