.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

format-number issues with the Data View Web Part in SharePoint 2010

Posted By:      Posted Date: September 13, 2010    Points: 0   Category :SharePoint
I have a number column named @Year_x0020_1_x0020_Revenue in the data view web part in SharePoint Designer 2010. In the Xpath expression builder - @Year_x0020_1_x0020_Revenue previews "500,000" If I use the format-number in the Xpath expression builder ==> format-number(@Year_x0020_1_x0020_Revenue, '$#,##0.00;-$#,##0.00'), it returns NaN. Is there any reason? 

View Complete Post

More Related Resource Links

Data View Web Part in SharePoint Designer 2010

Is Data View Web Part (aka Data Form Web Part) in the SharePoint 2010 has changed from the SharePoint 2007 or Is it working differently in the SharePoint Designer 2010? In SharePoint Designer 2007, whenever you have data view web part on the page, there is little handle to click on the top right of the data view web part to show Common Common Data View Tasks. Also for each cell, there was a handle to show xsl:value-of tasks which was great for formatting. Is that option is gone in the SharePoint Designer 2010?

How to get Email of Current User Data View Web Part Sharepoint 2010 and pass to WebService data sour

I have to pass in the email address of the current user to a web service data source (run time) of a Data View Web Part.

My Question is:

a) How can I get Email address of current user based  in DVWP.
I know we can get the CurrentUser using the CurrentUserName but how do we get the Email for the Current User.

b) After getting the Email how do we pass to the Web Service.

Creating a SharePoint 2010 Web Part That Can Read and Write Data to an External Data Source

Learn to use Visual Studio 2010 to create a Visual Web Part that uses a BCS external content type in SharePoint Server 2010 to read and write data to the AdventureWorks sample database.

Sample: Creating a SharePoint 2010 Web Part That Can Read and Write Data to an External Data Source

Explore the code in this visual how-to article as you learn to use Visual Studio 2010 to create a Visual Web Part that uses a BCS external content type in SharePoint Server 2010.

Quick Note: Accessing Data in a SharePoint 2010 Web Part by using LINQ

In this exercise, you develop and deploy a visual Web Part that reads data from two lists by using a LINQ query and displays it in a DataGrid control.

Sharepoint 2010 - RSS Viewer Web Part has some AJAX issues

Hi, I've this problem in RSS Viewer. If you select the "Enable Asynchronous Automatic Refresh?" checkbox, the Web Part will not render properly, but will give an error: "An unexpected error occured while rendering the webpart." Anybody ever had this problem? Tks,

Data-Bound Design: Create a Silverlight 4 Web Part for SharePoint 2010

When building custom SharePoint 2010 solutions, it makes a lot of sense to take advantage of Silverlight 4 on the front end. We'll walk you through the process of building a Silverlight Web Part with Visual Studio and Expression Blend.Paul StubbsMSDN Magazine September 2010

Calendar View for External Data List in SharePoint 2010?


I'd like to create a calendar view from data contained in an External List.  My external content type has a Start Date, End Date, and other calendar fields.  Is this possible using the out of the box BCS?

For extra credit - I'd like to then use this calendar as an overlay on other calendars within my SharePoint 2010 application.

Thanks for your help!

Content Query Web Part Sharepoint 2010 AND Customize the data presentation


In fields to display you have a Title field. We will like to show two columns (Section Name and Status) in the title field, but only the fist one is displayed in the result.We use this syntax:

Column [Group];Column [Group]

When I use this formula

Section Name [Agresso R&D Base Columns] ; Status [Agresso R&D Base Columns ]

in the title field, the Section Name is displayed, and no Status, When I use this formula

Status [Agresso R&D Base Columns ]; Section Name [Agresso R&D Base Columns] ;

in the title field the Status field is displayed, and no section name. Is this a bug? or is it an other way to show both columns in the title field?


Fields to display Depending on the scope of your query, you can select one or more site or list columns whose values you want to show in the display slots for this style. To specify a column from a particular group, type the name of the group in square brackets after the column name, for example, Column [Group]. Be sure to separate each column you enter with a semi-colon.


Are there any issues in SharePoint 2010 BCS when working with large data?



We are working on suggesting the best approach that would be suitable to support user data stored in SQL Server 2008. User data is huge (in Terabytes).

