Upload image into SQL Server database

J

Jonathan Blitz

I have a form which the user uses to enter data which is saved into an SQL
Server database.

I need them to be able to upload an image as well and to have it saved in
the same or a differant table.

How do I do this?

--
Jonathan Blitz
AnyKey Limited
Israel

Tel: (972) 8 9790365

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."
 
K

Kevin Spencer

Your best bet is to store the image in your file system, and the name or
path to the image in the database. Storing images in databases is both
tricky and bad for performance, and should be avoided when possible.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Neither a follower
nor a lender be.
 
J

Jonathan Blitz

How do I build the form so that includes both an insert into an SQL Server
table and an upload?
Laso, how will I get the file name so as to insert it into the file?

--
Jonathan Blitz
AnyKey Limited
Israel

Tel: (972) 8 9790365

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."
 
J

Jonathan Blitz

I know ASP.
What I can't see is how I combine the input form with the image load form.
Can I just put the webbots created under one form and use the one submit
button?


--
Jonathan Blitz
AnyKey Limited
Israel

Tel: (972) 8 9790365

"When things seem bad
Don't worry and shout
Just count up the times
Things have worked themselves out."
 
K

Kevin Spencer

Well, you're talking about a custom web application. You would have to know
ASP, ASP.Net or some other server-side programming technology to do it.

FrontPage comes with some fairly common types of forms. You can build a data
entry form that inserts data into a database. You can create a form with
FrontPage 2003 that can upload a file. But I don't believe you can combine
the 2 without your own code.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Neither a follower
nor a lender be.
 
S

Stefan B Rusynko

See http://support.microsoft.com/default.aspx?scid=kb;en-us;288328




| I know ASP.
| What I can't see is how I combine the input form with the image load form.
| Can I just put the webbots created under one form and use the one submit
| button?
|
|
| --
| Jonathan Blitz
| AnyKey Limited
| Israel
|
| Tel: (972) 8 9790365
|
| "When things seem bad
| Don't worry and shout
| Just count up the times
| Things have worked themselves out."
| | > Well, you're talking about a custom web application. You would have to
| know
| > ASP, ASP.Net or some other server-side programming technology to do it.
| >
| > FrontPage comes with some fairly common types of forms. You can build a
| data
| > entry form that inserts data into a database. You can create a form with
| > FrontPage 2003 that can upload a file. But I don't believe you can combine
| > the 2 without your own code.
| >
| > --
| > HTH,
| > Kevin Spencer
| > .Net Developer
| > Microsoft MVP
| > Neither a follower
| > nor a lender be.
| >
| > | > > How do I build the form so that includes both an insert into an SQL
| Server
| > > table and an upload?
| > > Laso, how will I get the file name so as to insert it into the file?
| > >
| > > --
| > > Jonathan Blitz
| > > AnyKey Limited
| > > Israel
| > >
| > > Tel: (972) 8 9790365
| > >
| > > "When things seem bad
| > > Don't worry and shout
| > > Just count up the times
| > > Things have worked themselves out."
| > > | > > > Your best bet is to store the image in your file system, and the name
| or
| > > > path to the image in the database. Storing images in databases is both
| > > > tricky and bad for performance, and should be avoided when possible.
| > > >
| > > > --
| > > > HTH,
| > > > Kevin Spencer
| > > > .Net Developer
| > > > Microsoft MVP
| > > > Neither a follower
| > > > nor a lender be.
| > > >
| > message
| > > > | > > > > I have a form which the user uses to enter data which is saved into
| an
| > > SQL
| > > > > Server database.
| > > > >
| > > > > I need them to be able to upload an image as well and to have it
| saved
| > > in
| > > > > the same or a differant table.
| > > > >
| > > > > How do I do this?
| > > > >
| > > > > --
| > > > > Jonathan Blitz
| > > > > AnyKey Limited
| > > > > Israel
| > > > >
| > > > > Tel: (972) 8 9790365
| > > > >
| > > > > "When things seem bad
| > > > > Don't worry and shout
| > > > > Just count up the times
| > > > > Things have worked themselves out."
| > > > >
| > > > >
| > > >
| > > >
| > >
| > >
| >
| >
|
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top