資源簡介
通過二進制數據流的方式,讀寫圖片,把圖片存入數據庫,再從數據庫讀取出來顯示

代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.SqlClient;
using?System.IO;
namespace?ReaderWriterPic
{
????public?partial?class?FormPic?:?Form
????{
????????private?SqlConnection?objcon;
????????private?SqlDataAdapter?objAdapter;
????????private?DataSet?objset;
????????public?FormPic()
????????{
????????????InitializeComponent();
????????????objcon?=?new?SqlConnection(“server=.;database=ImagePic;uid=sa;pwd=“);
????????????objcon.Open();
?????????
????????}
????????private?void?btnbrowse_Click(object?sender?EventArgs?e)
????????{
????????????//瀏覽事件
????????????if(openFilePic.ShowDialog()==DialogResult.OK)
????????????{
????????????????this.txtpath.Text?=?openFilePic.FileName;
????????????????pictureShow.Image?=?Image.FromFile(txtpath.Text);
????????????}
????????}
????????//保存事件
????????private?void?btnSave_Click(object?sender?EventArgs?e)
????????{
????????????string?PicName?=?txtpath.Text;
????????????//定義圖片變量格式
????????????System.Drawing.Imaging.ImageFormat?objFormat?=?null;
????????????//獲取文件的擴展名
????????????switch(PicName.Substring(PicName.IndexOf(‘.‘)+1).ToLower())
????????????{
????????????????case??“bmp“:
????????????????????objFormat?=?System.Drawing.Imaging.ImageFormat.Bmp;
????????????????????break;
????????????????case?“jpg“:
????????????????????objFormat?=?System.Drawing.Imaging.ImageFormat.Jpeg;
????????????????????break;
????????????????case?“gif“:
????????????????????objFormat?=?System.Drawing.Imaging.ImageFormat.Gif;
????????????????????break;??????
????????????}
????????????//創建數據流對象
????????????MemoryStream?memory?=?new?MemoryStream();
????????????//定義圖片變量,保存圖片
????????????Image?objImage?=?Image.FromFile(PicName);
????????????objImage.Save(memory?objFormat);
????????????//獲取不具有擴展名的名字
????????????string?notFile?=?Path.GetFileNameWithoutExtension(PicName);
????????????//調用方法,插入到數據庫中
????????????PicDAO?objdao?=?new?PicDAO();
????????????objdao.PicSave(notFilememory);
????????}
????????private?void?FormPic_Load(object?sender?EventArgs?e)
????????{
????????????//查詢圖片
????????????try?
????????????{
????????????????string?select?=?“select?*?from?Picter“;
????????????????objAdapter?=?new?SqlDataAdapter(selectobjcon);
????????????????objset?=?new?DataSet();
????????????????objAdapter.Fill(objset“picter“);
????????????????for?(int?i?=?0;?i?????????????????{
????????????????????cboPic.Items.Add(objset.Tables[0].Rows[i][1].ToString());
????????????????}
????????????}catch(SqlException?ew)
????????????????{
????????????????????Console.WriteLine(ew.Message);
????????????????}
????????}
????????private?void?btnExit_Click(object?sender?EventArgs?e)
????????{
????????????//退出
????????????Application.Exit();
????????}
????????private?void?btnOpen_Click(object?sender?EventArgs?e
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????2031616??2008-04-23?14:25??讀寫圖片\ReaderWriterPic\ImagePic_Data.MDF
?????文件????1310720??2008-04-23?14:25??讀寫圖片\ReaderWriterPic\ImagePic_Log.LDF
?????文件??????24576??2009-01-02?00:57??讀寫圖片\ReaderWriterPic\ReaderWriterPic\bin\Debug\ReaderWriterPic.exe
?????文件??????34304??2009-01-02?00:57??讀寫圖片\ReaderWriterPic\ReaderWriterPic\bin\Debug\ReaderWriterPic.pdb
?????文件???????5632??2007-08-29?13:39??讀寫圖片\ReaderWriterPic\ReaderWriterPic\bin\Debug\ReaderWriterPic.vshost.exe
?????文件???????3649??2008-04-18?17:11??讀寫圖片\ReaderWriterPic\ReaderWriterPic\Form1.cs
?????文件???????5951??2008-04-18?16:40??讀寫圖片\ReaderWriterPic\ReaderWriterPic\Form1.Designer.cs
?????文件???????6013??2008-04-18?16:40??讀寫圖片\ReaderWriterPic\ReaderWriterPic\Form1.resx
?????文件????????842??2008-04-18?16:47??讀寫圖片\ReaderWriterPic\ReaderWriterPic\obj\Debug\ReaderWriterPic.csproj.GenerateResource.Cache
?????文件??????24576??2009-01-02?00:57??讀寫圖片\ReaderWriterPic\ReaderWriterPic\obj\Debug\ReaderWriterPic.exe
?????文件????????180??2008-04-18?16:47??讀寫圖片\ReaderWriterPic\ReaderWriterPic\obj\Debug\ReaderWriterPic.FormPic.resources
?????文件??????34304??2009-01-02?00:57??讀寫圖片\ReaderWriterPic\ReaderWriterPic\obj\Debug\ReaderWriterPic.pdb
?????文件????????180??2008-04-18?14:55??讀寫圖片\ReaderWriterPic\ReaderWriterPic\obj\Debug\ReaderWriterPic.Properties.Resources.resources
?????文件????????326??2009-01-02?00:58??讀寫圖片\ReaderWriterPic\ReaderWriterPic\obj\ReaderWriterPic.csproj.FileList.txt
?????文件???????2038??2009-01-02?01:13??讀寫圖片\ReaderWriterPic\ReaderWriterPic\PicDAO.cs
?????文件????????476??2008-04-18?14:19??讀寫圖片\ReaderWriterPic\ReaderWriterPic\Program.cs
?????文件???????1190??2008-04-18?14:18??讀寫圖片\ReaderWriterPic\ReaderWriterPic\Properties\AssemblyInfo.cs
?????文件???????2884??2008-04-18?14:18??讀寫圖片\ReaderWriterPic\ReaderWriterPic\Properties\Resources.Designer.cs
?????文件???????5612??2008-04-18?14:18??讀寫圖片\ReaderWriterPic\ReaderWriterPic\Properties\Resources.resx
?????文件???????1098??2008-04-18?14:18??讀寫圖片\ReaderWriterPic\ReaderWriterPic\Properties\Settings.Designer.cs
?????文件????????249??2008-04-18?14:18??讀寫圖片\ReaderWriterPic\ReaderWriterPic\Properties\Settings.settings
?????文件???????3274??2008-04-18?15:26??讀寫圖片\ReaderWriterPic\ReaderWriterPic\ReaderWriterPic.csproj
?????文件????????934??2008-04-18?14:18??讀寫圖片\ReaderWriterPic\ReaderWriterPic.sln
?????文件??????16896??2009-01-02?01:18??讀寫圖片\ReaderWriterPic\ReaderWriterPic.suo
?????文件??????38037??2007-04-18?14:00??讀寫圖片\圖片的讀寫.rar
?????目錄??????????0??2009-03-02?11:48??讀寫圖片\ReaderWriterPic\ReaderWriterPic\obj\Debug\Refactor
?????目錄??????????0??2009-03-02?11:48??讀寫圖片\ReaderWriterPic\ReaderWriterPic\obj\Debug\TempPE
?????目錄??????????0??2009-03-02?11:48??讀寫圖片\ReaderWriterPic\ReaderWriterPic\bin\Debug
?????目錄??????????0??2009-03-02?11:48??讀寫圖片\ReaderWriterPic\ReaderWriterPic\obj\Debug
?????目錄??????????0??2009-03-02?11:48??讀寫圖片\ReaderWriterPic\ReaderWriterPic\bin
............此處省略8個文件信息
評論
共有 條評論