C# Save byte[] into a SQL Server database

save string queryStmt = "INSERT INTO dbo.YourTable(Content) VALUES(@Content)"; using(SqlConnection _con = new SqlConnection(--your-connection-string-here--)) using(SqlCommand _cmd = new SqlCommand(query, _con)) { SqlParameter param = _cmd.Parameters.Add("@Content", SqlDbType.VarBinary); param.Value = YourByteArrayVariableHere; _con.Open(); _cmd.ExecuteNonQuery(); _con.Close(); }

load
                    SqlCommand test_scmd = new SqlCommand("SELECT dbo.YourTable FROM Content");
                    test_scmd.Connection = SQL_Connection;
                    SqlDataReader test_sdr = test_scmd.ExecuteReader();

                    if (test_sdr.Read())
                    {
                        byte[] test_object = test_sdr["Content"] as byte[];
                    }
                    test_sdr.Close();