Why the full image path is not stored in the database?

Question

0.00/5 (No votes)

See more:

Hey i use linq to sql for store and retrive image from database ,i use varchar(max) datatype for it.
Here is my code for save image,

C#

EventBL r = new EventBL();
 r.Banner_SignUp_Page = System.IO.Path.GetFullPath(fuBanner.FileName);
 r.Insert();

and here is for retrive it.

C#

var result1 = from a in db.EMR_INVITATIONs
 join b in db.EMR_EVENTs on a.EventID equals b.EventID
 where b.EventID == (int)Session["eventid"]


 select new
 {
 Banner = b.Banner_SignUp_Page,
 };

 var ev = result1.First();

 Image1.ImageUrl = ev.Banner;

but in database i found that whole path of image isn't store .
in database some of the path is stored,and i can't retrive image from database
If there is solution or improvement in my code
Then please let me know,
Thanks in advaance.

Posted 12-Dec-13 23:59pm

ketan italiya

Updated 13-Dec-13 0:09am

CPallini

v3

Add a Solution

Comments

Mike Meinz 13-Dec-13 6:49am

Have you used the Visual Studio debugger to determine exactly what is returned by
System.IO.Path.GetFullPath(fuBanner.FileName);
or by
HttpContext.Current.Server.MapPath(fuBanner.FileName);?

Do that and the use the Improve Question link above to let us know.

Manfred Rudolf Bihy 13-Dec-13 6:59am

Good advice! :)

ketan italiya 13-Dec-13 7:02am

ok i try with this..

ketan italiya 13-Dec-13 8:06am

no i use this method but i get wrong and empty path.
actually when i debug my code i found true path in r.insert(); method butin database i found wrong path.

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)

Manfred Rudolf Bihy · Answer 1 · 2013-12-13T00:18:00

You'd have to let us know what exactly the content of fuBanner.FileName is.
Is it a fully specified file path to an image on your disk?
Is it may be a relative URL?

In the former case you'd have to check what System.IO.Path.GetFullPath(fuBanner.FileName) returns.
In the latter case you'd need to find out the file's path in the filesystem:

C#

mappedPath = HttpContext.Current.Server.MapPath(fuBanner.FileName);

Regards,

— Manfred

BK 4 code · Answer 2 · 2013-12-13T00:09:00

Solution 1

You should call db.submitchanges() event after this code block

C#

EventBL r = new EventBL();
 r.Banner_SignUp_Page = System.IO.Path.GetFullPath(fuBanner.FileName);
 r.Insert();
db.submitchanges();

Posted 13-Dec-13 0:09am

BK 4 code

Updated 13-Dec-13 0:10am

v3

Comments

ketan italiya 13-Dec-13 6:25am

hey,no change ,i try with this,
still not saved full path.

Gaurav Makwana · Answer 3 · 2013-12-15T19:49:00

Solution 3

not need to do it just make folder in your application to save image and get full image from there
and full path is also there

Posted 15-Dec-13 19:49pm

Gaurav Makwana

bholey · Answer 4 · 2013-12-15T19:58:00

Solution 4

hi, first of all plz check the the column data type of db tabl in which u r storing the path, and then i suggest u to use .......
string filename = Server.MapPath(fuBanner.FileName);

then within insert code block ,u can save the path stored in filename variable.
try it out...

Posted 15-Dec-13 19:58pm

bholey