Visual Basic NET MDI MDIMulti Document Interface Form

Visual Basic. NET MDI 만들기

MDI(Multi Document Interface)

같은 방법으로 Form 3를 추가 Text. Box 1 Button 1 Web. Browser 1

Form 3에서

SQL n n Select Insert Update delete

SQL - Where Select * from t_div 모든행이 출력된다

SQL - Where n Where의 사용은 조건에 만족되는 것만 추출 Select * from t_div where div_i_price > 10000

SQL – Order by n 정렬 n n Select * from t_div where div_i_price > 10000 order by div_i_price desc

SQL – Order by

SQL-Group by n 집단함수 사용 (count, sum, avg, min, max) n n Select count(div_no) as 수량 from t_div Select count(div_no) as 수량, div_kind as 종류 from t_div group by div_kind

SQL - HAVING n Select count(div_no) as 수량, div_kind as 종류 From t_div group by div_kind Having count(div_no) > 4

조인 (등가 조인) n n Select * from t_sp Select * from t_mk Select * from t_div Select a. sp_no, b. div_maker, b. div_model, c. mk_name From t_sp a, t_div b, t_mk c Where a. sp_div = b. div_no and a. sp_mk = c. mk_no

조인 (left join) n n Select * from t_sp Select * from t_mk Select * from t_div Select a. sp_no, b. div_maker, b. div_model From t_sp a left outer join t_div b on(a. sp_div = b. div_no)

조인 (left join) Access에서 에러 n n Select * from t_sp Select * from t_mk Select * from t_div Access에서는 Left outer Join을 한번만 사용 할 수 있음 Select a. sp_no, b. div_maker, b. div_model, c. mk_name From t_sp a left outer join t_div b on(a. sp_div = b. div_no) ledt outer join t_mk c on(a. sp_mk = c. mk_no)