111,126
社区成员
发帖
与我相关
我的任务
分享winfrom中上传图片
我希望实现的是将图片保存在一个文件夹中，然后在数据库中建立一个图片字段，字段类型是Vchar,然后我们将图片的路径保存在字段里。
...全文
请发表友善的回复…
发表回复
tangfengme01 2012-05-21
- 打赏
- 举报
用using System.IO;来操作文件，存入数据库用这样的代码吧
//图片存入数据库的代码方法
MemoryStream stream = new MemoryStream();
pic.Image.Save(stream, System.Drawing.Imaging.ImageFormat.Bmp);
byte[] photo= stream.ToArray();
stream.Close();
stream = null;
string t = System.DateTime.Now.ToLongDateString();
string stemp = "insert into a_jl( nl,xm,xl,mm,gzjl,sj,pic,ttime) values('" + _nl + "','" + _xm + "','" + _xl + "','" + _mm + "','" + _gzjl + "','" + _sj + "',@pic1,'" + t + "')";
OleDbCommand cmd = new OleDbCommand(stemp,conn.conn());
cmd.Parameters.Add("@pic1", OleDbType.VarBinary, photo.Length).Value = photo;
//图片存入数据库的代码方法
MemoryStream stream = new MemoryStream();
pic.Image.Save(stream, System.Drawing.Imaging.ImageFormat.Bmp);
byte[] photo= stream.ToArray();
stream.Close();
stream = null;
string t = System.DateTime.Now.ToLongDateString();
string stemp = "insert into a_jl( nl,xm,xl,mm,gzjl,sj,pic,ttime) values('" + _nl + "','" + _xm + "','" + _xl + "','" + _mm + "','" + _gzjl + "','" + _sj + "',@pic1,'" + t + "')";
OleDbCommand cmd = new OleDbCommand(stemp,conn.conn());
cmd.Parameters.Add("@pic1", OleDbType.VarBinary, photo.Length).Value = photo;
