If you are planning to create a web part that can retrieve and display a thumbnail of a random image from the picture library, then you have two options: 1) The images are stored as binary fields in the DOCS table inside the _SITE database. The field name is CONTENT. Simply connect to the database to retrieve the image. This is not the way I usually get stuff done in SPS.<\/P> 2) I would suggest you access the images via the Sharepoint namespaces. Picture libraries store their image files in the same manner as document libraries store documents, so get a reference to the picture library as an SPList class and retrieve the image from the SPListItem.File property.<\/P> <\/P> protected override void RenderWebPart(HtmlTextWriter output) string HTMLtext; output.Write(HTMLtext); If you are planning to create a web part that can retrieve and display a thumbnail of a random image from the picture library, then you have two options: 1) The images are stored as binary fields in the DOCS table inside the _SITE database. The field name is CONTENT. Simply connect to the database […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-1115","post","type-post","status-publish","format-standard","hentry"],"yoast_head":"\n
\n
\n
\n
\n
{
string url;
string caption;<\/P>
\n
try
{
SPWeb mysite=SPControl.GetContextWeb(Context);
SPListCollection lists=mysite.Lists;
foreach (SPList list in lists)
{
if (list.Title.Equals(PicLib.ToString()))
{
SPListItemCollection items=list.Items;
int rndCount=items.Count;
if (rndCount > 0)
{
int intRandom=rIndex.Next(1,rndCount);
url= items[intRandom].File.Url;
caption=items[intRandom].File.Title;
HTMLtext= “some html text”;
\n
}
else
{
output.Write(“There is no picture in the selected picture library.”);
}
}
}
}
catch(Exception e)
{
output.Write(SPEncode.HtmlEncode(e.Message.ToString()));
}
}
<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"