using?System;
using?System.Data;
using?System.Data.SqlClient;
using?System.Drawing;
using?System.IO;
using?System.Windows.Forms;

namespace?testPP
{
????public?partial?class?Frnpp?:?Form
????{
????????public?Frnpp（）
????????{
????????????InitializeComponent（）;
????????}

????????private?void?bttInsertPP_Click（object?sender?EventArgs?e）
????????{
????????????insertPP（）;
????????????bttStart_Click（null?null）;
????????}
????????public?static?string?conmmsy?=?“server=SERVER6060?;?user?id?=?yoti;?pwd?=?yoti1202;?database?=?yoti“;
????????DataTable?dtPP?=?new?DataTable（）;//用來存放從數據庫里查詢出來的圖片數據
????????private?static?int?i?=?0;//用來存放顯示第幾張圖片
????????private?static?string?id?=?““;//存放圖片的ID
????????//插入圖片
????????public?void?insertPP（）
????????{
????????????openFileDialog1.Filter?=?“*jpg|*.JPG|*.GIF|*.GIF|*.BMP|*.BMP“;
????????????SqlConnection?con?=?new?SqlConnection（conmmsy）;
????????????con.Open（）;
????????????try
????????????{
????????????????if?（openFileDialog1.ShowDialog（）?==?DialogResult.OK）
????????????????{
????????????????????string?path?=?openFileDialog1.FileName;//文件路徑????????????????????
????????????????????//創建文件流，path參數是文件路徑??
????????????????????FileStream?fs?=?new?FileStream（path?FileMode.Open）;
????????????????????int?streamLength?=?（int）fs.Length;??//獲取文件流的長度。??
????????????????????byte[]?image?=?new?byte[streamLength];????//聲明字節數組，用于保存圖片文件??
????????????????????fs.Read（image?0?streamLength）;????//把圖片文件轉換成為字節數組保存??
????????????????????fs.Close（）;
????????????????????//插入Sql語句，@img是Sql語句參數。??
????????????????????string?sql?=?string.Format（“insert?imagetable?values（@img）“?image）;
????????????????????SqlCommand?com?=?new?SqlCommand（sql?con）;?//con是一個有效的連接對象??
???????????????????????????????????????????????????????????????//為命令對象添加參數，注意參數的類型??
????????????????????com.Parameters.Add（new?SqlParameter（“img“?SqlDbType.Binary?image.Length
????????????????????ParameterDirection.Input?true?0?0?null?DataRowVersion.Default?image））;
????????????????????com.ExecuteNonQuery（）;???//執行??
????????????????????MessageBox.Show（“插入成功“）;
????????????????}
????????????}
????????????catch?（Exception?ex）
????????????{
????????????????MessageBox.Show（ex.Message?“插入圖片不成功“）;
????????????}
????????????finally
????????????{
????????????????con.Close（）;
????????????}
????????}

???????
????????//顯示圖片
????????public?void?showPP（int?i）
????????{
????????????SqlConnection?con?=?new?SqlConnection（conmmsy）;?//實例化SQLconnection類。連接數據庫
????????????con.Open（）;
????????????try
????????????{
????????????????string?SQLstr?=?“select?IDimagetxt?from?imagetable“;??//設置SQL語句????????????????????????????????
????????????????SqlDataAdapter?ada?=?new?SqlDataAdapter（SQLstr?con）;//建立SQL語句與數據庫的連接
????????????????DataSet?ds?=?new?DataSet（）;??//實例化Datatable類
????????????????ada.Fill（ds）;?//添加SQL并且執行????
????????????????dtPP?=?ds.Tables[0];
????????????????if?（dtPP.Rows.Count>=1）
????????????????{
????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

????..A..H.?????48640??2016-10-24?15:05??testPP\.vs\testPP\v14\.suo

?????文件????????189??2016-10-23?15:54??testPP\App.config

?????文件??????15360??2016-12-14?11:59??testPP\bin\Debug\testPP.exe

?????文件????????189??2016-10-23?15:54??testPP\bin\Debug\testPP.exe.config

?????文件??????28160??2016-12-14?11:59??testPP\bin\Debug\testPP.pdb

?????文件??????22696??2016-12-14?11:59??testPP\bin\Debug\testPP.vshost.exe

?????文件????????189??2016-10-23?15:54??testPP\bin\Debug\testPP.vshost.exe.config

?????文件????????490??2015-10-22?09:54??testPP\bin\Debug\testPP.vshost.exe.manifest

?????文件???????9973??2016-10-24?14:14??testPP\Frpp.cs

?????文件??????11071??2016-10-24?13:42??testPP\Frpp.Designer.cs

?????文件???????6392??2016-10-24?13:42??testPP\Frpp.resx

?????文件???????1464??2016-10-23?17:45??testPP\obj\Debug\DesignTimeResolveAssemblyReferences.cache

?????文件???????7188??2016-10-24?11:14??testPP\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件??????????0??2016-10-23?15:54??testPP\obj\Debug\TemporaryGeneratedFile_036C0B5B-1481-4323-8D20-8F5ADCB23D92.cs

?????文件??????????0??2016-10-23?15:54??testPP\obj\Debug\TemporaryGeneratedFile_5937a670-0e60-4077-877b-f7221da3dda1.cs

?????文件??????????0??2016-10-23?15:54??testPP\obj\Debug\TemporaryGeneratedFile_E7A71F73-0F8D-4B9B-B56E-8E70B10BC5D3.cs

?????文件????????735??2016-12-14?11:59??testPP\obj\Debug\testPP.csproj.FileListAbsolute.txt

?????文件???????1124??2016-10-24?13:42??testPP\obj\Debug\testPP.csproj.GenerateResource.Cache

?????文件???????2384??2016-10-23?16:06??testPP\obj\Debug\testPP.csprojResolveAssemblyReference.cache

?????文件??????15360??2016-12-14?11:59??testPP\obj\Debug\testPP.exe

?????文件????????180??2016-10-24?13:42??testPP\obj\Debug\testPP.Frnpp.resources

?????文件??????28160??2016-12-14?11:59??testPP\obj\Debug\testPP.pdb

?????文件????????180??2016-10-24?11:15??testPP\obj\Debug\testPP.Properties.Resources.resources

?????文件????????533??2016-10-24?11:15??testPP\Program.cs

?????文件???????1320??2016-10-23?15:54??testPP\Properties\AssemblyInfo.cs

?????文件???????2825??2016-10-23?15:54??testPP\Properties\Resources.Designer.cs

?????文件???????5612??2016-10-23?15:54??testPP\Properties\Resources.resx

?????文件???????1093??2016-10-23?15:54??testPP\Properties\Settings.Designer.cs

?????文件????????249??2016-10-23?15:54??testPP\Properties\Settings.settings

?????文件???????3905??2016-10-24?11:15??testPP\testPP.csproj

............此處省略15個文件信息