如何将图像插入到SQL Server 2005 [英] how to insert an image into sql server 2005

问题描述

如何从Windows应用程序将图像插入sql server 2005中

how to insert an image into sql server 2005 from windows applications

推荐答案

请检查以下文章:

使用Microsoft .NET从SQL Server存储和检索图像 [

please check the following article:

Storing and Retrieving Images from SQL Server using Microsoft .NET[^]

在数据库中创建一个Image字段.
从磁盘加载映像:Image.FromFile将为您完成.
使用SqlConnection连接到数据库:

Create a Image field in your database.
Load the Image from the disk: Image.FromFile will do it for you.
Connect to your database, with an SqlConnection:

using (SqlConnection con = new SqlConnection(myConnectionString))
   {
   con.Open();
   using (SqlCommand cmd = new SqlCommand("INSERT INTO myTable (imageColumnName) VALUES (@IM)", con))
      {
      MemoryStream ms = new MemoryStream();
      myImage.Save(ms,System.Drawing.Imaging.ImageFormat.Jpg);
      cmd.Parameters.AddWithValue("@IM", ms.ToArray());
      cmd.ExecuteNonQuery();
      }
   }

这篇关于如何将图像插入到SQL Server 2005的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！