数据库中添加图片和获得图片

更改图片内容

FileStream fs = File.OpenRead(pSymbol.FileName);
            byte[] imageb = new byte[fs.Length];
            fs.Read(imageb, 0, imageb.Length);
            fs.Close();
            string SqlStr = "UPDATE " + PictureSymbolTableName + " SET IMAGE=@images WHERE SYMBOL=" + (pSymbol as IGisSymbol).SymbolID.ToString();
            SqlCommand pCommand = new SqlCommand(SqlStr, dbManager.DbConnection as SqlConnection);
            pCommand.Parameters.Add("@images", SqlDbType.Image).Value = imageb;
            if (pCommand.Connection.State == ConnectionState.Closed)
                pCommand.Connection.Open();
            try
            {
                pCommand.ExecuteNonQuery();
            }
            catch
            { }
            finally
            { pCommand.Connection.Close(); } 

 

获得图片

byte[] imageByte = (byte[])dr["IMAGE"];
                    using (FileStream pFileStream = new FileStream(pFileName, FileMode.Create))
                    {

                        for (int i = 0; i < imageByte.Length; i++)
                        {
                            pFileStream.WriteByte(imageByte[i]);
                        }
                        pFileStream.Flush();
                       
                    }