C# Save byte[] into a SQL Server database

save

view plaincopy to clipboardprint?

1. string queryStmt = "INSERT INTO dbo.YourTable(Content) VALUES(@Content)";  
2.   
3. using(SqlConnection _con = new SqlConnection(--your-connection-string-here--))  
4. using(SqlCommand _cmd = new SqlCommand(query, _con))  
5. {  
6.    SqlParameter param = _cmd.Parameters.Add("@Content", SqlDbType.VarBinary);  
7.    param.Value = YourByteArrayVariableHere;  
8.   
9.    _con.Open();  
10.    _cmd.ExecuteNonQuery();  
11.    _con.Close();  
12. }  

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
view plaincopy to clipboardprint?
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();  
                    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();