更改图片内容
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();
}