.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

TFS cube - How to get the list describing remaining work, completed work history?

Posted By:      Posted Date: September 27, 2010    Points: 0   Category :Sql Server

I made a simple MDX query to get remaining work, completed work of all work items per revision number







    [Work Item].[System_Id].[System_Id] *

View Complete Post

More Related Resource Links

Workflow doesn't work anymore after renaming list

Hi All, I have created a list with the name "helpdesk test". After testing this list i renamed the list to "helpdesk". I did the rename by the list settings.  To this list i attached some workflows, with Sharepoint designer,  that have to start when a new item is created. All worked fine but after the rename the workflows don't work anymore. When i start the workflows manually from the list all works fine. Is there a way to rename a list and let the workflows work as before? Thanks in advance. Laurens.      

XML Viewer web part and SharePoint list RSS feed doesn't work

Hello, When I want to use the XML Viewer web part and set the XML URL to an RSS feed from a SharePoint list I get this error: Cannot retrieve the URL specified in the XML Link property. For more assistance, contact your site administrator. The URL I'm trying looks like this: http://sp2010/_layouts/listfeed.aspx?List=%7B76FD9EEE%2D9354%2D444E%2DBE3C%2DA9AE2C4B2063%7D I've seen blogpost that discuss this and they say that this is because of a security issue and that I have to enable anonymous access in order to display the RSS feed. Is this the only option there is ? I don't want to enable anonymous access on my SharePoint site. Why can't SharePoint just request the RSS feed with the credentials of the logged in user ? Or am I missing something here?

browser history do not work properly

Hi,  I have an ajax enabled asp.net 2.0 page. There are some updatepanels on it and I use the history control to enable the browser history buttons. For first time the AddHistoryPoint method adds a history point to my history control. That works, I think. But on Navigate event, the args.State will contain no key! There is no entry in the dictionary! Therefore my navigation function breaks. Has anybody some similar effect? Or better a solution! Thnxs.

list view connection filter doesn't work

  I have  a custom display form for documents library with two connected List View WebPart. I am trying to filter documents at the second list view with the value from the first one. Both list views contain data from the same documents library. I have configured the connection, but second list doesn’t display any item, and it doesn’t matter which field I use for filtering. Also  for another document s library’s custom  display form  it work perfect.But there second list view contain data from another documents library. Not the same as at first   case. Any ideas with my issue?

Report Model based on Analysis Services Cube doesn't work


Hi all,

I am working in BIDS and would like to create a Report Model based on a cube.

Creating a Data Source based on SSAS goes well, but when I want to make a Data Source View, the earlier created Data Source doesn't show up, which is necessary for the final resulting Report Model.

Could somebody help me out in solving this issue? (And also tell me why this is issue is rising?)


SQL Server 2008 & BIDS 2008 (Version 9.0.3x)

Item -level permision for list does not work as it should be.


Wondering if anyone have the same problem like me. I'm currently developing a centrelized document library for the whole company. For the safekeeping of documents, i use List Library  for user to keep all of their document for view but i set the item level permission for the edit access as a "only their own".

This work great a few week ago until i made some changes on the DefaultTemplate on the ..\12\TEMPLATE\CONTROLTEMPLATES. And as for now i found out the item level permision fail to work as what it should be. I do revert the changes on the Default template but still any user still can edit other's document..even with "none" as Edit access permision.

Any help in this matter is highly appreaciated.

Thank you


HttpRequest with list RSS does not work



I'm trying to fetch the output of a list RSS page with a HttpRequest object on a SharePoint site.
The SharePoint site is hosted elsewhere so I don't have any control over the settings there.

The RSS url of the list looks as follows (changed the hostname for this post):

When I open this in the browser it works OK.
When I try to open this URL through the HttpRequest object the URL is being redirected to this URL:

