Hello,

I am new to DNN and would like to create a C# module that shows some pictures in a grid. I was able to create one using the template from the Starter Kit /Version 4.8.0/ and connect it to the MS SQL database so that it displays some text info. I am not sure what is the best way to display the images.

This thread has an example of how to accomplish this task, but it connects directly to the database and I would like to use the DNN DAL instead.

Any help is appreciated!

Eis Karlsson

Thanks for answering.

The images are stored as byte arrays in the database. Some examples show that I need additional information like the type of image and the size of the array. I would like to use just one column in the data table. Is that possible?

Anyway did you see this link in my post above. It seems like that is one way to pull the images from the database. It looks like to me though that a direct connection to the database is used, instead of the DNN Data Access Layer. I wonder if this layer can be used. I will take a look at Michael Washington's tutorials, but I used a book to connect the database to the module and the grid. The code is something like:

 MyCompanyController objMyComps = new MyCompanyController();

List<MyCompanyInfo> colMyCompanys;

colMyCompanys = objMyCompanys.GetMyCompanys(ModuleId);

Grid1.DataSource = colMyCompanys;

Grid1.DataBind();

It works fine for text data, but I am not sure where to place the code for retrieving the images. Should I add a http handler, aspx page or just use the module control? 

I think I figured it out:

I placed the code in an aspx page in the module folder and removed the <form> tags from it. The codebehind is shown here:

ViewImage.aspx.cs

{insert the necessary using statements here}

namespace MyCompany.Modules.MyModule

{

    public partial class ViewImage : System.Web.UI.Page

    {

        protected void Page_Load(object sender, EventArgs e)

        {

            int imageId;

            int moduleId;

            if ((Request.QueryString["imageId"] == null) || (Request.QueryString["moduleId"] == null))

                return;

            if (!(int.TryParse(Request.QueryString["imageId"].ToString(), out imageId)))

                return;

            if (!(int.TryParse(Request.QueryString["moduleId"].ToString(), out moduleId)))

                return;

            writeImage(moduleId, imageId);

        }

        protected void writeImage(int _ModuleID, int _ItemID)

        {

            MyModuleController objMyModulePerson = new MyModuleController();

            MyModuleInfo MyModulePerson = new MyModuleInfo();

            MyModulePerson = objMyModulePerson.GetMyModule(_ModuleID, _ItemID);

            if (MyModulePerson.CreatedByUser > 0)

            {

                if (MyModulePerson.Picture.Length != 0)

                    Response.BinaryWrite(MyModulePerson.Picture);

            }

        }

    }

}

The code for the grid, which is pretty simple is in the module ascx file. I am not going to post it, because I used a third-party component, but if you are interested you can follow this link.

Hope this helps somebody.