C#与sql进行图片存取

 1 using System; 2 using System.Collections.Generic; 3 using System.ComponentModel; 4 using System.Data; 5 using System.Drawing; 6 using System.Linq; 7 using System.Text; 8 using System.Threading.Tasks; 9 using System.Windows.Forms;10 11 using System.IO;12 using System.Data.SqlClient;13 14 15 16 namespace 图片存取17 {18  public partial class 实例 : Form19  {20   public 实例()21   {22    InitializeComponent();23   }24   public static string str = "server=192.168.0.102;database=mysql;uid=sa;pwd=a123456";25   private void 实例_Load(object sender, EventArgs e)26   {27    28   }29 30   /// <summary>31   /// 32   /// </summary>33   /// <param name="path"></param>34   public static void InsertImg(string path)35   {36 37    byte[] bytes = File.ReadAllBytes(path);38    SqlConnection con = new SqlConnection(str);39    con.Open();40    SqlCommand cmd = new SqlCommand("insert into table_2 values(@image)",con);41    cmd.Parameters.Add("@image", SqlDbType.Image).Value = bytes;42    cmd.ExecuteNonQuery();43    con.Close();44 45    //cmd.Dispose();46 47   }48 49   public static void ReadImg(string path)50   {51    SqlConnection con = new SqlConnection(str);52    con.Open();53    SqlCommand cmd = new SqlCommand("select image from table_2 ",con);54    object scalar = cmd.ExecuteScalar();55    byte[] bytes = (byte[])scalar;56 57    File.WriteAllBytes(path, bytes);58    con.Close();59    //cmd.Dispose();60 61   }62 63   private void button1_Click(object sender, EventArgs e)64   {65    InsertImg(@"C: \Users\Administrator\Desktop\0811\3-2.jpg");66    ReadImg(@"C: \Users\Administrator\Desktop\0811\3-2-1.jpg");67   }68  }69 }

 

原文转载：http://www.shaoqun.com/a/480947.html

r标：https://www.ikjzd.com/w/1070

dmm.adult：https://www.ikjzd.com/w/2026

电霸：https://www.ikjzd.com/w/2597

1usingSystem;2usingSystem.Collections.Generic;3usingSystem.ComponentModel;4usingSystem.Data;5usingSystem.Drawing;6usingSystem.Linq;7usingSystem.Text;8usingSystem.Threading.Tasks;9usingSystem.Windows.F
bsci 认证：https://www.ikjzd.com/w/2339
贸发局：https://www.ikjzd.com/w/1621
亚马逊选品误区：卖家选品过程中要避免的选品误区讲解：https://www.ikjzd.com/home/7145
亚马逊推出的这项红利政策，你get了吗？：https://www.ikjzd.com/home/21154
用一个真实教训告诉你：做外贸，为什么千万要讲信用？ ：https://www.ikjzd.com/home/101746