如何在sql server数据库中设置图像控件上的图像 [英] how to set image on image control from sql server database

问题描述

我想在wpf中设置图片控件上的图片。

I want to set image on picture control in wpf.

private void button7_Click(object sender, RoutedEventArgs e)
        {
            byte[] bitmapimage;
            System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection();
            conn.ConnectionString = @"Data Source=SUMIT\SQLEXPRESS;Initial Catalog=fingerdatabase;Integrated Security=True;Pooling=False";
            System.Data.SqlClient.SqlCommand cmd = conn.CreateCommand();
            cmd.Connection = conn;
            cmd.CommandText = "SELECT * FROM Table1";
            conn.Open();
            string name;
            System.Data.SqlClient.SqlDataReader dr = cmd.ExecuteReader();
            if (dr.Read())
            {
name = dataRow[0].ToString();
                 bitmapimage = dataRow[1] as byte[];
                   ImageSource bi = ByteToBitmapSource(bitmapimage);

                   PhotoImage.Source = bi;
}
public ImageSource ByteToBitmapSource(byte[] image)
        {
           
           MemoryStream strm = new MemoryStream();



            strm.Write(image, 0, image.Length);
            strm.Position = 0;
            System.Drawing.Image img = System.Drawing.Image.FromStream(strm);
            BitmapImage bi = new BitmapImage();
            bi.BeginInit();
            MemoryStream ms = new MemoryStream();
            img.Save(ms, System.Drawing.Imaging.ImageFormat.Bmp);
            ms.Seek(0, SeekOrigin.Begin);
            bi.StreamSource = ms;
            bi.EndInit();
            ImageSource imgSrc=bi as ImageSource;
            return imgSrc;
          
        }

photoImage.Sourse显示图像的宽度和高度但不显示。它显示黑屏并引发异常..

- 元数据''PhotoImage.Source.Metadata''引发了类型''System.NotSupportedException'的异常''System.Windows.Media.ImageMetadata {System.NotSupportedException}

photoImage.Sourse show width and height of image but does not displayed.It display black screen and it throw a exception..
- Metadata ''PhotoImage.Source.Metadata'' threw an exception of type ''System.NotSupportedException'' System.Windows.Media.ImageMetadata {System.NotSupportedException}

推荐答案

您好b $ b下面的文章可能会解决您的问题。



http://stackoverflow.com/questions/9564174/convert-byte-array-to-image-in-wpf [< a href =http://stackoverflow.com/questions/9564174/convert-byte-array-to-image-in-wpftarget =_ blanktitle =New Window> ^ ]

Hi Below article might solve your problem.

http://stackoverflow.com/questions/9564174/convert-byte-array-to-image-in-wpf[^]

其实我是插入空字节数组



现在插入代码是

Actually I was inserting the empty byte array

Now insert code is

Bitmap OriginalImage = new Bitmap(LiveImage.Image, LiveImage.Width, LiveImage.Height);
                Bitmap _img = new Bitmap(cropWidth, cropHeight);
                Graphics g = Graphics.FromImage(_img);
                g.DrawImage(OriginalImage, 0, 0, rect, GraphicsUnit.Pixel);   
                Img = _img;
                BitmapSource ass = BitmapSourceFromImage(Img);
                PhotoImage.Source = ass;
                byte[] bitmapimage = ImageToByte(Img);
  System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection();
                conn.ConnectionString = @"Data Source=SUMIT\SQLEXPRESS;Initial Catalog=fingerdatabase;Integrated Security=True;Pooling=False";
                System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
                cmd.Connection = conn;
                cmd.CommandText = "INSERT INTO Table1 VALUES(@fingername,@image)";
                cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@fingername", "imran"));
                cmd.Parameters.Add(new System.Data.SqlClient.SqlParameter("@image", bitmapimage));
                conn.Open();
                int rows = cmd.ExecuteNonQuery();

                conn.Close();

 private void button7_Click(object sender, RoutedEventArgs e)
        {
 System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection();
            try
            {
                byte[] bitmapimage;

                conn.ConnectionString = @"Data Source=SUMIT\SQLEXPRESS;Initial Catalog=fingerdatabase;Integrated Security=True;Pooling=False";

                System.Data.SqlClient.SqlCommand cmd = conn.CreateCommand();

                cmd.Connection = conn;

                cmd.CommandText = "SELECT * FROM Table1";

              
                conn.Open();
                string name;
                SqlDataAdapter ad = new SqlDataAdapter("SELECT * FROM Table1", conn);
                System.Data.SqlClient.SqlDataReader dr = cmd.ExecuteReader();
                if (dr.Read())
                {

                    dr.Close();
                    DataSet ds = new DataSet();
                    conn.Close();
                    ad.Fill(ds);
                    foreach (DataRow dataRow in ds.Tables[0].Rows)
                    {
                        name = dataRow[0].ToString();
                        bitmapimage = dataRow[1] as byte[];
                     MemoryStream ms = new MemoryStream(bitmapimage);
                    Image i= Image.FromStream(ms);
                         BitmapSource ass = BitmapSourceFromImage(i);
                         PhotoImage.Source = ass;
               
                }

                else
                {
                    System.Windows.MessageBox.Show("Haven't find the id in sql server");
                }
            }
            catch (NotSupportedException ex)
            {
                System.Windows.MessageBox.Show(ex.Message);
            }
            finally
            {
            
            conn.Close();
            }
}

这篇关于如何在sql server数据库中设置图像控件上的图像的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！