none
Using DVDropDownList with custom SQL data source

    Question

  • I'm customising a EditForm for a list as I need to filter the options shown to the user using a SQL query (from SLAM tables).  One field is a lookup field to another Sharepoint list.

    I have copied the original EditForm, renamed it and deleted the original web part.  I inserted a Custom List Form and removed the auto created dropdownlist.  I added my SQL data control and Sharepoint DDL and linked the two.  So far so go.

    My SQL query is returning two fields, ID and Description.  ID is the relative list item ID in Sharepoint which I associate with the DataValueField of the DDL.  Description is linked to the DataTextField.

    When I enter the form parameter into the SelectedValue property of the DDL, it does not work when the form loads.  This is because it is looking for the ID value of the parameter.  How can I get/set this in Sharepoint? 


    • Modifié Tippers lundi 16 janvier 2012 14:03
    lundi 16 janvier 2012 14:00

Toutes les réponses

  • Hi,

    Thank you for your post.
    I'm trying to involve someone familiar with this topic to further look at this issue. There might be some time delay. Appreciate your patience.

    Thanks & Regards,
    Emir Liu
    TechNet Subscriber Support in forum
    If you have any feedback on our support, please contact
     
    tnmff@microsoft.com.


    Emir Liu

    TechNet Community Support

    • Marqué comme réponse Wayne Fan lundi 23 janvier 2012 07:53
    • Non marqué comme réponse Wayne Fan lundi 23 janvier 2012 07:53
    mardi 17 janvier 2012 07:09
  • Hi Emir,

    Thanks for your reply.  Have you been able to find anyone who might be able to help with this please as I could do with some ideas on a fix.

    Regards

    Chris

     

    mercredi 25 janvier 2012 12:41
  • Hi Chris,

    Thank you for your post,  I apologize for the delay.  One thing that I notice that could be causing issues with the list forms is that you are deleting the original list form web part from the edit form page.  Best practices require that you set the original web part to hidden and place the custom list form below it.

    I tested database dropdown functionality in my own environment by creating a simple SQL database and adding a SQL data source and data list dropdown.  I was able to select the options successfully.  I wanted to verify that  when you mentioned SLAM tables in your initial post that you were referring to the codeplex solution referred to at http://slam.codeplex.com/ .  I have not been able to test with this yet, so it could possibly be an issue related to it.

    Gregg


    MSFT

    jeudi 1 mars 2012 22:29
    Modérateur