111,097
社区成员




byte[] fileByte= File.ReadAllBytes("C:\1.jpg");
Image img=Image.FromFile(@"C:\1.jpg");
byte[] imageByte=ImageToByteArr(img);
private byte[] ImageToByteArr(Image img)
{
using (System.IO.MemoryStream ms = new System.IO.MemoryStream())
{
img.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
ms.Position = 0;
byte[] imageBytes = new byte[ms.Length];
ms.Read(imageBytes, 0, imageBytes.Length);
return imageBytes;
}
}
if (byte1.Length != byte2.Length)
{
return false;
}
else
{
for (Int64 i = 0; i < byte1.Length; i++)
{
if (byte1[i] != byte2[i])
{
return false;
}
}
return true;
}
public static byte[] GetImageBytes(Bitmap bmp)
{
byte[] data = new byte[bmp.Width * bmp.Height];
BitmapData bmpData = bmp.LockBits(new Rectangle(0, 0, bmp.Width, bmp.Height)
, ImageLockMode.Read, bmp.PixelFormat);
Marshal.Copy(bmpData.Scan0, data, 0, data.Length);
bmp.UnlockBits(bmpData);
return data;
}
Image img = Image.FromFile(@"c:\test.jpg");
MemoryStream ms = new MemoryStream();
img.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
byte[] myData = ms.ToArray();
SqlConnection cn = new SqlConnection("Data Source=(local);Initial Catalog=utscadadb;Integrated Security=SSPI; User Id=sa;Password=ut2001;");
SqlCommand cmd = new SqlCommand("Update Table1 Set data = (@data) where id =3", cn);
cmd.Parameters.Add("@file ", SqlDbType.VarChar).Value = "d:\\test.jpg";
cmd.Parameters.Add("@data ", SqlDbType.Image).Value = myData;
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
Image img = Image.FromFile(@"c:\test.jpg");
MemoryStream ms = new MemoryStream();
img.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
byte[] myData = ms.ToArray();