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

Post New Web Links

BDC field returns wrong value in the Value Picker

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


I have a BDC entity in an application with multiple functioning entities but one of the entities is not behaving.

it returns a list of varchar(100) values and it works in application configuration tool when tested.

When I use the Picker, I see the values in the list but when I select a value and the picker closes, the value left in the control on the screen is not the value I selected "Technical" but a value I do not understand


no data in the table even resembles this value.  I have a hunch this is the word "Technical" in some encoded form.


Here is a snippet from the BDC definition

The GetAll method is the one that is causing the pain. 

any help would be greatly apreciated.


 I had to delete the top two methods to get this to post on this site.(they were the auto created methods from the BDC tool

The error w

View Complete Post

More Related Resource Links

Picker returns nothing for BDC column in custom list


Playing with the BDC for the first time, running into some issues adding a Business Data column to a custom list.

I believe my ADF file is solid. I've been able to import that just fine and can use the application to drive various BDC-specific webparts (a Business Data List or Business Data Item, for example). It also seems to work when I manually enter information in my NewForm.aspx field and click the Check Names button (it verifies my entry and underlines it, creates link to profile when I view the list data).


If I try to use the picker, I get nothing. Enter a name I know is valid or a % and click the magnifying glass icon and I very briefly get the "Please Wait" message, then just an empty set with "Type into the search box above then press "Enter" to start your search" where my results should be.

Any pointers? Thanks.

Activiate Email forwarding with Person Group Picker field

I have inserted 3 person group picker fiels.  I need to set them up so when a user selects a user, it shoots off an email.  I was told that I can set this up in SP designer via a workflow?  If so, can anyone let me know how to set this up properly? Thanks!  Bill KreuderIm a new MS CRM Consultant that is learing all things CRM. Im very excited about 4.0!!!!

SharePoint Search returns wrong date

Hi i am running a Sharepoint 2010 enterprise search indexing a file folder structure with emails(.eml) and attachments(.doc(x), pdf, xls(x), ...). The search results shows a date like first full index time or something like that, but not the date of file creation or any other attributes of the file. My questions: - what may be the reason of the wrong date? - is there a possibility use another attribute for displaying that is more relevante? Please help Kind regards Werner Durrer    

SQL 2008 External access returns wrong address for Report Manager

Hello, I have problems with the external access for report server. My report server is running in a local server on port 80, which can be accessed through http://servername/reports I have set up external access to the report server through http://servername.domain.com:8081/reports , so I set up a redirection from public port 8081 to port 80 on the local server. When I write the address http://servername.domain.com:8081/reports in a browser, I get asked for user authentication(Windows domain user), which is accepted, but after that I get an error because the URL automatically changes to http://servername.domain.com/Reports/Pages/Folder.aspx (without the port 8081) If I write http://servername.domain.com:8081/Reports/Pages/Folder.aspx , it works. I can see the report manager home page and browse through my reports. But there are some links in the page that are built improperly, since they still point to the wrong URL (without port 8081). These are e.g. the Help link, the Report Builder link, the Details view link.  So I think there is something wrong with the response the report server sends, when I write ".../Reports" and returns ".../Reports/Pages/Folders.aspx" I haven't found any configuration file or property where this response is specified, neither where the report

Lists - wrong field is nameing variable

I have created a list of applications which are installable via SCCM and the list is also used to raise new application packaging requests. What I am finding is that the workflow picks up the application developer as the name that is used in workflows, for example, if I raise a request for Microsoft Office Project 2010, the workflow comes back with "Please review Microsoft". How can I persuade the list and the workflow that it is the application name field I want brought back and not the company name? Regards Mark

How to set a string field with people picker control group

Hi Guys I have a problem with a form list, when I need to set a string field with de content of people picker control that have more than one "user". Is there any way to put in string a list of user like the people picker control shows in a form? The really problem is I don't know how to read an array of user in a formula rule. any example or idea should be appreciated. tnks.  

InputFormSection in a custom field renders on wrong position in 2010


Hi all,

i developed a custom field which uses InputFormSection and InputFormControl with CAMLRendering to render if a user adds it to a list:

<%@ Register TagPrefix="wssuc" TagName="InputFormSection" Src="/_controltemplates/InputFormSection.ascx" %>
<%@ Register TagPrefix="wssuc" TagName="InputFormControl" Src="/_controltemplates/InputFormControl.ascx" %>


Taxonomy Field Picker in Custom Webpart Property Panel.


Hi Guys,

How can i Use Taxonomy Field Picker like in Content Query Webpart Property Panel in Custom Webpart.



Thanks Ron

filling current user name in people picker field when loading form using javascript


Hello guys,

I am looking is there any way to fill the current user's name in people picker field in newform.aspx using javascript?

If you anything, please let me know 


Forms Library Changed event and Validation event returns empty string on date picker


Hi there,

I'm trying to do date validation on a date and time picker through code (i want to make sure that the date is later than today and that the next date is at least one day later than that).

But when i try to get the value in the chagned event, i keep getting empty string as value.

What am i doing wrong here??

This is the code:

public void LeaveRequestFrom_Changed(object sender, XmlEventArgs e)
      // Write your code here to change the main data source.
      XPathNavigator xroot = MainDataSource.CreateNavigator();
      XPathNavigator fromdate = xroot.SelectSingleNode(
        "/my:myFields/my:LeaveRequestFrom", NamespaceManager);

      if (fromdate.Value != "")
        //Make sure the from date is in the future
        if (DateTime.Parse(fromdate.Value) < DateTime.Today.AddDays(1))


The world

Date Field and Date Picker


I have a simple date field on form, it puts the date picker way out there, i.e., not next to the date field.  This is happening to all forms to capture data for lists.  How do I bring this right next to the date field?



Grouping gridview with gridhelper returns wrong row index



I'm using a GridView and GridViewHelper Class (http://www.agrinei.com/gridviewhelper/gridviewhelper_en.htm) for grouping the grid by desired field. On the grid I also include an "edit" RowCommand.



ID ... Name ... Company ... Year ... RowCommand



1 ... Alex ... Comp1 ... 1999 ... Edit

2 ... Jane ... Comp2 ... 1999 ... Edit


3 ... Mike ... Comp1 ... 1999 ... Edit

Now when I click edit in the second row of the grid (ID=1, the Group itself is shown in the first row) I have the following code on RowCommand:

// Convert the row index stored in the CommandArgument
                    // property to an Integer.
                    int index = Convert.ToInt32(e.CommandArgument);

                    // Retrieve the row that contains the button clicked 
                    // by the user from the Rows collection.
                    GridViewRow row = GridView1.Rows[index];

and the index returned is 0 instead of 1. Why? And how can I fix this, because the edit command returns error or points to the wrong records??<

Site content type's column with wrong field type that was created once will not work if re-created


I've created the column 'MyDescription' with type 'Multiline Enchanced Text' in my custom content type derived from 'Page'. But later I understood that 'Publishing HTML' is better for me. I've removed the 'MyDescription' column and recreated 'MyDescription' with type 'Publishing HTML'.

Page layout for my custom content type uses this code to display field

<PublishingWebControls:RichHtmlField FieldName="MyDescription" runat="server"/>

But page falls without any error information. I've deleted and recreated page: it fell always.

When I created column 'MyDescription1' with 'Publishing HTML' type in my custom content type and changed code to this


Infopath Question: XPath code to remove domain name from AccountID field in Person/Group Picker


I have an infopath email based submission form where I am using the Person/Group picker as a way for people to find people in the active directory to CC the form to. I was using the field "DisplayName" in the control and discovered that when you try to CC several employees, that it would disrupt the rules and you can't send the form.

I want to use the field "AccountID" but it includes the domain before the email alias (for ex. REDMOND\johndoe). Is there a formula code I could use to remove the domain from every email alias. Right now my CC formula is concat(SubmitterAlias, "; ", DisplayName)

ConfigurationManager.OpenExeConfiguration returns wrong config file on Home Server


I'm having an issue with
ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel) where it
opens the wrong .config file when running our app on Windows Home Server.
For example, say my application is installed to:

