图片流存入mysql_图片以数据流形式存储到数据库中

private void button1_Click_1(object sender, EventArgs e)

{

using (OpenFileDialog lvse = new OpenFileDialog())

{

lvse.Title = "选择数据文件";

lvse.InitialDirectory = "";

lvse.Filter = "数据文件(*.jpg)|*.jpg";

lvse.FilterIndex = 1;

if (lvse.ShowDialog() == DialogResult.OK)

{

textBox1.Text = lvse.FileName;

//将需要存储的图片读取为数据流

FileStream fs = new FileStream(textBox1.Text, FileMode.Open, FileAccess.Read);

Byte[] byte_fs = new byte[fs.Length];

fs.Read(byte_fs, 0, Convert.ToInt32(fs.Length));

fs.Close();

//建立数据库连接

SqlConnection conn = new SqlConnection("server=DESKTOP-DJS6JVL;uid=shwy;pwd=801212;database=test");

conn.Open();

SqlCommand cmd = new SqlCommand();

cmd.Connection = conn;

cmd.CommandText = "insert into Img(strTP) values(@image_file)";

SqlParameter[] param = new SqlParameter[1];

param[0] = new SqlParameter("@image_file", SqlDbType.Image);

param[0].Value = byte_fs;

cmd.Parameters.Add(param[0]);

//执行SQL语句

cmd.ExecuteNonQuery();

conn.Close();

}

}

}

private void button2_Click(object sender, EventArgs e)

{

byte[] Data = new byte[0];

SqlConnection conn = new SqlConnection("server=DESKTOP-DJS6JVL;uid=shwy;pwd=801212;database=test");

conn.Open();

SqlCommand cmd = new SqlCommand();

cmd.Connection = conn;

cmd.CommandText = "select * from Img";

SqlDataReader sdr = cmd.ExecuteReader();

sdr.Read();

Data = (byte[])sdr["strTP"];//读取第一个图片的位流

MemoryStream mystream = new MemoryStream(Data);

//用指定的数据流来创建一个image图片

System.Drawing.Image picbImage = System.Drawing.Image.FromStream(mystream, true);

mystream.Close();

pictureBox1.Image = picbImage;

conn.Close();

}