.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

xml secondary data source used for drop down selection how do I return additional fields to form bas

Posted By:      Posted Date: September 27, 2010    Points: 0   Category :SharePoint

I received some much needed assistance from this forum in the past. My current situation is that I have a xml data connection to a sharepoint list over an employee database that works fine. It allow me to connect to a view on the sharepoint list correctly and display the info which is a drop down on a last name field. I now need to be able to select a last name such as Doe and have other fields such as job code be populated on the form from the same sharepoing list I have already connected to. Any direction is greatly appreciated.



View Complete Post

More Related Resource Links

how to duplicate fields on form data source?

I have many fields with similar names and same type. Is there any easy to copy and paste and then change field names? thanks,

fx Controls instead of Drop Down Lists for Lookup fields in InfoPath Secondary Data Connections


I have a secondary data connection with a lookup field into another list. To display the fields text value instead of the index, I am using a drop down list which gets its choices from the linked list. This information is read-only so I disabled the control via formatting rule.

A calculated value control might be better suited, but my XPath skills are not very "developed". Has anyone done this before? Taken the index from the bound field and extracted the text value from a second data connection? Thx


Linq join fields for return data


  how would I join fields together?

           return (from c in storedb.Product_Categories

                         where c.Category_Name.Contains(searchText)
                         orderby c.Category_Name
                         select new {
                                    c.Category_Key && " ;" && c.Category_Name // HOW CAN I DO THIS.....

Send an Email with User fields data entered in the form


Hi All,

          I have a form which have some user input fields(like textboxes,dropdownlists,textarea etc) fields and a submit button.

on click i need to send email with body contents as all the details entered by user in the form

Can anyone suggest how i should approach to this in sharepoint..

any code examples would be appreciated.


Need help on Select button column in Data Grid to populate fields in Form View


 When I have a select a row in a Data Grid that when I click on it I want it to show the info for the person I selected in a form view on the same page as the Data Grid. Here are the columns for the Data Grid that I have set up, the column is highlighted:

<asp:DataGrid ID="MHGrid" AutoGenerateColumns="False"  
        DataSourceID="MHFoundation" DataKeyField="POPULATION_LIST_ID" 
        AllowPaging="True" AllowSorting="True" BorderStyle="Solid" 
        BorderColor="#999999" BorderWidth="3px" CellPadding="4" PageSize="4" 
        CellSpacing="2" runat="server" BackColor="Gray" Font-Bold="False" 
        Font-Italic="False" Font-Overline="False" Font-Strikeout="False" 
        <SelectedItemStyle BackColor="#FF9900" Font-Bold="False" Font-Italic="False" 
            Font-Overline="False" Font-Strikeout="False" Font-Underline="False" />
            <asp:ButtonColumn CommandName="Select"  Text="Select"></asp:ButtonColumn>
            <asp:BoundColumn D

Dynamic data source for Data Form Web Part



I am using a data form web part which is using a rest service to fetch data from the List. Now my List is having different Views, and i want depending on a certain parameter can we make the datasource to fetch data from different views.

Any help is highly appreciated.



SSAS 2008 - The OLAP data source has no property fields available for this dimension


Last week I was able to view member properties for my Product Dimension in Excel 2010 pivot tables. Suddenly, without having made any changes to the dimension (for example, in the Attribute Relationships window of the dimension), those member properties are no longer available in Excel. I get the error "The OLAP data source has no property fields available for this dimension" when I try to select "Show Properties in Report" or "Show Properties in Tooltips" in the Pivot Table. At the same time, member properties are available for all other dimensions. I have also not made any changes to the data source connection in Excel and in any event, there is no option in the data source connection to enable or disable member property visibility. I am using BIDS 2008 and SQL Server 2008 R2 (10.50.1600.1). Does anybody have an idea why this might be happening?


Infopath form updating from secondary data connection initally, then not!


Let me set up what I am doing...

I have a table with multiple text boxes. Each of these text boxes pulls a total for it's corresponding item from a SharePoint List. Each item has 3 boxes that return three different totals.(Filters correctly into This week, This month, and Year to date).

When I open the InfoPath form initially all the columns return the correct totals. Now If I edit the date created on an item; so that it was created last month. Nothing changes on my infopath form. The created this month total remains the same.

I have my data connection set to update everytime a form is opened.

What am i missing?


Sorting or Grouping by "External Data" columns secondary fields - only possible for certain value ty


I have a BCS connection to an external system that provides various external data types.

I'm now adding an "External Data" column to a SharePoint list, selecting multiple fields of an external data type to be added as list columns. These fields have different data types, in my case string, DataTime and Boolean.

Editing the list view settings, I can only select the external entity as a whole, or it's Boolean fields for either "Sort By" or "Group By". The other fields are not offered for selection.

Is there any restrictions on which secondary fields of an external data type are supported for either sorting or grouping? Or is there something wrong in the definition of some of the external data type fields?

Thanks in advance for any help on this issue...

Provider selection gray, unable to change it in Data Source Creation


I am trying to create an Ad Hoc report project using SSRS2005.  We are using Oracle 10G and I have Visual Studio2005.

I have the Oracle client installed and I am an administrator.

I create a new "Report Model Project " and attempt to create a new data source, but with "Create a data source based on an existing or new connection " selected, I click on "new " where I should be able to specify the database, but the Provider shows "SqlClient Data Provider " and is grayed out so I can't change it.

How do I tell it I want to point to Oracle data?  I have no trouble normally doing this with an SSRS report but this is the first time I have tried an Ad Hoc report so I don't know what the problem is.

InfoPath: Copying values from a multiple-selection lookup (secondary data connection) to a multiple-

Trying to use "Set Field Value" action in InfoPath to set values in a multiple selection lookup field. Does not not seem to be possible. Has anyone achieved this?

InfoPath The data source referenced in the form template is not valid



When I try to upload form template that uses “Data Connection”,  I receive the following error any idea “The data source referenced in the form template is not valid or not found”

Any idea ?




InfoPath 2003 - Populate Data Field based on text field from secondary/different data source.


I have a form where the main fields are populated based on the results of a query field.
Ex, Main Data (SQL) Source: 

Fruit         Color
Apple       Red
Orange     Orange
Pear         Green
Banana     Yellow

Secondary Data Source (Sharepoint List)
Fruit         Code
Apple        1001
Orange     1002
Pear         1003
Banana     1004

What I would like to do is create form fields that will automatically populate based on the contents of the text field.
Ex,  (text field)   Please enter your fruit of choice:   [ Apple ]

(Field 2 - from main SQL data source)          The color of your fruit is [ RED ]

(Field 3 - from secondary Sharepoint List data source)  Your fruits code is  [ 1001 ]


Any suggestions would be greatly appreciated.

Secondary data source not refreshing



I am populating a drop down list using a secondary XML data source connected to a Sharepoint Contacts list.  The reason I am not retrieving the list directly is because I needed to sort the list alphabetically and this was the only way I could figure out how to do it.  The problem is that the connection is not refreshing the data in my browser form after I add more names to the Contacts list.  I DO have the "Automatically retrieve data when form is opened" box checked in the data connection options.  I am using MOSS 2007 and Infopath 2007.  Any ideas?


Only first row of a repeating table is being populated from a sharepoint list secondary data source


I have a reapeating table in maind atat source and I am trying to  populate it from values in a secondary data source, but when I am trying to do that it is only populating first row, leaving all other rows blank.


How to get this working..

ListView DataPager with SQL-Statements that already return only paged data.



As far as I understand the ListView-Control and the DataPager-Control, they work like this: The ListView gets its datarows from its data source, then the DataPager causes the ListView to display only a subset of those rows.

So what, when I want to use custom databinding for the ListView, that *already* gets the certain subset from SQL-Server (for better performance). Can I and how can I use the DataPager then?

Thanx, S.

Create ID (uniqueid?) from two fields when data is entered


I need to create an ID from two fields when they are entered into the db for the first time.  I thought Uniqueidentifer would do this, but it looks like uniqueidentifier is random and i have no control of the process. 

My user will enter 4 letters into a column called INIT and 4 numbers into a column called NUMB.  What I would like to do is create an id by combining those fields.

How can I do this?



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