C:\Program Files\My Application Name\myapp.exe

...and there's a corresponding config file in that directory called:

C:\Program Files\My Application Name\myapp.exe.config

...under w2k, XP, and Vista,
returns myapp.exe.config. However, under Windows Home Server, using the
exact same codebase, I get the following path:

C:\Program Files\My Application Name\myapp.config

...which is a file that doesn't exist, and doesn't contain any of our
published application configuration details.

I've seen other issues people have had issues with
ConfigurationManager.OpenExeConfiguration, but it's typically with it adding
an extra ".config", so the returned file ends up being
"myapp.exe.config.config". Our issue is slightly different; our returned
file ends up being "myapp.config"; I've looked through the code for
ConfigurationManager.OpenExeConfiguration in reflector, but I'm still not
sure why it's return

DatePart(Week, @Date) Returns wrong weeknumber?

I notice the following results of query:
Declare			@Date1				DateTime
	,			@Date2				DateTime

Set				@Date1			=	'1/1/2010'
Set				@Date2			=	'1/4/2010'
Select			@Date1			As	Jan_1_2010
	,			DatePart(Week,	@Date1)	WeekJan_1_2010
	,			@Date2			As	Jan_4_2010
	,			DatePart(Week,	@Date2)	WeekJan_4_2010
	,			@@DateFirst		As	DateFirst

Jan_1_2010              WeekJan_1_2010 Jan_4_2010              WeekJan_4_2010 DateFirst
----------------------- -------------- ----------------------- -------------- ---------
2010-01-01 00:00:00.000              1 2010-01-04 00:00:00.000              2         7

(1 row(s) affected)

The weeknumber of 1/1/2010 should be 53 instead of 1
The weeknumber of 1/4/2010 should be 1 instead of 2
What can I do to obtain the correct result?
Thanks in advance, Jos

CAML query on Lookup field returns no items



I have a problem with a very simple CAML query that works on WSS 3, but not on SharePoint 2010. The query is:

<Where><Eq><FieldRef Name='CUSTTABLE' LookupId='TRUE' /><Value Type='Lookup'>5624</Value></Eq></Where>

Where CUSTTABLE is the lookup field and 5624 is the ID of the item that the lookup value points to.

This works fine on WSS 3 but on 2010 it returns no results, I expect 5 results as I manually created 5 items that points to the item in the other list.

I'm not getting any errors, and queries on other non-lookup fields work as expected.

I have also tried changing the Type='Lookup' to Type='Integer' as someone suggested that might be the problem.

Has something changed in 2010? What is my next steps to figuring this out....



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