Thank you for giving a great module like Store Module.

In my project I have to use another existing database to display items.I saw that database has same data but with different deta fields.Then I can ask them to update my DNN store module database.But I have one problem.They are saving images to the database in Image format and it is not saving to a folder.Please help me to show product images through store module by that saving images.

Thank you.

Thank you very much Gilles,

Please can you give me the appropriate code for this if you never mind.It is a little bit difficult to find the relevent code to me.

Thank You
 

Thank you for the reply.I tested with external code in normal testing asp.net project to read image type data and display it as an image.Please see the following working code first.

private void Page_Load(object sender, System.EventArgs e)
        {
            //get the image id from the url
            string ImageId = Request.QueryString["img"];

            //build our query statement
            string sqlText = "SELECT img_data, img_contenttype FROM Image WHERE img_pk = " + ImageId;

            SqlConnection connection = new SqlConnection(ConfigurationSettings.AppSettings["DSN"].ToString());
            SqlCommand command = new SqlCommand(sqlText, connection);

            //open the database and get a datareader
            connection.Open();
            SqlDataReader dr = command.ExecuteReader();
            if (dr.Read()) //yup we found our image
            {
                Response.ContentType = dr["img_contenttype"].ToString();
                Response.BinaryWrite((byte[])dr["img_data"]);
            }
            connection.Close();

        }

I am using DotnetNuke 5.0 and new store module (Store_02.01.17_Source) which is downloaded from www.dotnetnuke.fr . But I could not find DotNetNuke.Store.WebControls in Website\DesktopModules\Store module .Please let me know where is it?

Second question is how can I add above code in to ImageDB.aspx to work it in DNN store module and display images. It is little bit difficult to understand this coding method and I am highly appreciate if you can help me to this issue.

Waiting for a reply.

tnx