//using?System;
//using?System.Collections.Generic;
//using?System.ComponentModel;
//using?System.Data;
//using?System.Drawing;
//using?System.Linq;
//using?System.Text;
//using?System.Threading.Tasks;
//using?System.Windows.Forms;
//using?System.IO;
//using?MySql.Data.MySqlClient;

//namespace?ImageSqlTest
//{
//????public?partial?class?Form1?:?Form
//????{
//????????public?Form1（）
//????????{
//????????????InitializeComponent（）;
//????????}

//????????private?void?button1_Click（object?sender?EventArgs?e）
//????????{
//????????????FileStream?fs?=?new?FileStream（“L:\\lilan\\lilanCode\\ImageSqlTest\\1.jpg“?FileMode.Open?FileAccess.Read）;
//????????????int?bytelen?=?（int）fs.Length;
//????????????byte[]?fileBytes?=?new?byte[bytelen];
//????????????fs.Read（fileBytes?0?bytelen）;
//????????????fs.Close（）;
//????????????panel1.BackgroundImage?=?Image.FromStream（new?MemoryStream（fileBytes））;
//????????????string?strSql?=?“insert?into?image_path（idimage_path）values（@id@image_path）“;
//????????????Write（strSql?fileBytes）;
//????????????//sqlConnect（）;
//????????????showImage（）;
//????????????//if?（count?>?0）
//????????????//{
//????????????//????MessageBox.Show（“成功！“）;
//????????????//}
//????????????//else
//????????????//{
//????????????//????MessageBox.Show（“失??！“）;
//????????????//}?
//????????}

//????????//從數據庫中取出二進制流將圖片顯示到dataGridView1中
//????????private?void?sqlConnect（）
//????????{
//????????????MySqlConnection?conn?=?new?MySqlConnection（）;
//????????????string?connString?=?“Server?=?localhost;Database?=?lilan;Uid?=?root;Pwd?=?root1234“;
//????????????conn.ConnectionString?=?connString;
//????????????conn.Open（）;
//????????????Console.WriteLine（conn.State.ToString（））;
//????????????MySqlDataAdapter?da?=?new?MySqlDataAdapter（）;
//????????????MySqlCommand?cmd?=?new?MySqlCommand（“select?image_path?from?image_path?where?id?=?1“conn）;
//????????????da.SelectCommand?=?cmd;
//????????????DataSet?ds?=?new?DataSet（）;
//????????????da.Fill（ds）;?;
//????????????dataGridView1.DataSource?=?ds.Tables[0];
//????????}

//????????private?void?showImage（）
//????????{
????????????
//????????????Form2?f?=?new?Form2（）;??
//????????????f.ShowDialog（）;
//????????}

//????????//將圖片二進制寫入數據庫中
//????????public?int?i?=?1;
//????????private?void?Write（string?strSql?byte[]?imageBytes）
//????????{
//????????????string?connStr?=?“Server?=?localhost;Database?=?lilan;Uid?=?root;Pwd?=?root1234“;
????????????
//????????????int?id?=?i++;
//????????????using?（MySqlConnection?conn?=?new?MySqlConnection（connStr））
//????????????{
//????????????????????try
//????????????????????{
//????????????????????????conn.Open（）;
//????????????????????????MySqlCommand?cmd?=?conn.CreateCommand（）;
//????????????????????????cmd.CommandText?=?strSql;
//????????????????????????cmd.Parameters.AddWithValue（“@id“?id）;
//????????????????????????cmd.Parameters.Add（“@image_path“?MySqlDbType.LongBlob）.Value?=?imageBytes;

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-08-30?23:34??ImageSqlTest\
?????文件???????14140??2017-08-07?22:28??ImageSqlTest\1.jpg
?????目錄???????????0??2017-09-04?23:00??ImageSqlTest\ImageSqlTest\
?????文件?????????926??2017-08-30?20:58??ImageSqlTest\ImageSqlTest.sln
?????文件???????40448??2017-09-04?23:00??ImageSqlTest\ImageSqlTest.v11.suo
?????文件?????????189??2017-08-30?20:58??ImageSqlTest\ImageSqlTest\App.config
?????目錄???????????0??2017-09-04?23:00??ImageSqlTest\ImageSqlTest\bin\
?????目錄???????????0??2017-08-30?23:34??ImageSqlTest\ImageSqlTest\bin\Debug\
?????文件???????11776??2017-09-01?22:16??ImageSqlTest\ImageSqlTest\bin\Debug\ImageSqlTest.exe
?????文件?????????189??2017-08-30?20:58??ImageSqlTest\ImageSqlTest\bin\Debug\ImageSqlTest.exe.config
?????文件???????38400??2017-09-01?22:16??ImageSqlTest\ImageSqlTest\bin\Debug\ImageSqlTest.pdb
?????文件???????22984??2017-09-04?22:59??ImageSqlTest\ImageSqlTest\bin\Debug\ImageSqlTest.vshost.exe
?????文件?????????189??2017-08-30?20:58??ImageSqlTest\ImageSqlTest\bin\Debug\ImageSqlTest.vshost.exe.config
?????文件?????????490??2015-10-22?09:54??ImageSqlTest\ImageSqlTest\bin\Debug\ImageSqlTest.vshost.exe.manifest
?????文件??????294912??2013-05-22?17:21??ImageSqlTest\ImageSqlTest\bin\Debug\MySql.Data.dll
?????目錄???????????0??2017-09-04?23:00??ImageSqlTest\ImageSqlTest\bin\Release\
?????文件????????5489??2017-09-04?23:00??ImageSqlTest\ImageSqlTest\Form1.cs
?????文件????????3370??2017-08-30?23:13??ImageSqlTest\ImageSqlTest\Form1.Designer.cs
?????文件????????5817??2017-08-30?23:13??ImageSqlTest\ImageSqlTest\Form1.resx
?????文件????????3946??2017-09-04?23:00??ImageSqlTest\ImageSqlTest\ImageSqlTest.csproj
?????目錄???????????0??2017-08-30?23:34??ImageSqlTest\ImageSqlTest\obj\
?????目錄???????????0??2017-09-01?22:16??ImageSqlTest\ImageSqlTest\obj\Debug\
?????文件?????????867??2017-08-30?20:58??ImageSqlTest\ImageSqlTest\obj\Debug\DesignTimeResolveAssemblyReferences.cache
?????文件????????7096??2017-09-04?23:00??ImageSqlTest\ImageSqlTest\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
?????文件????????1589??2017-09-04?22:59??ImageSqlTest\ImageSqlTest\obj\Debug\ImageSqlTest.csproj.FileListAbsolute.txt
?????文件????????1033??2017-08-30?23:32??ImageSqlTest\ImageSqlTest\obj\Debug\ImageSqlTest.csproj.GenerateResource.Cache
?????文件???????15257??2017-09-01?21:06??ImageSqlTest\ImageSqlTest\obj\Debug\ImageSqlTest.csprojResolveAssemblyReference.cache
?????文件???????11776??2017-09-01?22:16??ImageSqlTest\ImageSqlTest\obj\Debug\ImageSqlTest.exe
?????文件?????????180??2017-08-30?23:26??ImageSqlTest\ImageSqlTest\obj\Debug\ImageSqlTest.Form1.resources
?????文件?????????180??2017-08-30?23:28??ImageSqlTest\ImageSqlTest\obj\Debug\ImageSqlTest.Form2.resources
?????文件???????38400??2017-09-01?22:16??ImageSqlTest\ImageSqlTest\obj\Debug\ImageSqlTest.pdb
............此處省略12個文件信息