1. Connection 생성 및 Open
string conStr = "Server=localhost;user id=sa;password=net$!;database=northwind";
SqlConnection con = new SqlConnection(conStr);
con.Open();
-------------------------------------------------------------------------------------------------------
2. DataAdapter 생성
SqlDataAdapter adapter = new SqlDataAdapter();
-------------------------------------------------------------------------------------------------------
3. SqlCommand 할당
string query = "select * from Address";
adapter.SelectCommand = new SqlCommand(query, con);
-------------------------------------------------------------------------------------------------------
4. DataSet 생성
DataSet ds = new DataSet();
-------------------------------------------------------------------------------------------------------
5. DataAdapter를 이용해서 DataSet을 채우기
adapter.Fill(ds);
-------------------------------------------------------------------------------------------------------
6. 작업수행
-------------------------------------------------------------------------------------------------------
7. 연결닫기
con.Close();
