.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Insert image from Pictures List into InfoPath?

Posted By:      Posted Date: October 20, 2010    Points: 0   Category :SharePoint


I have a very simple SP2010 Pictures List with some logos.  I have another basic SP List with some product records.  When the user clicks to Edit one of the product records, I would like to display the logo from the Picture List above the InfoPath Edit Form.  Shouldn't be too difficult, should it?

What type of control do I insert in the InfoPath Form to get it to choose the correct picture?  For example, if I click on an HP Printer in my product List, the Edit box should show you the HP logo above the form, based on word 'hp' the Vendor field in the form.

Any advice? :)

I don't belive the Data Connections allow you to add the actual picture from a Picture List, do they? 





View Complete Post

More Related Resource Links

Insert image into Infopath form and save to SharePoint as PDF file


I have an InfoPath web-enabled form in MOSS 2007, that is integrated with a K2 blackpoint process for an approval workflow.

Once the form (a Purchase Order request form) has been approved in the K2 workflow process, I switch the form view to a "print-friendly" view for the requestor to view from the browser.  However, now I need to go one step further with this scenario:

1) I need to somehow insert/embed an image with the scanned-in signature of the approver (likely stored in a SP doc library) at the signature line section of my form.  Also, what are the security requirements for storing such images, but not granting all users access to these (e.g. only services accounts that need to access this for embedding into the form, etc.)?

