StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
8262742
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-11-24T21:42:37.360
FavoriteCount
0
LastActivityDate
2011-11-24T22:08:59.827
LastEditDate
2011-11-24T22:08:59.827
LastEditorUserId
282144
OwnerUserId
282144
ParentId
6650842
PostTypeId
2
Score
8
ViewCount
0
LastEditorDisplayName
text
Body
I build an index of your "cid:"s first: <pre><code>private const string CidPattern = "cid:"; private static HashSet<int> BuildCidIndex(string html) { var index = new HashSet<int>(); var pos = html.IndexOf(CidPattern, 0); while (pos > 0) { var start = pos + CidPattern.Length; index.Add(start); pos = html.IndexOf(CidPattern, start); } return index; } </code></pre> Then you need a replace function that replaces the cids based on your index <pre><code>private static void AdjustIndex(HashSet<int> index, int oldPos, int byHowMuch) { var oldIndex = new List<int>(index); index.Clear(); foreach (var pos in oldIndex) { if (pos < oldPos) index.Add(pos); else index.Add(pos + byHowMuch); } } private static bool ReplaceCid(HashSet<int> index, ref string html, string cid, string path) { var posToRemove = -1; foreach (var pos in index) { if (pos + cid.Length < html.Length && html.Substring(pos, cid.Length) == cid) { var sb = new StringBuilder(); sb.Append(html.Substring(0, pos-CidPattern.Length)); sb.Append(path); sb.Append(html.Substring(pos + cid.Length)); html = sb.ToString(); posToRemove = pos; break; } } if (posToRemove < 0) return false; index.Remove(posToRemove); AdjustIndex(index, posToRemove, path.Length - (CidPattern.Length + cid.Length)); return true; } </code></pre> so now, you can check your attachments <pre><code>FileAttachment[] attachments = null; var index = BuildCidIndex(sHTMLCOntent); if (index.Count > 0 && item.Attachments.Count > 0) { var basePath = Directory.GetCurrentDirectory(); attachments = new FileAttachment[item.Attachments.Count]; for (var i = 0; i < item.Attachments.Count; ++i) { var type = item.Attachments[i].ContentType.ToLower(); if (!type.StartsWith("image/")) continue; type = type.Replace("image/", ""); var attachment = (FileAttachment)item.Attachments[i]; var cid = attachment.ContentId; var filename = cid + "." + type; var path = Path.Combine(basePath, filename); if(ReplaceCid(index, ref sHTMLCOntent, cid, path)) { // only load images when they have been found attachment.Load(path); attachments[i] = attachment; } } } </code></pre> Additional to that: instead of calling <code>attachment.Load</code> right away, and pass the path to the image directly, you could link to another script, where you pass the <code>cid</code> as a parameter and then check back with the exchange for that image; then the process of loading the image from exchange does not block the html cid replacement and could lead to loading the page faster, since the html can send to the browser sooner. PS: Code is not tested, just so you get the idea! EDIT Added the missing <code>AdjustIndex</code> function. EDIT 2 Fixed small bug in AdjustIndex
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POEWS + Exchange 2007: Retrieve inline images
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USesskar
UserOwnerUserId
1. USesskar
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POEWS + Exchange 2007: Retrieve inline images
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTAcceptedByOriginator
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTBountyClose
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.