读/写byte[] 类型 MS SQL数据库

 //写入流
        public void Write(byte[] val)
        {
using (SqlConnection con = new SqlConnection(connectionString))
            {
                con.Open();

using (SqlCommand cmd = new SqlCommand("INSERT INTO Temp_Compress( BinData ) VALUES (@binaryValue)", con))
                {                    
                    cmd.Parameters.Add("@binaryValue", SqlDbType.VarBinary).Value = val; //此处注意写入类型
                    cmd.ExecuteNonQuery();
                }
            }
        }

//读取流
        public object Get(int id) 
        {
object ret = null;
using (SqlConnection con = new SqlConnection(connectionString))
            {
                con.Open();

using (SqlCommand cmd = new SqlCommand("Select BinData from Temp_Compress where id =@id", con))
                {

                 cmd.Parameters.Add("@id", SqlDbType.Int).Value = id;
                 SqlDataReader dr= cmd.ExecuteReader();
while (dr.Read()) 
                 {
                     ret=dr[0];
                 }
                }
            }
return ret;
        }

转载于:https://www.cnblogs.com/senion/archive/2012/03/07/2383369.html