How to display images from mysql database using asp.net

Question

I am using MySQL, I stored my images as varchar in the database, how can I display those images? Any help is appreciated.

My code:

public static DataTable GetAllMydetails()
{
    string connString = "Server=localhost;database=test;uid=root;";
    string query = "SELECT `Mydetails`.`Image`";

    MySqlDataAdapter ma = new MySqlDataAdapter(query, connString);

    DataSet DS = new DataSet();
    ma.Fill(DS);

    return DS.Tables[0];    
}

protected void Page_Load(object sender, EventArgs e)
{
   // I want to display image here on page load...//
}

Store images in database is usually more expensive than stores in the file storage. The usual approach is store the images paths in the database rather than the image. — RCalaf
– RCalaf, Commented Oct 2, 2015 at 11:27

Nikunj Soni · Accepted Answer · 2015-10-02 11:35:15Z

0

How could you store that image in varchar? Means you stored image name or converted into bytes and then stored?

Because we can't directly store image without using image data type.

So can you please be brief?

answered Oct 2, 2015 at 11:35

Nikunj Soni

2972 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to display images from mysql database using asp.net

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related