110,568
社区成员
发帖
与我相关
我的任务
分享
//存入图片
SqlConnection conn = new SqlConnection("server=.;database=TestDB;uid=sa;pwd=1qaz@wsx#EDC");
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "insert into UserHead values(@headImg,@userId)";
cmd.Parameters.Add("@headImg", SqlDbType.Image);
cmd.Parameters.Add("@userId", SqlDbType.VarChar);
MemoryStream ms = new MemoryStream();
Image.FromFile("test.jpg").Save(ms, ImageFormat.Jpeg);
cmd.Parameters["@headImg"].Value = ms.GetBuffer();
cmd.Parameters["@userId"].Value = "test001";
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
//取出图片
SqlConnection conn = new SqlConnection("server=.;database=TestDB;uid=sa;pwd=1qaz@wsx#EDC");
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from UserHead";
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
byte[] buffer = (byte[])dt.Rows[0].ItemArray[0];//注意你获取到的byte数组是否正确
MemoryStream ms = new MemoryStream(buffer);
pictureBox1.Image = Image.FromStream(ms);
ms.Close();
你参考一下
FileStream fs = new FileStream("P1060218.jpg", FileMode.Open);//得到FileStream对象 即文件的流对象
Byte[] byrte=new Byte[fs.Length ]; //定义字节数组
fs.Read(byrte,0, Convert.ToInt32(fs.Length)); 读取流 并且存入数组byrte
fs.Close(); //关闭
然后你说 出错 是哪出错呢?