Ajay Suri's Q&A profile

• Visual Studio Team System Improved - added ID and filter out Work Completed = 0

  ========================================== Update: Please see the post dated 9/28/2006 for a new request for help.   =========================================   I have a need to report developer hours by work item by week. I am attempting to use the warehouse filed "Current Work Item Microsoft_VSTS_Scheduling_CompletedWork" and add a "Date Week" perspective to it, but obviously that will only return the value of the " ...Show All

• .NET Development Help declaring Configuration converters

  All these msdn2 examples show standard and custom config converters. They show how to decorate props with them in code. When they show how to declare the converters directly in the config file section, all the examples show an undefined, not commented and ASFAIK undocumented ConfigurationConverters . This seems to be a collection of some sort. Where is it defined What items are in it Why is it declared in a comma delimited manner where the a ...Show All

• SQL Server Exec SQL Task: Capture return code of stored proc not working

  I am just trying to capture the return code from a stored proc as follows and if I get a 1 I want the SQL Task to follow a failure(red) constrainst workflow and send a SMTP mail task warning the customer. How do I achieve the Exec SQL Task portion of this, i get a strange error message [Execute SQL Task] Error: There is an invalid number of result bindings returned for the ResultSetType: "ResultSetType_SingleRow". Using OLEDB co ...Show All

• Windows Forms usign SUM with a where in datacolum expression

  Hi, I have a datacolumn and I have set its expression value as something liket this myColumn = new DataColumn( "OrderSum" ,System.Type.GetType( "System.Int16" ), "SUM(order_size)" ); The datatable I have has different columns including ordersize and orderid and itemID. Now, I want to set the expression property that Sums the order_size for the itemID of that row. Should look something like this ...Show All

• SQL Server for loop container to process all Excel files

     I'm having a problem getting the for loop container to process all excel files in a folder.  I set the collection folder to where my .xls files are, and i set a variable in the for loop container to the FileName.  I then changed my source connection and added expressions for ConnectionString: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + @[User::FileName] + ";Extended Properties=" +  @[User::ExtProperties] ( ...Show All

• Visual Basic Truncate Arrays

  I was wondering if anyone knows a way to truncate the initial part of an integers array. I can do that with a for loop that fills a shorter array starting from a specified index of the source array, but it takes ages so there must be another way... Thanks Leo    Leo13 wrote: I was wondering if anyone knows a way to truncate the initial part of an integers array. I can do that w ...Show All

• Visual Studio 2008 (Pre-release) Config schema has changed

  I understand that the configuration schema for services has changed. Now we should write : "name" instead of "type " < service name = "xxx But how should the name look like should it be : " type of the service , Display name " Like before when I take my old config and ONLY change "type" -> "name" I get the following error: "Service 'WCFCalculator.WCFCalc ...Show All

• Visual Basic VS 2005 IDE Unresponsive

  We had originally installed Beta 2 of the product which ran better than expected. After using the tool from MS to uninstall the beta software we then installed VS2005 Final which we downloaded through our msdn subscription. The IDE becomes just about unusable. Not only that but it pretty much renders the computer useless while it eats up CPU cycles. This occurs during the following conditions: 1.) We make a small change in code and the edi ...Show All

• Visual Studio Team System HTTPS or VPN to access TFS

  Hi, we have a couple of developers that work remotely a few days of the week. Currently we have a firebox router in the office and use MuVPN clients to connect to it. I was wondering whether we would be better off (would it be faster) to expose the TFS through HTTPS rather than use a VPN Does anyone do this, or not Why did you choose the solutions you have Thanks for your help Graham Note there are some other p ...Show All

• SQL Server Using UniqueIdentifier as Primary key

  Hello, is it a good idea to set an UniqueIdentifier field as primary key why i can't set an indentity specification How can i do Thanks a lot You can only specify an identity attribute for fixed precision data types and always returns an integer based value (i.e. non-decimal). For example int, bigint, numeric, etc. As for if it's a good idea to use a uniqueidentifier as the primary key, that's always up for debate, but yo ...Show All

• Visual Studio Express Editions Debugging a project

  Is it possible to activate JIT on the Express development platform It is time consuming to debug by running the .exe When the execution is halted by a so called fatal error, I think that the help could be better. The explanation is extremely technical; I just want to know what Basic line to correct and why in plain English. Example: Form.KeyDown event. Try forgetting writing e.Handled = True and see what you get of help. Help You are more confu ...Show All

• Visual C++ How to add print support in CformView

    Hi, I just create a MDI MFC application using CFormView as the base class for the application view.  It becomes a disaster when I want to print this form to printer.  According to the MSDN document: http://msdn.microsoft.com/library/default.asp url=/library/en-us/vccore/html/vcconcreatingforms-basedapplication.asp No printing support for a form-based application! I tried to add ON_COMMAND(ID_FILE_PRINT, OnFilePrint) ...Show All

• Visual Basic Visual Basic 2005 Express IDE Problem

  I have not been able to try out the Beta 2. First, I was having problems getting SQL Server to load but I finally was able to get help and resolve that problem. Now I have a problem with the IDE. Whenever I try to launch VB I get an error message that simply says "This program has encountered an error and must shut down". I get the usual options to report to Microsoft or not. When I click on the button to not report everything shuts down and I'm ...Show All

• Visual Studio Team System TFS Explorer and Solution Explorer - how they compare?

  Hi folks, i've been struggling with the idea of the TFS explorer and the Solution explorer. I've been programming with VS2002 and then VS2003 and have no problems understanding the Solution explorer in that piece of software. For example, we have 4 class libraries and 2 web applications in my main solution i use. Now with TFS explorer installed in my VS2005, i'm confussed between the two and the relationship of sourcesafe. For example, pre ...Show All

• Visual Studio How to get the Target name that is current been processed

  I want to know how I can get the Target name value that the Excecute method is executing. Task should not need information about target that is executing it. Logging should be done by loggers. Loggers gets information about tasks, targets, everything. If problem can't be solved by logging using TaskLoggingHelper functions you must do a separate logger. ...Show All