Ado.net图像操作

Question

在我的 C# winform 应用程序中。我已成功将程序连接到MS SQL Server 2005，现在我想添加一个Image类型的新列，如何将图像插入DB并把它拿回来？在我们的业务逻辑类中我们将声明哪种数据类型变量？

Answer 1

如何将图像插入数据库并取回？

您需要以字节为单位获取图像，如下面的代码

编辑的代码示例

   private void BrowseImage(object o)
    {
        OpenFileDialog openFileDialog = new OpenFileDialog();

        // Set filter for file extension and default file extension 
        //openFileDialog.DefaultExt = ".bmp";
        //openFileDialog.Filter = "24-Bit Bitmap (.bmp)|*.bmp";
        openFileDialog.InitialDirectory = @"C://"
        openFileDialog.DefaultExt = ".jpg";
        openFileDialog.Filter =
            "BMP (*.BMP)|*.BMP|" +
            "JPEG (*.JPG; *.JPEG; *.JPE)|*.JPG;*JPEG|" +
            "GIF (*.GIF)|*.GIF|" +
            "TIFF (*.TIFF)|*.TIFF|" +
            "PNG (*.PNG)|*.PNG|" +
            "DIB (*.DIB)|*.DIB|" +
            "JFIF (*.JFIF)|*.JFIF";

        // Display OpenFileDialog by calling ShowDialog method 
        Nullable<bool> result = openFileDialog.ShowDialog();

        // Get the selected file name and display in a TextBox 
        if (result == true)
        {
            // Open document 
            string filename = openFileDialog.FileName;


            Stream stream = openFileDialog.OpenFile();
            byte[] bytes = null;
            if (stream != null && stream.CanRead)
            {

                 bytes = new byte[stream.Length];
                 stream.Read(bytes, 0, Convert.ToInt32(stream.Length));
                 stream.Close();
            }


        }
    }

在我们的业务逻辑类中我们将声明哪种数据类型变量？

您需要将图像属性定义为 Byte[] 并使用上面得到的 bytes[] 分配该属性。