与图片的二进制数据库存储和显示
1.将图片以二进制存入数据库
2.读取二进制图片在页面显示
3.设置Image控件显示从数据库中读出的二进制图片
4.GridView中ImageField以URL方式显示图片
5.GridView显示读出的二进制图片
====================
用到的知识点：
FileSteam fs=new FileSteam(fileName,FileMode.Open,FileAccess.Read);
BinaryReader binaryReader=new BinaryReader(fs);
byte[] myByte=new byte[fs.length];
binaryReader.Read(myByte,0,Convet.ToInt32(fs.Length));
fs.close()
FileInfo fl=new FileInfo(fileName);
string imgName=fl.name;
Memorystream ms=new MemoryStream();
byte[] imgByte=(byte[])rd.GetValue(0);
Stream imgStream=new MemoryStream(imgByte);
pb.Image=Image.FromStream(imgStream);
DataView dv=(DataView)cmb.SelectedItem;
string imgId=dv.Row["id"].ToString();
============================
1.将图片以二进制存入数据库
C#
--------------------------
//保存图片到数据库
protected void Button1_Click(object sender, EventArgs e)
{
//图片路径
string strPath = "~/photo/03.JPG";
string strPhotoPath = Server.MapPath(strPath);
//读取图片
FileStream fs = new System.IO.FileStream(strPhotoPath, FileMode.Open, FileAccess.Read);
BinaryReader br = new BinaryReader(fs);
byte[] photo = br.ReadBytes((int)fs.Length);
br.Close();
fs.Close();
//存入
SqlConnection myConn = new SqlConnection("Data Source=127.0.0.1;Initial Catalog=TestDB;User ID=sa;Password=sa");
string strComm = " INSERT INTO personPhoto(personName, personPhotoPath, personPhoto) ";
strComm += " VALUES('wangwu', '" + strPath + "', @photoBinary )";
SqlCommand myComm = new SqlCommand(strComm, myConn);
myComm.Parameters.Add("@photoBinary", SqlDbType.Binary,photo.Length);
myComm.Parameters["@photoBinary"].Value = photo;
myConn.Open();
myComm.ExecuteNonQuery();
myConn.Close();
}
VB.NET
