0

I am trying to insert a mdi file in a SQL Server 2008 table.

Do you know how can I do this?

My table has the following structure

Create table employées 
(
     Id_employee int,
     Mdi_employee image
)
marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
dba2015
  • 127
  • 1
  • 4
  • 13
  • 1
    `image` data type will be removed in a future version of SQL Server. Avoid using this data type in new development work, and plan to modify applications that currently use it. Use `varbinary(max)` instead. [See details here](http://msdn.microsoft.com/en-us/library/ms187993.aspx) – marc_s Apr 04 '15 at 12:32

1 Answers1

0

Convert your MDI file into Byte format and then use normal query to insert that image.

For More information : C# Resize jpg image, convert to byte and save into database using varbinary

Community
  • 1
  • 1
Mahadev
  • 856
  • 1
  • 17
  • 44