How do you store a picture in an image column?

by

Here is a sample code for storing image to sql server : 

SqlConnection conn = new SqlConnection(connectionString);

try
{
    int imageLength = uploadInput.PostedFile.ContentLength;
    byte[] picbyte = new byte[imageLength];
    uploadInput.PostedFile.InputStream.Read (picbyte, 0, imageLength);

    SqlCommand command = new SqlCommand("INSERT INTO ImageTable (ImageFile) VALUES (@Image)", conn);
    command.Parameters.Add("@Image", SqlDbType.Image);
    command.Parameters[0].Value = picbyte;

    conn.Open();
    command.ExecuteNonQuery();
    conn.Close();
}
finally
{
    if (conn.State != ConnectionState.Closed)
    {
        conn.Close();
    }
}

NOTE : uploadInput is a file input control, to upload image file to server. The code taken from an ASP.NET application.

EDIT : Here is the insert script to an image typed column : 

INSERT INTO ImageTable (ImageColumn)

SELECT ImageColumn FROM 
OPENROWSET(BULK N'C:\SampleImage.jpg', SINGLE_BLOB) 
AS ImageSource(ImageColumn);

More Related Contents:

  1. What is User define function and how to execute that? [closed]
  2. Base64 encoding in SQL Server 2005 T-SQL
  3. Integer division in sql server
  4. Nested stored procedures containing TRY CATCH ROLLBACK pattern?
  5. How do I perform an accent insensitive compare (e with è, é, ê and ë) in SQL Server?
  6. get DATEDIFF excluding weekends using sql server
  7. How to upsert (update or insert) in SQL Server 2005
  8. SQL query to find Missing sequence numbers
  9. How to use alias column name in where clause in SQL Server
  10. How do I move files to an archive folder after the files have been processed?
  11. Convert .NET Ticks to SQL Server DateTime
  12. subquery or leftjoin with group by which one is faster?
  13. Advantages of SQL Server 2008 over SQL Server 2005? [closed]
  14. Calculating timespan with t-sql
  15. Isoweek in SQL Server 2005
  16. SQL Dynamic Pivot – how to order columns
  17. How to delete all rows from all tables in a SQL Server database?
  18. Convert SQL server datetime fields to compare date parts only, with indexed lookups
  19. How to update data in one table from corresponding data in another table in SQL Server 2005
  20. Foreign key relationship with composite primary keys in SQL Server 2005
  21. Unique Key Violation in SQL Server – Is it safe to assume Error 2627?
  22. How to recover deleted rows from SQL server table?
  23. SQL Server 2005 – using generated sequences instead of Identity columns?
  24. What good are SQL Server schemas?
  25. Problem with Renaming a Column in SQL Server
  26. SQL Server 2005 Computed Column Is Persisted
  27. SQL Server: How to permission schemas?
  28. Aggregate SQL Function to grab only the first from each group
  29. SQL Server: How to tell if a database is a system database?
  30. Multiple Select Statements using SQL Server 2005 “WITH” Statement

Leave a Comment