I need to understand if there are any issues using MOSS 2007 BDC or SharePoint 2010 BCS to interact with SQL Server 2008 database tables? I understand that BCS offers a no-code solution for interacting with SQL tables, however when handling such large data, can we have better performance if Stored Procedures and ADO.Net is used to fetch and update the data?

All in all I need to understand the pros and cons in both these approaches. Any pointers, specifically to related real world case studies shall highly be appreciated. Thanks much!

Data Form Web Part - Sharepoint Dropdown List as a field in Edit View - Possible?


Hi guys,

I'm building a Sharepoint page with a data form web part that uses custom SELECT and UPDATE statements with an SQL Server connection in order to retrieve and store records of information.

I'm getting along fine, records seem to update how they should etc, but I've ran into a problem with one thing: Sharepoint dropdownlists in 'Edit Template'

So the issue is this: if I replace a textbox field with a dropdown list that is populated with a separate SQL datasource, the dropdown list seems to be unable to show the current value of the field.

E.g. I have a dataview which has a field "FruitID", which I can update just fine by setting the ID value to different numbers. The SQL datasource uses the FruitID to display a list of all available Fruits, (e.g. 1 = Banana, 2 = Apple, 3 = Cherry, etc).

If i open the dataview in editmode, the default value in the dropdown is null, despite the real value of the field being "2", which should show "Apple" in the dropdown.

I can select a fruit and click save, and it will update just fine. But the initial display needs to show the correct value to start with.

Is there a custom binding I should be coding to make this work? I can't configure dropdown <items> on an individual level as they are populated from the SQL server. I can't set "SelectedI

Content Query Web Part missing in SharePoint 2010

If you don't see content query web part listed in the web parts list, this is because you have not enabled "Search Server Web Parts" feature in site collection features. Enable this feature and content query web part will show in the list of web parts.

Accessing SharePoint 2010 Data with Server-Side APIs

Accessing SharePoint data in server-side solutions is one of the most common tasks that you will perform as a SharePoint developer. SharePoint 2010 provides powerful server-side APIs that enable you to retrieve, add, edit, and delete SharePoint data programmatically. SharePoint 2010 also includes the new LINQ to SharePoint technology that enables you to work with SharePoint data efficiently and easily.

Office Add-Ins: 3 Solutions for Accessing SharePoint Data in Office 2010


SharePoint 2010 introduces a number of new ways to access business data and present it to the user. We'll show you several options that range from no-code solutions to fully integrated Office add-ins.

Donovan Follette , Paul Stubbs

MSDN Magazine July 2010

Sharepoint 2010 power tools visual sandboxed web part issue!!


Hi guys

I tried to use a simple hello world web part with with sharepoint power tools the solution is added ok but when I try to add the web part to the page I get this error "Unable to load assembly group. The user assembly group provider...." Any thoughts






How to create scrolling table for columns in a SharePoint Designer Data View


I have a fairly complex SharePoint Designer 2007 Data View they have added two more requirements.

1. Have the columns on the right side be able to scroll left to right as there is a large number of columns, while the first 3 columns on the left side stay locked in place.  This is only one list not two, and because of some other requirements I have it must remain to be just one list.

2. Then they also need to have scrolling up and down of the entire list with the headers locked in place.

The first requirement is more important than the second, but preferrably I need to do both.

I am new to XSL so not familar with the syntax. Is this something I can do on a custom Data View? Does anyone have any examples of how?

I have a drawing that show how it needs to look but I don't see an option here to upload a graphic.

So here is a link to my graphic example uploaded to my blog area: http://lindachapman.blogspot.com/  or just the image here: http://4.bp.blogspot.com/_aB01ue__NvQ/TGL42MOvrGI/AAAAAAAAAA4/c3xP4uCy4BU/s1600/Scrolling.png

I failed to mention that 3/4 of the columns are HTML Calculated fields wh

Add page numbers for paging in data view web part


Hello all,

Has anyone found a solution that will allow me to have page numbers for paging in a data view web part. For instance, if I have 40 items/rows and I set the paging to display 10 items, I'd like the paging to show 1 2 3 4 rather than showing 1-10 and having to click next over and over to get to a specific item.

I found this article, but it is for 2003 and doesn't seem to apply to 2007 or if it does I am not able to really figure out how.


Please help!

Thanks in advance.


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