2) Then I need to convert this final "print-friendly" view of the form (with the signature image) to a PDF document so that I can store it in SharePoint (and email it to the requestor using K2's email event capabilities).

Can anyone help me with a solution to both of these requirement, or point me to some resources for this (even 3rd party components are open-game).



Error "List does not exist" trying to insert pictures or links from Content Editor WebPart


I have put a Content Editor WebPart on a page and I'm trying to insert a picture from the Rich text editor, but whenever I try this I get this error:

List does not exist.

The page you selected contains a list that does not exist. It may have been deleted by another user.

This also happens when inserting links. When I use Fiddler I can see that the error occurs somewhere in AssetPortalBrowser.aspx and It's likely that the last location used to insert pictures and links no longer exist. So the question is how do I reset the location to point to a list on the current site, or any other list for that matter? I tried deleting and adding the WebPart on the page without any luck. Typing in a valid link in the link text box or setting the attribute "DefaultToLastUsedLocation" to "false" in the call to AssetPortalBrowser.aspx did not work either. I read the solution at http://mossipqueen.wordpress.com/2008/08/08/assetportalbrowser-error-list-does-not-exist/ (de- and re-activate Office SharePoint Server Publishing feature) but the feature is not activated on my web. Does anyone have a tip on what to do? This happens on a live SharePoint environment so there may be some restrictions as to what I can

Get pixel format, raw format, property id list and property items image in VB.net - C#.net.

n this simple article you will learn that how we can get pixel format, raw format, property id list and property items image in VB and C#.net.

Get Pixel Format:

Image consists of pixels to get the format of the pixel we have a property named pixel format. This property returns an enumeration of pixel format. This enumeration tells the pixel format.

To demonstrate make a window application. Drag one button and a picture box on form.

Now write the following code on Button click event:

How to insert Image (jpeg) into MS Word Programmatically using VB.NET


Hi there,

Can someone help me on How to insert Image (jpeg) into MS Word Programmatically using VB.NET..not C#.NET??? Sad

I could hardly find any articles for the coding. Preferably using Bookmark...can i have the sample code.



Populating a list box in InfoPath from a sql stored proc


I have an InfoPath web enabled form that gets published to a SharePoint site.  I need to add a list box to the form that gets populated with data returned from an existing call to a SQL Stored Proc.  

As the form works now, the user types in a patient id #, then clicks a button that calls the Stored Proc and returns any patients that match the given patient ID.  This part works.  

My task is to add a list box so that if more than one patient is returned , display the list box with all of these patients populated in it.

I am hoping to do this within the confines of the existing code.  The existing code looks like this:

private bool LoadPatientInformationFromDB(string patientId, string patientFirstName,
      string patientLastName, string patientMiddleInitial, string birthDate, string gender,
        string admitDate, string location)
      bool completed = false;
      //Load from DB
      SqlConnection conn = new SqlConnection(GetOrderSetDBConnectionString()); 
      //Create Form Builder
      formBuilder = new FormBuilder();
      SqlDataAdapter adpt = null;
        if (!String.IsNullOrEmpty(patientId) || !String.IsNullOrEmpty(patientFirstName) ||
          !String.IsNullOrEmpty(patientLastName) || !String.IsNullOrEmpty(patientMiddleInitial)
          || !St

SharePoint Designer: insert custom list not working anymore



Suddenly sharepoint designer decided today that it doesn't want to insert a custom list form anymore...
To be more specific, it doesn't work anymore in a site that uses the Microsoft budgeting and tracking template. In a website that uses an out of the box template, it still works.

It did work before, because I did it in other websites using the same template (it's broken there as well now).

Why oh why does SharePoint refuse to do this now?
I searched google and here on the forums, but all I could find was some issues after installing SP1, but we did that already long time ago and it was still working after that. I checked with our infrastructure guys and they didn't install new updates they say.

I also tried the solutions listed here: http://blogs.msdn.com/spdsupport/archive/2008/07/03/how-to-fix-custom-list-forms-will-not-insert-or-show-up-on-the-design-surface-of-sharepoint-designer.aspx
But they don't fix the problem.

So my problem is, I can go to Insert > SharePoint Controls > Custom List Form
I pick my list, content type and form type, I hit OK and... nothing happens.

Insert Image to SQL

Hi,   I am trying to get it right to store an avatar into SQL. I have written some stored procedures to do this.This works half and half. Problem im having is that when i execute the code I get a error stating:Implicit conversion from data type nvarchar to varbinary(max) is not allowed. Use the convert funtion. Though it still loads the data into the databse correctly? The code C# and SQL looks like the following:Stream imgStream = _inputFile.PostedFile.InputStream; int imgLen = _inputFile.PostedFile.ContentLength; string imgContentType = _inputFile.PostedFile.ContentType; string imgName = filename; byte[] imgBinaryData = new byte[imgLen]; int n = imgStream.Read(imgBinaryData, 0, imgLen); SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["TreeLizardConnectionString"]); SqlCommand cmd = new SqlCommand("UploadAvatar", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Avatar", SqlDbType.Binary); cmd.Parameters.Add("@AvatarType", SqlDbType.NVarChar, 50); cmd.Parameters.Add("@AvatarContentType", SqlDbType.NVarChar, 50); cmd.Parameters.Add("@UserID", SqlDbType.Int, 4); cmd.Parameters[0].Value = imgBinaryData; cmd.Parameters[1].Value = imgName; cmd.Parameters[2].Value = imgContentType; cmd.Parameters[3].Value = _userID; conn.Open(); cmd.ExecuteNonQuery(); con

How to read a column of a sharepoint list to a text string field of infopath form?

My infopath form used to read these email addresses from a web service and web.config file. Now i would like to get these user email addresses from a contact list in a sharepoint server. I am trying to do this without writing any codes. Here is what i have done so far: 1. Adding a new "data connection to receive data from SharePoint library or List" where i selected Email Address column of the contact list. 2. I added a new Text Field and define a new rule with "Query using a data connection" defined above. When i try to access the newly created Text field above it always return empty as if the Query attached to it did not executed at all. What did i do wrong? Is there a better way? Thank you in advance for your help.

how to in Insert database NULL if drop down list item is not selected ?

hi,   on my aspx I have the below DDL   <asp:DropDownList ID="ColorDDL" runat="server" DataSourceID="ColorObj"                                                 DataTextField="Size" DataValueField="BustId" Width="150px"                                                 AppendDataBoundItems="True">                                                    <asp:ListItem Value="-1">(Optional)</asp:ListItem>                             &n

Submitting InfoPath data to a SharePoint 2007 List

Clayton, i sure hope you get this.  I would like to let the form get published to the form library and then workflow can create the new list item with all the required metadata mapped.  if data is updated i would like for the list item data to update as well.  currently i have an infopath form that is web-enabled.  i several views based on a status field as which view to open to.  this form have drop-down fields linked to list already on the sharepoint site.  i have tried using the "Submitting Data from Infopath 2007 to Sharepoint List" and it works as designed but unfortunately i cant customize the fields.  i need a dynamic user friendly form with drop downs etc.  any suggestions?

how to insert image in to WPF windows?

Hi  Hoiw to insert image into WPF UI? Thanks

Printing list item as a infopath form

The infopath turn off the print option and Idont know how to activate it. It is a list item that desiend with the infopath desiener and have some data conections to other listes at the same site thanks Aharon

Updating an InfoPath Form Library Template breaks preexisting SharePoint List Views

When updating an InfoPath template (e.g. adding a new field), any views I have created on the library lose their filters and sorting, as if the columns on which they were built no longer exist.  Has anyone else encountered this and, if so, is there a solution? V/r Noelle

Insert Image column in External content type

Hi,   I've created an external content type. It pulls in data from SQL Server Database. I need to have the first column as an image based on the value of one of the columns. Could anyone please suggest how to add a column so represent an image in external list.   Regards, Zia

How to prevent automatic update from sharepoint list on Infopath 2007 form

Hi there, I've got an Infopath 2007 form on MOSS 2007. I have a custom list in sharepoint and the infopath form has a data connection to that list to receive data. Is there any way to prevent automatic update on the values in the form that is received from the list. I'd like the new form to have updated info received from the list. However, the old/existing forms that were created should have the data that were available at the time when the form was created. Let me know if this is not clear and I'll try to explain more. Thanks,Pman http://www.pmansLab.com/

submit infopath 2003 form to a sharepoint list

hi, is it posible to add  an infopath 2003 form to a sharepoint list, not document library but a list. and can i create views from the infopath 2003 form?

ImageList and a system image list handle

How can I have an ImageList use an image list handle of a systems image list, such as one that can be returned from SHGetFileInfo ? My image list is associated with a ListView control and this could be easily done in Win32 through the LVM_SETIMAGELIST message with an image list handle but I see no easy way of doing this with the .Net System.Windows.Forms.ImageList component.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend