Save byte[] into a SQL Server database from C#

by

You should be able to write something like this:

string queryStmt = "INSERT INTO dbo.YourTable(Content) VALUES(@Content)";

using(SqlConnection _con = new SqlConnection(--your-connection-string-here--))
using(SqlCommand _cmd = new SqlCommand(queryStmt, _con))
{
   SqlParameter param = _cmd.Parameters.Add("@Content", SqlDbType.VarBinary);
   param.Value = YourByteArrayVariableHere;

   _con.Open();
   _cmd.ExecuteNonQuery();
   _con.Close();
}

Using Linq-to-SQL, you’d write something like this:

using(YourDataContextHere ctx = new YourDataContextHere())
{
   SomeClassOfYours item = new SomeClassOfYours();

   item.ByteContent = (your byte content here);

   ctx.SomeClassOfYourses.InsertOnSubmit(item);
   ctx.SubmitChanges();
}

That will insert your byte[] into a column Content of type VARBINARY in your SQL Server table as a byte stream, which you can read back 1:1 again later on.

More Related Contents:

  1. 'Must declare the scalar variable "@thisuser".' [closed]
  2. How can I solve error in connection string in C#?
  3. summing values of a column based on id [closed]
  4. ExecuteReader requires an open and available Connection. The connection’s current state is Connecting
  5. How to get last inserted id?
  6. MSSQL Error ‘The underlying provider failed on Open’
  7. What are the pros and cons to keeping SQL in Stored Procs versus Code [closed]
  8. How to monitor SQL Server table changes by using c#?
  9. How to create bitmap from byte array?
  10. WPF Image to byte[]
  11. What represents a double in sql server?
  12. How to catch SQLServer timeout exceptions
  13. Use of SqlParameter in SQL LIKE clause not working
  14. Is there any way to embed power bi reports and dashboards in vb.net or C# desktop application with sql server 2008 database?
  15. How can I retrieve a list of parameters from a stored procedure in SQL Server
  16. What’s the fastest way to bulk insert a lot of data in SQL Server (C# client)
  17. DateTime’s representation in milliseconds?
  18. How to compare two images using byte arrays
  19. What’s the best way to test SQL Server connection programmatically?
  20. Entity Framework 6 transaction rollback
  21. Using SqlDataAdapter to insert a row
  22. Add WHERE clauses to SQL dynamically / programmatically
  23. How to pass string array in SQL parameter to IN clause in SQL
  24. Horrible performance using SqlCommand Async methods with large data
  25. “The operation is not valid for the state of the transaction” error and transaction scope
  26. How do I safely store database login and password in a C# application?
  27. Passing array to a SQL Server Stored Procedure
  28. Bulk Insert Sql Server millions of record
  29. Loading PictureBox Image From Database
  30. EF Core takes a lot of time, sometimes, to perform SELECT query

Leave a Comment