regarding insert image in mysql from vb.net

Question

0.00/5 (No votes)

See more:

how i can insert the image into mysql database.

some people insert image into database.
some people insert image path into database

which is the best store method in the database

i'm using ODBC connection for mysql database

i don't know how to code for insert image into database

i'm really need this

Posted 2-Oct-10 21:53pm

babu.sadhish

Updated 4-Oct-10 21:53pm

thatraja

v2

Add a Solution

3 solutions

Solution 2

For Storing images in database vs storing image path in database + store images in seperate folder

Link 1[^]

Link 2[^]

Posted 4-Oct-10 21:57pm

thatraja

Solution 3

create a table ....

SQL

CREATE TABLE [dbo].[imgtable](
    [id] [int] NULL,
    [img] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

insert vb.net code

VB

Dim cmd As New SqlCommand("insert into imgtable (id,img) values ( @id,@img)", cnn)
cmd.Parameters.AddWithValue("@id", id)
cmd.Parameters.AddWithValue("@img", content)
cmd.ExecuteNonQuery()

full source ... Insert image into Database

Kerry

Posted 27-Mar-14 21:34pm

kerrymarke

Add a Solution

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

Abhinav S · Accepted Answer · 2010-10-02T22:56:00

Solution 1

See here[^].

Posted 2-Oct-10 22:56pm

Abhinav S

Comments

Dalek Dave 5-Oct-10 4:56am

Good Link

regarding insert image in mysql from vb.net

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

regarding insert image in mysql from vb.net

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us