Â¥Ö÷

ÔõÑù°Ñ´æÔÚÊý¾Ý¿âµÄͼƬÊý¾Ý<binary>ת»¯³ÉImageBox¿ÉÒÔÓÐµÄ SqlCommand cmd;    cmd = new SqlCommand("INSERT INTO photodata (ID, data) " +     "VALUES (@CustomerID, @CompanyName)", cnn);    cmd.Parameters.Add("@CustomerID", SqlDbType.Int, 5);    cmd.Parameters.Add("@CompanyName", SqlDbType.Image, 69812);    cmd.Parameters[0].Value= 1;    cmd.Parameters[1].Value=b;      byte[]    b=(byte[])dr["data"]; ÔõÑù°Ñ b ±ä³É bt=new Bitmap()£»bitmap()¹¹Ô캯Êý¿ÉÒÔÓõģ¿£¿ Stream ÀàÐÍ£¡ Ðֵܰïæ°¡£¬Ð¡µÜ¸Ð¼¤²»¾¡£¡£¡    Êղؠ  ·ÖÏí   ¶¥(0)

	µÚ2Â¥

ÕâÊÇMSDNµÄÀý×Ó¡£ÒÔºóÒªÑø³É²é°ïÖúµÄÏ°¹ßŶ¡£ SqlConnection pubsConn = new SqlConnection("Data Source=localhost;Integrated Security=SSPI;Initial Catalog=pubs;"); SqlCommand logoCMD = new SqlCommand("SELECT pub_id, logo FROM pub_info", pubsConn); FileStream fs;                          // Writes the BLOB to a file (*.bmp). BinaryWriter bw;                        // Streams the BLOB to the FileStream object. int bufferSize = 100;                   // Size of the BLOB buffer. byte[] outbyte = new byte[bufferSize];  // The BLOB byte[] buffer to be filled by GetBytes. long retval;                            // The bytes returned from GetBytes. long startIndex = 0;                    // The starting position in the BLOB output. string pub_id = "";                     // The publisher id to use in the file name. // Open the connection and read data into the DataReader. pubsConn.Open(); SqlDataReader myReader = logoCMD.ExecuteReader(CommandBehavior.SequentialAccess); while (myReader.Read()) {   // Get the publisher id, which must occur before getting the logo.   pub_id = myReader.GetString(0);     // Create a file to hold the output.   fs = new FileStream("logo" + pub_id + ".bmp", FileMode.OpenOrCreate, FileAccess.Write);   bw = new BinaryWriter(fs);   // Reset the starting byte for the new BLOB.   startIndex = 0;   // Read the bytes into outbyte[] and retain the number of bytes returned.   retval = myReader.GetBytes(1, startIndex, outbyte, 0, bufferSize);   // Continue reading and writing while there are bytes beyond the size of the buffer.   while (retval == bufferSize)   {     bw.Write(outbyte);     bw.Flush();     // Reposition the start index to the end of the last buffer and fill the buffer.     startIndex += bufferSize;     retval = myReader.GetBytes(1, startIndex, outbyte, 0, bufferSize);   }   // Write the remaining buffer.   bw.Write(outbyte, 0, (int)retval - 1);   bw.Flush();   // Close the output file.   bw.Close();   fs.Close(); } // Close the reader and the connection. myReader.Close(); pubsConn.Close();

	µÚ3Â¥

ºÜ¸Ðл¥ÉϵĻش𣡠ÎÒÏë´ÓÊý¾Ý¿âÀï²éµ½ÕâЩÊý¾Ý£¬ÈÃËüÖ±½ÓÔڿؼþPictureBoxlÀïÏÔʾ µ«£¬ÎÒ²»Ïë±£´æÄÇЩ´ÓÊý¾Ý¿âÖеÄ<binary>Êý¾Ý£¡¡£ PictureBox.Image,ÐèÒªÒ»¸öImageÀàÐ͵ÄÊý¾Ý£¬¶ø£¬ÔÚÊý¾Ý¿âÖж¨ÒåµÄ×ֶα¾À´¾ÍΪImageµÄÀàÐÍ£¡£¨Ó¦¸Ã˵PictureBox.iImage=(Image)bytesÊÇ¿ÉÒԵģ© ÎÒ²»ÖªµÀʲôֱ½ÓÀûÓÃÊý¾Ý¿âµÄÊý¾Ý¿ÉÒÔÈÃPictureBox.Image¿ÉÒÔÓõģ¡ public void init(string url)   {      try    {                   bmap=new Bitmap(url);    }    catch(Exception e)    {     MessageBox.Show(e.Message);    }       pictureBox1.Image=(Image) bmap;   }