Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How to get image to display in Web page, asp, sql. I'm fairly new to how sql works and I am learning. I'm working on

How to get image to display in Web page, asp, sql.

I'm fairly new to how sql works and I am learning. I'm working on an assignment where we have to search for movies on a database. I have the database search working but I am unsure how to load images onto my sql database. I looked online and most examples used 'bulk' but it does not work for me, I asked my professor and he said that I had to use a textbox but I do not fully understand it. An explanation or example could help.I'll attach a screenshot of my sql table that I'm working with. Am i able to add the image using query commands? or would I have to do it in asp?

My table code islike this

image text in transcribed

image text in transcribed

And when I run the search I get this result

image text in transcribed

Here is my asp code

image text in transcribed

I was told to use a map path but not sure if I am using it right as it returns a syntax error. I am running this on a winscp server and the directory looks like this.

image text in transcribed

Any help or code correction would be appreciated.

CREATE TABLE content MovieID int identity(1,1) PRIMARY KEY, MovieTitle varchar(250) NOT NULL DateChecked date, CheckedOut varchar(1 MovieDescription varchar (250), ImageLocation varchar (250)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

=+ d. a professor deciding how much to prepare for class

Answered: 1 week ago

Question

=+ a. a family deciding whether to buy a new car

Answered: 1 week ago