How do I send an image in an image control to a SQL Database

Question

0.00/5 (No votes)

See more:

Good day fellow programmers,

Please i can save image to database using the fileUpload control. But my problem is how do i save image in an image control to database.

I want it in a way that when a user is inserting a new post to the database, the pic being displayed with an image control in the user profile will be sent to the pic column in my database.

Please can someone help me out.

Thanks.

Posted 29-Sep-14 23:04pm

felix pascal

Updated 29-Sep-14 23:13pm

Eduard Keilholz

v2

Add a Solution

4 solutions

Add a Solution

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

Eduard Keilholz · Answer 1 · 2014-09-29T23:13:00

Solution 1

Have you seen this[^] article? It pretty much covers everything you need.

Posted 29-Sep-14 23:13pm

Eduard Keilholz

Updated 29-Sep-14 23:14pm

v2

JR009 · Answer 2 · 2014-09-29T23:39:00

Solution 2

Hi felix,

there are many articles related this question on web or even on code project, look at the following link, this may help you.

How to retrive an image from sql server[^]

Posted 29-Sep-14 23:39pm

JR009

Navneet k soni · Answer 3 · 2014-09-29T23:48:00

use this in .cs file for the file uploading and saving into the specific location from where you can retrieve it

if (FileUpload1.HasFile)
{
string filename = TitleBox.Text + (maxid + 1).ToString() + FileUpload1.FileName;
FileUpload1.SaveAs(Server.MapPath("~/ListingImages/").ToString() + filename);
path = "http://ouronlineneeds.com/ListingImages/" + filename;
}

To show an image use string

string query = "SELECT Title,Logo,Descript,Address,UserName,PhoneNo,MobileNo,EmailID,Website,Confirmed,Keywords FROM Classified WHERE ListID='" + ListId + "'";
DataSet ds = Query.Select(query);

felix pascal · Answer 4 · 2014-11-30T00:13:00

Solution 4

Thanks a lo for your reply. I really appreciated it!

Posted 30-Nov-14 0:13am

felix pascal

Comments

Tomas Takac 30-Nov-14 7:50am

Please do not post your comments as a solution to your own question. Add comments to the solutions of others instead. And take time to accept the answer which is useful to you, this way you give credit to the person who helped you.

How do I send an image in an image control to a SQL Database

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

How do I send an image in an image control to a SQL Database

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us