conn.Open();
String str = "";
SqlCommand cmd = new SqlCommand("select top 1 photo from PicTestZyz", conn);
SqlDataReader reader = cmd.ExecuteReader();
byte[] bt;
while (reader.Read())
{
for (int i = 0; i < reader.FieldCount; i++)
{
bt = (byte[])reader[i];
str = Encoding.ASCII.GetString(bt);
str = str.Substring(str.IndexOf("BM"), str.Length - str.IndexOf("BM"));
bt = Encoding.ASCII.GetBytes(str);
MemoryStream buf = new MemoryStream(bt);
Bitmap mp = (Bitmap)Bitmap.FromStream(buf, true, true);
mp = RePic(mp, mp.Width, mp.Height);
mp.Save(@"C:\Data\a.jpg", System.Drawing.Imaging.ImageFormat.jpeg);
this.pictureBox1.Image = mp;
}
}
