大文件（比如图片文件）怎么从SQL Server数据库里面存取？

Question

http://dotnet.aspx.cc/ShowDetail.aspx?id=EY1XLDYV-PIDF-43LO-1WFL-FMY5ALE1F635

Answer 1

http://search.csdn.net/Expert/topic/2520/2520344.xml?temp=.6790125
http://community.csdn.net/Expert/topic/3401/3401647.xml?temp=.2353327
http://community.csdn.net/Expert/topic/3627/3627971.xml?temp=.539364

Answer 2

http://blog.csdn.net/alexzhang00/archive/2004/10/17/140317.aspx

Answer 3

在msdn 里搜索 "从数据库中获取 BLOB 值"
你就都看到了。

Answer 4

转为byte类型后存入Image字段。
byte[] imagebytes=null;
FileStream fs=new FileStream(Image_path,FileMode.Open);
BinaryReader br=new BinaryReader(fs);
imagebytes=br.ReadBytes(br.Length);
SqlParameter parInput22=cmd.Parameters.Add("@员工图片",SqlDbType.Image);
parInput22.Direction=ParameterDirection.Input;
cmd.Parameters["@员工图片"].Value=imagebytes;
cmd.ExecuteNonQuery();
数据库中操作图片
http://support.microsoft.com/default.aspx?scid=kb;EN-US;309158
把任意类型的文件保存到SQL Server
http://dotnet.aspx.cc/ShowDetail.aspx?id=EY1XLDYV-PIDF-43LO-1WFL-FMY5ALE1F635