How to save an image into a SQL database using Enterprize Manager or SQL Query Analyzer (when designing) ?

Question

0.00/5 (No votes)

See more:

I have read an article about How to save an image into a Sql database using C# code, we have to load the image into an array of bytes first. But how we save an image when designing the database using Enterprise Manager or SQL query analyzer?
Please ask me more if you don't get what my problem is.
Thank you so much!

Posted 10-May-11 10:14am

King Boy

Updated 10-May-11 10:15am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Not Active · Accepted Answer · 2011-05-10T10:28:00

Solution 1

Images are stored as binary objects so you would some how need to get the image in binary and enter it in a query. Not totally impossible but not worth the effort either.

Posted 10-May-11 10:28am

Not Active

Comments

[no name] 10-May-11 23:20pm

What did you mean by "enter it in a query"?
I intend to save an image at design time using Enterprize Manager, for example when you want to save a name, you will type a name in the column "Name". But when saving an image, what will be entered?
I think a binary block of data doesn't like a text that can be copied and pasted, so I can't think out a solution to import an image into the column name "Image"!
Thank you so much!

[no name] 11-May-11 7:36am

A binary object is represented by a long string of data, it can be copy and pasted, however, as I said it is not worth the effort. The Enterprise Manager and SQL Query Analyzer are not hte best tools for this. You should not be entering data directly into your database, use another tool, write an application, etc.

[no name] 12-May-11 9:31am

Thank you! That's possibly a big difference between MS Access and SQL Server. Two ones are also Database Management Systems, but one can save data of image easily as an OLE object while the other can't do the same and must need a dedicated tool!