[C# DB-DataSet] DataAdapter를 이용해서 DataSet 생성하기

1. [Create Connection and Query]

SqlConnection conn;

    conn = new SqlConnection(Server=localhost; user id=sa;password=;database=northwind");

     String sql = "Select * from Address";

2.[create DataAdapter]

SqlDataAdapter adapter = new SqlDataAdapter();

3.[set SqlCommand]

adapter.SelectCommand = new SqlCOmmand(sql, conn);

4.[create DataSet]

DataSet ds = new DataSet();

5.[fill DataSet by DataAdapter]

adapter.Fill(ds);

6.[doing jobs]

.....

7.[Close connection]….

 

Adapter

DataSet

Adpater.Fill(DataSet)