[20기 이창진]mssql에 이미지 업로드 및 다운로드

데이터베이스 테이블 <v:shapetype id=_x0000_t75 stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o:preferrelative="t" o:spt="75" coordsize="21600,21600"><v:stroke joinstyle="miter"></v:stroke><v:formulas><v:f eqn="if lineDrawn pixelLineWidth 0"></v:f><v:f eqn="sum @0 1 0"></v:f><v:f eqn="sum 0 0 @1"></v:f><v:f eqn="prod @2 1 2"></v:f><v:f eqn="prod @3 21600 pixelWidth"></v:f><v:f eqn="prod @3 21600 pixelHeight"></v:f><v:f eqn="sum @0 0 1"></v:f><v:f eqn="prod @6 1 2"></v:f><v:f eqn="prod @7 21600 pixelWidth"></v:f><v:f eqn="sum @8 21600 0"></v:f><v:f eqn="prod @7 21600 pixelHeight"></v:f><v:f eqn="sum @10 21600 0"></v:f></v:formulas><v:path o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"></v:path><o:lock aspectratio="t" v:ext="edit"></o:lock></v:shapetype> <o:p style="TEXT-ALIGN: left"><img src="https://t1.daumcdn.net/cfile/cafe/14367B244CBE8FB23D" class="tx-daum-image" style="CLEAR: none; FLOAT: none" actualwidth="393" hspace="1" width="393" vspace="1" border="0" id="A_14367B244CBE8FB23D027A"/>  Title : 제목 ImageFile : 이미지 파일 ImageSize : 이미지 파일 크기   저장프로시저 -      UpLoad <o:p style="TEXT-ALIGN: left"><o:p style="TEXT-ALIGN: left"><img src="https://t1.daumcdn.net/cfile/cafe/111117264CBE8FBD31" class="tx-daum-image" style="CLEAR: none; FLOAT: none" actualwidth="421" hspace="1" width="421" vspace="1" border="0" id="A_111117264CBE8FBD31436D"/>  -      DownLoad <o:p style="TEXT-ALIGN: left"><img src="https://t1.daumcdn.net/cfile/cafe/175B23284CBE8FF231" class="tx-daum-image" style="CLEAR: none; FLOAT: none" actualwidth="386" hspace="1" width="386" vspace="1" border="0" id="A_175B23284CBE8FF23162C1"/>  -      GetTitle  <o:p style="TEXT-ALIGN: left"><img src="https://t1.daumcdn.net/cfile/cafe/1669B7274CBE900133" class="tx-daum-image" style="CLEAR: none; FLOAT: none" actualwidth="391" hspace="1" width="391" vspace="1" border="0" id="A_1669B7274CBE900133F8C6"/> 테이블에 존재하는 제목들을 모두 불러온다     <DB실습 순서>   1.    프로젝트 생성 <v:shapetype id=_x0000_t32 filled="f" path="m,l21600,21600e" o:spt="32" coordsize="21600,21600" o:oned="t"><v:path o:connecttype="none" fillok="f" arrowok="t"></v:path><o:lock v:ext="edit" shapetype="t"></o:lock></v:shapetype><v:shape id=_x0000_s1026 style="MARGIN-TOP: 67.05pt; Z-INDEX: 1; MARGIN-LEFT: 155.7pt; WIDTH: 98.8pt; POSITION: absolute; HEIGHT: 0.85pt; flip: y" type="#_x0000_t32" strokecolor="red" o:connectortype="straight"></v:shape>    <o:p style="TEXT-ALIGN: left"><img src="https://t1.daumcdn.net/cfile/cafe/115149284CBE901A3E" class="tx-daum-image" style="CLEAR: none; FLOAT: none" actualwidth="606" hspace="1" width="606" vspace="1" border="0" id="A_115149284CBE901A3E135A"/>           2.    기본 폼에 메뉴스트립 추가 <o:p style="TEXT-ALIGN: left"><img src="https://t1.daumcdn.net/cfile/cafe/1243EC254CBE902727" class="tx-daum-image" style="CLEAR: none; FLOAT: none" actualwidth="612" hspace="1" width="612" vspace="1" border="0" id="A_1243EC254CBE90272728B0"/>    3.    UpLoad폼과 DownLoad폼 추가  <o:p style="TEXT-ALIGN: left"><img src="https://t1.daumcdn.net/cfile/cafe/174B9C284CBE903356" class="tx-daum-image" style="CLEAR: none; FLOAT: none" actualwidth="553" hspace="1" width="553" vspace="1" border="0" id="A_174B9C284CBE903356EE7D"/> 4.    UpLoadForm에 컨트롤들 추가 <o:p style="TEXT-ALIGN: left"><img src="https://t1.daumcdn.net/cfile/cafe/1411B0264CBE903E1E" class="tx-daum-image" style="CLEAR: none; FLOAT: none" actualwidth="310" hspace="1" width="310" vspace="1" border="0" id="A_1411B0264CBE903E1ECCB9"/>  5.    UpLoadForm.cs의 UpLoadForm.Designer.cs선택 <v:shape id=_x0000_s1027 style="MARGIN-TOP: 175.85pt; Z-INDEX: 2; MARGIN-LEFT: 71.15pt; WIDTH: 98.8pt; POSITION: absolute; HEIGHT: 0.85pt" type="#_x0000_t32" strokecolor="red" o:connectortype="straight"></v:shape>  <o:p style="TEXT-ALIGN: center"><img src="https://t1.daumcdn.net/cfile/cafe/11524B284CBE904A4A" class="tx-daum-image" style="CLEAR: none; FLOAT: none" actualwidth="250" hspace="1" width="250" vspace="1" border="0" id="A_11524B284CBE904A4AFE74"/> 6.    UpLoadForm.Designer.cs의 가장 밑쪽에 추가 <v:shape id=_x0000_s1029 style="MARGIN-TOP: 116.5pt; Z-INDEX: 4; MARGIN-LEFT: 8.35pt; WIDTH: 245.3pt; POSITION: absolute; HEIGHT: 1.7pt; flip: y" type="#_x0000_t32" strokecolor="red" o:connectortype="straight"></v:shape>  <o:p style="TEXT-ALIGN: left"><img src="https://t1.daumcdn.net/cfile/cafe/200430264CBE90601B" class="tx-daum-image" style="CLEAR: none; FLOAT: none" actualwidth="386" hspace="1" width="386" vspace="1" border="0" id="A_200430264CBE90601BAF0A"/> 7.    UpLoadForm.Designer.cs의 Init….함수에 추가 <v:shape id=_x0000_s1028 style="MARGIN-TOP: 114.85pt; Z-INDEX: 3; MARGIN-LEFT: 21.75pt; WIDTH: 273.8pt; POSITION: absolute; HEIGHT: 0px" type="#_x0000_t32" strokecolor="red" o:connectortype="straight"></v:shape> <o:p style="TEXT-ALIGN: left"><img src="https://t1.daumcdn.net/cfile/cafe/1371BC274CBE907318" class="tx-daum-image" style="CLEAR: none; FLOAT: none" actualwidth="444" hspace="1" width="444" vspace="1" border="0" id="A_1371BC274CBE9073189D99"/>  8.    이미지 검색 버튼 <o:p style="TEXT-ALIGN: left"><img src="https://t1.daumcdn.net/cfile/cafe/196FA5274CBE908615" class="tx-daum-image" style="CLEAR: none; FLOAT: none" actualwidth="385" hspace="1" width="385" vspace="1" border="0" id="A_196FA5274CBE90861598FE"/>  9.    bitmap파일을 DataBase에 저장해야하기 때문에 GetImage함수를 만들어서 FileStream을 통해 byte[]에 대입하여 처리하도록 한다  <o:p style="TEXT-ALIGN: left"><img src="https://t1.daumcdn.net/cfile/cafe/147148274CBE909538" class="tx-daum-image" style="CLEAR: none; FLOAT: none" actualwidth="543" hspace="1" width="543" vspace="1" border="0" id="A_147148274CBE9095383702"/> FileStream개요 : <A href="http://msdn.microsoft.com/ko-kr/library/bb933993.aspx">http://msdn.microsoft.com/ko-kr/library/bb933993.aspx</A>   10. 업로드 버튼을 눌렀을 때  <o:p style="TEXT-ALIGN: left"><img src="https://t1.daumcdn.net/cfile/cafe/151117264CBE90A532" class="tx-daum-image" style="CLEAR: none; FLOAT: none" actualwidth="542" hspace="1" width="542" vspace="1" border="0" id="A_151117264CBE90A53252B7"/> 데이터베이스에 연결하여 제목과 이미지를 업로드 한다   11. DownLoadForm 컨트롤 추가  <o:p style="TEXT-ALIGN: left"><img src="https://t1.daumcdn.net/cfile/cafe/112E91244CBE90B34A" class="tx-daum-image" style="CLEAR: none; FLOAT: none" actualwidth="427" hspace="1" width="427" vspace="1" border="0" id="A_112E91244CBE90B34A856E"/> 12. DownLoadForm_Load이벤트 메소드 생성  <o:p style="TEXT-ALIGN: left"><img src="https://t1.daumcdn.net/cfile/cafe/163269254CBE90F340" class="tx-daum-image" style="CLEAR: none; FLOAT: none" actualwidth="538" hspace="1" width="538" vspace="1" border="0" id="A_163269254CBE90F340F785"/> 데이터베이스에 저장되어있는 제목 리스트를 불러온다.   13. 리스트박스에 목록을 선택하였을 때   <img src="https://t1.daumcdn.net/cfile/cafe/204BBD284CBE910B56" class="tx-daum-image" style="CLEAR: none; FLOAT: none" actualwidth="541" hspace="1" width="541" vspace="1" border="0" id="A_204BBD284CBE910B56A69B"/>   14. 다운로드 버튼을 눌렀을 때  <o:p style="TEXT-ALIGN: left"><img src="https://t1.daumcdn.net/cfile/cafe/125097284CBE91352D" class="tx-daum-image" style="CLEAR: none; FLOAT: none" actualwidth="608" hspace="1" width="608" vspace="1" border="0" id="A_125097284CBE91352D4C0C"/> 위치를 지정하여 저장하게 된다   완성된 UpLoadForm <o:p style="TEXT-ALIGN: left"><img src="https://t1.daumcdn.net/cfile/cafe/135F6F284CBE914012" class="tx-daum-image" style="CLEAR: none; FLOAT: none" actualwidth="304" hspace="1" width="304" vspace="1" border="0" id="A_135F6F284CBE914012F69C"/>  완성된 DownLoadForm   <img src="https://t1.daumcdn.net/cfile/cafe/1705AC264CBE914E3C" class="tx-daum-image" style="CLEAR: none; FLOAT: none" actualwidth="421" hspace="1" width="421" vspace="1" border="0" id="A_1705AC264CBE914E3C27F8"/>