How to save images in SQL Sever?

Question

0.00/5 (No votes)

See more:

How can I save Bitmap Images in SQL Server? My front end is vb.net...After the modification in image in the PictureBox,I need to save it in the Database..Please help me..

Posted 25-Jan-13 16:46pm

Member 9753615

Add a Solution

4 solutions

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)

Sergey Alexandrovich Kryukov · Answer 1 · 2013-01-25T16:56:00

It's unbearable to answer this question again and again; it's too often asked. Please, do this:
http://www.codeproject.com/search.aspx?doctypeid=5&q=SQL+%28images+OR+image%29[^].

Now, it looks like you modify images in PictureBox. Why, on Earth? You can do it, but it's totally pointless. This control is nothing but a shortcut used to do something very simple: show a static image on screen. If you do anything even a bit more complex, you simply do double work; and a computer also does double work. Control is not an image.

I'll tell you what to do instead. You should either render image in the control directly, or do in on a bitmap, and draw a bitmap of some control. It could be a custom control derived from System.Windows.Forms.Control, or Panel, or even Form. How? I'll explain that. Please see my past answers:
How do I clear a panel from old drawing[^],
draw a rectangle in C#[^],
Append a picture within picturebox[^].

See also:
Drawing Lines between mdi child forms[^],
capture the drawing on a panel[^],
What kind of playful method is Paint? (DataGridViewImageCell.Paint(...))[^],
How to speed up my vb.net application?[^].

—SA

Prosan · Answer 2 · 2013-01-25T21:42:00

Solution 2

look this images in sql[^]

Posted 25-Jan-13 21:42pm

Prosan

hari301 · Answer 3 · 2013-01-26T20:26:00

Solution 3

view this link and study it.. Surely it will help for you...

http://programtechn.blogspot.in/[^]

Posted 26-Jan-13 20:26pm

hari301

Ram A Singh · Answer 4 · 2013-01-27T06:34:00

VB

Dim eid As Integer
        If bm.Count = 0 Then
            eid = 1
        Else
            bm.Position = bm.Count - 1
            eid = CInt(TextBox2.Text) + 1
        End If
        bm.AddNew()
        TextBox2.Text = eid.ToString
        TextBox2.Enabled = False

        Dim OpenFileDialog1 As New OpenFileDialog
        With OpenFileDialog1

            .CheckFileExists = True

            .ShowReadOnly = False

            .Filter = "All Files|*.*|Bitmap Files (*)|*.bmp;*.gif;*.jpg"

            .FilterIndex = 2

            If .ShowDialog = DialogResult.OK Then

                ' Load the specified file into a PictureBox control.

                pbNewImage.Image = Image.FromFile(.FileName)

Read more: http://ram-a-singh.blogspot.com/2011/10/how-to-add-image-in-ms-access-database.html

How to save images in SQL Sever?

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0