Sample for Displaying Images from the Database using Dynamic Data

Wöchentliche Rundablage: LINQ to SQL, System.AddIns, WPF, C#, OpenID, SharePoint, ASP.NET AJAX | Code-Inside Blog

Mon, 28 Jan 2008 22:41:55 GMT

PingBack from http://code-inside.de/blog/2008/01/28/wchentliche-rundablage-linq-to-sql-systemaddins-wpf-c-openid-sharepoint-aspnet-ajax/

Project templates just got bigger

Marcin On ASP.NET — Thu, 28 Feb 2008 05:11:49 GMT

One of the new things we are working on in ASP.NET is not directly connected to the new and improved

re: Sample for Displaying Images from the Database using Dynamic Data

Justice — Fri, 02 May 2008 09:43:21 GMT

I really liked your post. I found a couple of issues. They could just be me, but these are the issues I ran into, and the solutions (probably not the greatest, but functioning). 1) I had issues with uniqueidentifiers for PKs

2) I had an issue with empty Data / no cache key

Thank you for the cool post. Keep it up!

//LinqImageHelper

object value = null;

if (member.Type == typeof(Guid))

{

value = new Guid(primarykeyvalue);

}

else

{

value = Convert.ChangeType(primarykeyvalue, member.Type, CultureInfo.InvariantCulture);

}

// DBImage_Edit

if (MetadataAttributes.TryGetValue("ImageFormat", out metadata))

{

string tablename = MetaMember.MetaTable.Name;

string primarykeyname = MetaMember.MetaTable.IdentityMetaMembers[0].Name;

string primarykeyvalue = DataBinder.GetPropertyValue(DataItem, primarykeyname).ToString();

string cachekey = string.Format("{0}:{1}:{2}", tablename, DataField, primarykeyvalue);

ViewState["CacheKey"] = cachekey;

//check if image exists

if (DataValue == null || metadata == null)

{

return;

}

SavedDataValue = DataValue;

//metadata

int width = 100;

int height = 100;

bool displayinedit = true;

IDictionary<string, object> metadatadict = (IDictionary<string, object>)metadata;

width = (int)metadatadict["Width"];

height = (int)metadatadict["Height"];

displayinedit = (bool)metadatadict["DisplayInEdit"];

//display picture if in edit mode,

if (TemplateMode == DynamicTemplateMode.EditItemTemplate && displayinedit)

{

//set image properties

PlaceHolderImage.Visible = true;

ImageEdit.ImageUrl = "~/ImageHandler.ashx?table=" + tablename + "&column=" + DataField + "&pkv=" + primarykeyvalue + "&width=" + width.ToString() + "&height=" + height.ToString();

}

re: Sample for Displaying Images from the Database using Dynamic Data

Bryan Reynolds — Wed, 14 May 2008 00:20:07 GMT

Are you planning on making a generic file handler?

re: Sample for Displaying Images from the Database using Dynamic Data

Jeff — Mon, 19 May 2008 20:41:29 GMT

the MetadataAttribues.TryGetValue is causing an error for me.

Dynamic Data DbImage SampleUpdated

Scott Hunter — Tue, 17 Jun 2008 12:07:47 GMT

I posted a sample back in January on how to display images from databases or the file system using Dynamic

re: Sample for Displaying Images from the Database using Dynamic Data

Andrei — Thu, 17 Jul 2008 23:51:15 GMT

I cannot compile DbImageAPI in VS 2008 (without SP1) with 3.5 Beta framework.

I got the following errors:

The type or namespace name 'BaseMetadataAttribute' could not be found (are you missing a using directive or an assembly reference?)

The type or namespace name 'ValidationAttribute' could not be found (are you missing a using directive or an assembly reference?

What could be wrong?

Nice example,

Thank you.

re: Sample for Displaying Images from the Database using Dynamic Data

chosenek — Fri, 24 Oct 2008 15:36:46 GMT

Nice one Scott. But its made for extension CTP? I got SP1 and can't compile it. It needs 3.6 extension. But in sp1 is 3.5.

re: Sample for Displaying Images from the Database using Dynamic Data

Carlos Pinto — Mon, 10 Nov 2008 15:28:38 GMT

I work on VB and in my case I only see the original images in DB, but updating and inserting new ones, not work.

Ps- You had any version in VB?

re: Sample for Displaying Images from the Database using Dynamic Data

Johua — Tue, 17 Mar 2009 21:36:21 GMT

Can anyone tell me where can I find ImageHandler.ashx

re: Sample for Displaying Images from the Database using Dynamic Data

Peter — Sun, 22 Mar 2009 13:29:32 GMT

How do we fix the code i cant seem to find

BaseMetadataAttribute and this is the only tutorial around..

re: Sample for Displaying Images from the Database using Dynamic Data

Rob — Fri, 02 Oct 2009 22:31:22 GMT

This is great!

Once files are attached as dbimage or linked to the filesystem for instance PDF, do you know a way to call that PDF into an RDLC report as an image frame along with other data fields from the table(s)?

Thank you!

re: Sample for Displaying Images from the Database using Dynamic Data

Ralf — Tue, 08 Dec 2009 14:06:50 GMT

Maybe you build this example with CTP release?

I try to update the example with SP1 and the hints from

http://www.asp.net/(S(ywiyuluxr3qb2dfva1z5lgeg))/downloads/3.5-SP1/Readme/

but it still wont compile.

Here are my errors:

The type or namespace name 'BaseMetadataAttribute' could not be found (are you missing a using directive or an assembly reference?) ImageUrlAttribute.cs DbImageAPI

The type or namespace name 'ValidationAttribute' could not be found (are you missing a using directive or an assembly reference?) ImageFormat.Attribute.cs DbImageAPI

Kind regards

Ralf