31.ADO.NET - 6가지 패턴

입력 :
Connection -> Command -> Parameter추가 -> ExecuteNonQuery()

출력 :
Connection -> Command -> DataaAdapter -> DataSet -> Fill() -> Grid컨트롤에바인딩

상세 :
Connection -> Command -> DataReader() -> Read() -> 일반컨트롤에 바인딩
 
수정/삭제 : 입력 패턴과 동일 :
Connection -> Command -> Parameter추가 -> ExecuteNonQuery()

검색 :
Connection -> Command -> DataAdapter -> DataSet -> DataTable -> Dataview -> RowFilter속성 ->
Grid컨트롤에 바인딩

집계 :
Connection -> Command -> ExecuteSaclar() : 단일값 출력