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
Is stringbuilder better than string?
What is ienumerable t in c#?
What is the advantage of extension method in c#?
Contrast between an interface and abstract class?
Can enum have methods c#?
What is entity framework c#?
Define delegate?
What are the collections in c#?
What is the difference between system.string and system.text.stringbuilder classes?
what is main function of alternate teamplate of datalist?
Wht executescaler method is used?
what is the meaning of Object lifetime in OOPS
how to insert the data from the grid view to database table though button click.pls send the answer to mail id suri1319@gmail.com
What do you know about device context?
Is visual c# free?