Which obviously gives the error that the list does not exist there.
Why would this happen? When I try to open the default.aspx page of this site (URL = http://someSharePointSite/NewsPortal/Pages/default.aspx) then it works OK even through code. The site is open for anonymous access, so an authentication issue can not be the cause here I think ? Even then it wouldn't make sense that I'm

SPListItem Update() does not work from list.Items collection.


Hi All,

Not working code:

using System;
using Microsoft.SharePoint;

namespace ConsoleApplication3

class Program

How exactly does a SharePoint 2010 External Content type / list work?



I'm trying BCS on an SQL table which contains about 300,000 rows. Following is what I've observed:

1. A "SELECT * FROM <TABLE>" query fired on the SQL Table using SQL Management Studio returns all the result in 12 seconds
2. The same data when accessed by browsing the default view of external list (to which an External Content Type (ECT) built over the same SQL table in SharePOint Designer 2010 is attached) takes about 3:14 minutes

If I edit the ECT (using SharePoint Designer) and set limit as 100,000, it takes about 49 seconds to load, and further reduction in limit reduces the time to load.

My questions are:

1. What is it that causes so much delay in accessing the rows, as SQL delivers them in 12 seconds? Can anyone please help me understand the BCS / ECT architecture- how it accesses data, etc.
2. Can I implement paging in ECTs created using SharePoint Designer 2010?

Any help shall highly be appreciated. Thans in advance!


Column filter in Business Data List web part does not work for all fields


I have a BDC entity whose fields contain a variety of data – numbers, dates and strings.  When I use the business data list web part I find that some of the columns’ dynamic filtering (accessed from the list’s column header) doesn’t work.  For these problem fields, the filter values load correctly but when I select a value all records disappear.  Initially I thought this was limited to just string columns but there is one string column that does filter correctly.

Here are some things that may be useful to know:

1.       The datasource is a SQL view and all fields are varchar(255)


RadioButton inside GridView, How to get it work as normal

Did you tried before to drag a RadioButton control inside a Gridivew templatefield, and then you attempt to select these RadioButtons , you will notice that the behavior of RadioButton control will be changed and it will work just like the behavior of checkbox control! the user will be able to select more than one radiobutton in the grid!

Looking for guidance: wanting to work with AJAX architecture



I'm starting a small website that will be backed by a database, and will allow a small number of users to authenticate and select an entry in the database, and then view (and optionally update) a corresponding entry (think master-detail).

I have some flexibility in how I'll do this, but I'd really like to incorperate some newer AJAX style coding, eliminating some page postbacks. I think this is a great opportunity to learn the concepts well.

I'll probably go with an ASP.NET 4.0 site. From what I've seen there are MANY ways to go about this:

-WCF Data Services to expose the data, and consume in ASP.NET

-Page methods to expose the data, separate method to update the data

-I'd rather avoid the UpdatePanel because I'm really looking for a full hands-on approach, with learning client side scripting being an objective as well.

Beyond that, it seems that one can use jQuery to build clientside templates, but also one can use the ASP.NET AJAX template engine (in ASP.NET 4.0 I believe).

A concern I have: users should only be able to work with the data exposed via these endpoints if they are logged into the website. Hopefully I can somehow reuse the ASP.NET forms authentication cookie for this purpose. 

Well, I hope I've posted enough to a

animate effect work but the render items are messed up.


Hi all,

     I have a very unique problem, humm i think. I am using a jquery effect that animate bounce effect, i have a line in my javascript pageLoad function $("#UserBrowserInfoDIV").show('bounce'); - the effects run smoothly but what it does is mess up the bolded text in the div. I have try the items inside the div without bolding and it works fine and no render problem but when bolded the text that are bolded is quite messed up, and barely readable.

Please let me know is there anything else i can do i really would like use this effect.

P.S all the effect have the same render problem, and i am using ie8 under compatibility mode.





Why getTreeNode does not work?



I try to run a  treeview example from msdn:


I also want to use code from


Here is my code:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<%@ Register TagPrefix="mytree"
Assembly="Microsoft.Web.UI.WebControls" %>
 <script type="text/javascript" language="javascript">

     function xxx() {

         var myNode = treeview_one.getTreeNode(treeview_one.selectedNodeIndex);


<form id="myform" runat="server">
<mytree:treeview id="treeview_one"  runat="server" Child

Category attribute of user control property does not work correctly in categories tab.



I have a User Control (ascx) and a property which a want to display in my categories tab in Visual Studio in the category named "Styles".

[Category("Styles"), DefaultValue(""), Description("The value for formating something.")]
public String MyFormatProperty
set { /* the code for set */; }
get { /* the code for get */; }

And here is the problem: Actually I do not need a get, because I only have to set the property (write only property). But when I omit the get, the property is displayed in the "Misc" category in the categories tab in Visual Studio. Only when I code the get as well, then the property is displayed correctly in the "Styles" category in the categories tab in Visual Studio.

Does anybody know why? How can I display the category correctly only with set?

Thanks, S.

Team System: Customizing Work Items


Team Foundation Server's work iIem tracking system provides a number of advanced customization options.This article explores custom control support that lets you link to date, enhance the user experience, present data, and more.

Brian A. Randell

MSDN Magazine October 2009

Peer Fun: A Peer-To-Peer Work Processing App With WCF


We demonstrate creating a peer-to-peer processing platform where multiple players function together for a common purpose: getting your work done.

Matt Neely

MSDN Magazine June 2009

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