Question
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
And when I run the search I get this result
Here is my asp code
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.
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started