How to store image file in Sql server database?
Answer Posted / guest
Yes, you can store image files in SQL Server. In fact, SQL
Server has a datatype called image for exactly this
purpose. It will store any binary data up to 2 GB in size.
There are many ways to get image files into your image
column. Among the easiest is the Textcopy utility located
in the Program FilesMicrosoft SQL ServerMSSQLBinn
directory. Use the command "textcopy /?" to get the command
line syntax for this utility.
Another way to get image files in and out of SQL Server is
to write your own program using ADO or ADO.Net, or create
an ActiveX dll that can be called by SQL Server's sp_OA*
extended stored procedures.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
How to use the sreamReader class to read form a text file?
What is the delegates in c#?
What is the compiler of c#?
what is IFormatable
How do you escape c#?
What is private class in c#?
How many dimensions can an array have?
what is a enumeration in c#
What is difference between il and dll ?
What is difference between struct and class in c#?
What are the uses of delegates in c#?
What is system console writeline in c#?
Can you create partial delegates and enumerations?
What is the difference between proc. Sent by val and by sub?
How to find the current application file path while runtime?