C# SQLserver数据库图片存取

最新推荐文章于 2022-11-30 15:27:16 发布

jackpanlee

最新推荐文章于 2022-11-30 15:27:16 发布

阅读量1.2k

点赞数

分类专栏： C#

本文链接：https://blog.csdn.net/ilipan/article/details/47984553

版权

C# 专栏收录该内容

94 篇文章 1 订阅

订阅专栏

   #region 数据库图片存取
        /// <summary>
        /// <strong><span style="color:#ff0000;">导入图片到数据库</span></strong>
        /// </summary>
        /// <param name="filePath"></param>
        public void Import(string filePath)
        {
            string fileName = filePath.Substring(filePath.LastIndexOf(@"\")+1, filePath.LastIndexOf(".")-filePath.LastIndexOf(@"\")-1); 
            FileStream fileStream = new FileStream(filePath, FileMode.Open);
            byte[] imageBytes = new byte[fileStream.Length];
            BinaryReader binaryReader = new BinaryReader(fileStream);
            imageBytes = binaryReader.ReadBytes(Convert.ToInt32(fileStream.Length));

            SqlConnection sqlConnection = new SqlConnection(@"data source=PANLEE-PC\MSSQLSERVER_2;initial catalog=DBImage;integrated security=true");
            sqlConnection.Open();
            SqlCommand sqlCommand=new SqlCommand();
            sqlCommand.Connection = sqlConnection;
            try
            {
                string sqlCreate = @"Create Table Portraits(
                                   学号 varchar(50),
                                   照片 image,
                                   )";
                sqlCommand.CommandText = sqlCreate;
                sqlCommand.ExecuteNonQuery();
            }
            catch { }

            sqlCommand.CommandText= "insert into Portraits (学号, 照片) values(@ID,@Image)";
            sqlCommand.Parameters.Add("Image", SqlDbType.Image);
            sqlCommand.Parameters.Add("ID", SqlDbType.VarChar);
            sqlCommand.Parameters["ID"].Value = fileName;
            sqlCommand.Parameters["Image"].Value = imageBytes;
            sqlCommand.ExecuteNonQuery();
            sqlConnection.Close();
        }
      
        /// <summary>
        //<strong>/<span style="color:#ff0000;">导出图片</span></strong>
        /// </summary>
        /// <param name="SID"></param>
        /// <returns>bitmap</returns>
        public Bitmap Export(string SID)
        {
            byte[] imagebytes = null;
            SqlConnection sqlConnection = new SqlConnection(@"data source=PANLEE-PC\MSSQLSERVER_2;initial catalog=DBImage;integrated security=true");
            sqlConnection.Open();
            SqlCommand sqlCommand = new SqlCommand("select 照片 from Portraits where 学号=@ID", sqlConnection);
            sqlCommand.Parameters.Add("ID", SqlDbType.VarChar);
            sqlCommand.Parameters["ID"].Value = SID;
            SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
            while (sqlDataReader.Read())
            {
                imagebytes = (byte[])sqlDataReader.GetValue(0);
            }
            sqlDataReader.Close();
            sqlCommand.Clone();
            sqlConnection.Close();
            MemoryStream ms = new MemoryStream(imagebytes);
            Bitmap bitmap = new Bitmap(ms);
            return bitmap;
        }
        #endregion